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
1 New
2 In Process
3 Completed
4 Canceled
6 Confirmed
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
1 Very High
2 High
3 Average
4 Low
5 Very Low
PRIOTXT Case Priority EMMA_CPTXT CHAR 60 0
PRIOORIG Origin of Priority EMMA_CPORIG CHAR 1 0
0 Case Category
1 Priority Determination
2 Business Add-In COMPLETE_CASE
3 Manually
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