SAP Table EMMA_CASELIST_OUT
Case List Output Structure
EMMA_CASELIST_OUT (Case List Output Structure) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link EMMA_CASELIST_OUT to other SAP tables.
EMMA_CASELIST_OUT table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
LIGHT | CHAR | 4 | 0 | |||||||||||||||
CASENR | Clarification Case | EMMA_CNR | EMMA_CASE | CHAR | 10 | 0 | ||||||||||||
CASETXT | Clarification Case Text | EMMA_CASETXT | CHAR | 60 | 0 | |||||||||||||
CASE_GUID | GUID of Clarification Case | EMMA_CGUID | RAW | 16 | 0 | |||||||||||||
STATUS | Processing Status of Clarification Case | EMMA_CSTATUS | NUMC | 1 | 0 |
Possible values
|
||||||||||||
STATUSTXT | Status Text | EMMA_STATUSTXT | CHAR | 60 | 0 | |||||||||||||
RUNID | Internal Job Number | EMMA_RUNID | EMMA_HDR | NUMC | 10 | 0 | ||||||||||||
INTNR | Number of Job Interval | EMMA_INTNR | INT4 | 10 | 0 | |||||||||||||
LOGSYS | Logical system | LOGSYS | TBDLS | CHAR | 10 | 0 | ||||||||||||
BPGUID | GUID of Transaction/Process | EMMA_BPGUID | RAW | 16 | 0 | |||||||||||||
BPCODE | Business Process Code | EMMA_BPCODE | EMMA_BPC | CHAR | 8 | 0 | ||||||||||||
CTYPE | Case Type | EMMA_CTYPE | EMMAC_CTYPE | CHAR | 4 | 0 | ||||||||||||
CTYPETXT | Text for Case Type | EMMA_CTTXT | CHAR | 50 | 0 | |||||||||||||
CCAT | Clarification Case Category | EMMA_CCAT | EMMAC_CCAT_HDR | CHAR | 4 | 0 | ||||||||||||
CCATTXT | Short Text for Clarification Case Category | EMMA_CCTXT | CHAR | 50 | 0 | |||||||||||||
PRIO | Clarification Case Priority | EMMA_CPRIO | CHAR | 1 | 0 |
Possible values
|
||||||||||||
PRIOTXT | Case Priority | EMMA_CPTXT | CHAR | 60 | 0 | |||||||||||||
PRIOORIG | Origin of Priority | EMMA_CPORIG | CHAR | 1 | 0 |
Possible values
|
||||||||||||
PRIOORIGTXT | Text for Origin of Priority | EMMA_CPOTXT | CHAR | 60 | 0 | |||||||||||||
BRGRU | Authorization Group | BRGRU | TBRG | CHAR | 4 | 0 | ||||||||||||
MAINOBJTYPE | Object Type of Primary Business Object of Clarification Case | EMMA_MAINOBJTYPE | TOJTB | CHAR | 10 | 0 | ||||||||||||
OBJTYPETXT | Short Description of Object | EMMA_OJ_NTEXT | CHAR | 80 | 0 | |||||||||||||
MAINOBJKEY | Object key | SWO_TYPEID | CHAR | 70 | 0 | |||||||||||||
ORIG_DATE | Original Date of Clarification Case | EMMA_CORIGDATE | DATS | 8 | 0 | |||||||||||||
ORIG_TIME | Creation Time of Clarification Case | EMMA_CORIGTIME | TIMS | 6 | 0 | |||||||||||||
CURRPROC | Processor for Clarification Case | EMMA_CPROCESSOR | USR02 | CHAR | 12 | 0 | ||||||||||||
REACODE | Reason for Forwarding | EMMA_CREACODE | EMMAC_CREACODE | CHAR | 4 | 0 | ||||||||||||
REACODETXT | Forwarding Reason | EMMA_CODETXT | CHAR | 50 | 0 | |||||||||||||
CANCODE | Reversal Reason | EMMA_CANCODE | EMMAC_CANCODE | CHAR | 4 | 0 | ||||||||||||
PREVPROC | Previous Processor | EMMA_CPREVPROC | USR02 | CHAR | 12 | 0 | ||||||||||||
DUE_DATE | Case Due Date | EMMA_CDUEDATE | DATS | 8 | 0 | |||||||||||||
DUE_TIME | Due Time of Clarification Case | EMMA_CDUETIME | TIMS | 6 | 0 | |||||||||||||
CREATED_DATE | Date on which the record was created | UDFDATE | DATS | 8 | 0 | |||||||||||||
CREATED_TIME | Creation Time | UDFTIME | TIMS | 6 | 0 | |||||||||||||
CREATED_BY | Created by | UDFUSER | CHAR | 12 | 0 | |||||||||||||
CHANGED_DATE | Changed on | UDLDATE | DATS | 8 | 0 | |||||||||||||
CHANGED_TIME | Last changed at | UDLTIME | TIMS | 6 | 0 | |||||||||||||
CHANGED_BY | Changed by | UDLUSER | CHAR | 12 | 0 | |||||||||||||
BOX | Single-Character Indicator | CHAR1 | CHAR | 1 | 0 |
EMMA_CASELIST_OUT foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
EMMA_CASELIST_OUT | BPCODE | EMMA_CASELIST_OUT | BPCODE | EMMA_BPC | Business Process Code | BPCODE |
EMMA_CASELIST_OUT | BRGRU | SYST | MANDT | TBRG | Authorization groups | MANDT |
EMMA_CASELIST_OUT | BRGRU | 'B_EMMA_CAS' | TBRG | Authorization groups | BROBJ | |
EMMA_CASELIST_OUT | BRGRU | EMMA_CASELIST_OUT | BRGRU | TBRG | Authorization groups | BRGRU |
EMMA_CASELIST_OUT | CANCODE | SYST | MANDT | EMMAC_CANCODE | Reversal Reason | CLIENT |
EMMA_CASELIST_OUT | CANCODE | EMMA_CASELIST_OUT | CANCODE | EMMAC_CANCODE | Reversal Reason | CANCODE |
EMMA_CASELIST_OUT | CASENR | SYST | MANDT | EMMA_CASE | Clarification Case | CLIENT |
EMMA_CASELIST_OUT | CASENR | EMMA_CASELIST_OUT | CASENR | EMMA_CASE | Clarification Case | CASENR |
EMMA_CASELIST_OUT | CCAT | SYST | MANDT | EMMAC_CCAT_HDR | Clarification Case Categories | CLIENT |
EMMA_CASELIST_OUT | CCAT | EMMA_CASELIST_OUT | CCAT | EMMAC_CCAT_HDR | Clarification Case Categories | CCAT |
EMMA_CASELIST_OUT | CTYPE | SYST | MANDT | EMMAC_CTYPE | Case Types | CLIENT |
EMMA_CASELIST_OUT | CTYPE | EMMA_CASELIST_OUT | CTYPE | EMMAC_CTYPE | Case Types | CTYPE |
EMMA_CASELIST_OUT | CURRPROC | SYST | MANDT | USR02 | Logon Data (Kernel-Side Use) | MANDT |
EMMA_CASELIST_OUT | CURRPROC | EMMA_CASELIST_OUT | CURRPROC | USR02 | Logon Data (Kernel-Side Use) | BNAME |
EMMA_CASELIST_OUT | LOGSYS | EMMA_CASELIST_OUT | LOGSYS | TBDLS | Logical system | LOGSYS |
EMMA_CASELIST_OUT | MAINOBJTYPE | EMMA_CASELIST_OUT | MAINOBJTYPE | TOJTB | Business object repository: Basic data | NAME |
EMMA_CASELIST_OUT | PREVPROC | SYST | MANDT | USR02 | Logon Data (Kernel-Side Use) | MANDT |
EMMA_CASELIST_OUT | PREVPROC | EMMA_CASELIST_OUT | PREVPROC | USR02 | Logon Data (Kernel-Side Use) | BNAME |
EMMA_CASELIST_OUT | REACODE | SYST | MANDT | EMMAC_CREACODE | Forwarding Reasons | CIENT |
EMMA_CASELIST_OUT | REACODE | EMMA_CASELIST_OUT | REACODE | EMMAC_CREACODE | Forwarding Reasons | REACODE |
EMMA_CASELIST_OUT | RUNID | SYST | MANDT | EMMA_HDR | Prepared Application Logs | CLIENT |
EMMA_CASELIST_OUT | RUNID | EMMA_CASELIST_OUT | RUNID | EMMA_HDR | Prepared Application Logs | RUNID |