SAP Tabel EMMA_CASE (Clarification Case)

SAP table EMMA_CASE has 2 primary key fields being CLIENT,CASENR.

Field Description Data Type Length Decimals Checktable Data Element
CLIENT Client CLNT 3 0 T000 MANDT
CASENR Clarification Case CHAR 10 0 EMMA_CNR
CASE_GUID GUID of Clarification Case RAW 16 0 EMMA_CGUID
RUNID Internal Job Number NUMC 10 0 EMMA_RUNID
INTNR Number of Job Interval INT4 10 0 EMMA_INTNR
LOGSYS Logical system CHAR 10 0 TBDLS LOGSYS
BPGUID GUID of Transaction/Process RAW 16 0 EMMA_BPGUID
BPCODE Business Process Code CHAR 8 0 EMMA_BPC EMMA_BPCODE
CTYPE Case Type CHAR 4 0 EMMAC_CTYPE EMMA_CTYPE
STATUS Processing Status of Clarification Case NUMC 1 0 EMMA_CSTATUS
1 New
2 In Process
3 Completed
4 Canceled
6 Confirmed
CCAT Clarification Case Category CHAR 4 0 EMMAC_CCAT_HDR EMMA_CCAT
PRIO Clarification Case Priority CHAR 1 0 EMMA_CPRIO
1 Very High
2 High
3 Average
4 Low
5 Very Low
PRIOORIG Origin of Priority CHAR 1 0 EMMA_CPORIG
0 Case Category
1 Priority Determination
2 Business Add-In COMPLETE_CASE
3 Manually
BRGRU Authorization Group CHAR 4 0 TBRG BRGRU
MAINOBJTYPE Object Type of Primary Business Object of Clarification Case CHAR 10 0 TOJTB EMMA_MAINOBJTYPE
MAINOBJKEY Object key CHAR 70 0 SWO_TYPEID
ORIG_DATE Original Date of Clarification Case DATS 8 0 EMMA_CORIGDATE
ORIG_TIME Creation Time of Clarification Case TIMS 6 0 EMMA_CORIGTIME
CURRPROC Processor for Clarification Case CHAR 12 0 USR02 EMMA_CPROCESSOR
REACODE Reason for Forwarding CHAR 4 0 EMMAC_CREACODE EMMA_CREACODE
CANCODE Reversal Reason CHAR 4 0 EMMAC_CANCODE EMMA_CANCODE
PREVPROC Previous Processor CHAR 12 0 USR02 EMMA_CPREVPROC
DUE_DATE Case Due Date DATS 8 0 EMMA_CDUEDATE
DUE_TIME Due Time of Clarification Case TIMS 6 0 EMMA_CDUETIME
XNOTE Note entered CHAR 1 0 EMMA_XNOTE
CASETXT Clarification Case Text CHAR 60 0 EMMA_CASETXT
FWM Method for Forwarding Clarification Cases CHAR 4 0 EMMA_FWM
CUSTSTATUS Processing Substatus of Clarification Case CHAR 1 0 EMMAC_CCSTATUS EMMA_CCUSTSTATUS
CREATED_DATE Date on which the record was created DATS 8 0 UDFDATE
CREATED_TIME Created At TIMS 6 0 UDFTIME
CREATED_BY Created by CHAR 12 0 UDFUSER
CHANGED_DATE Changed on DATS 8 0 UDLDATE
CHANGED_TIME Last Changed At TIMS 6 0 UDLTIME
CHANGED_BY Changed by CHAR 12 0 UDLUSER

EMMA_CASE foreign key relationships

Table Field Check Table Check Field
0 EMMA_CASE BRGRU TBRG Authorization groups MANDT
0 EMMA_CASE BRGRU TBRG Authorization groups BRGRU
1 EMMA_CASE CANCODE EMMAC_CANCODE Reversal Reason CLIENT
1 EMMA_CASE CANCODE EMMAC_CANCODE Reversal Reason CANCODE
0 EMMA_CASE CLIENT T000 Clients MANDT
1 EMMA_CASE CTYPE EMMAC_CTYPE Case Types CLIENT
1 EMMA_CASE CTYPE EMMAC_CTYPE Case Types CTYPE
0 EMMA_CASE CURRPROC USR02 Logon Data (Kernel-Side Use) BNAME
1 EMMA_CASE CUSTSTATUS EMMAC_CCSTATUS Custom Clarification Case Status CUSTSTATUS
0 EMMA_CASE LOGSYS TBDLS Logical system LOGSYS
1 EMMA_CASE MAINOBJTYPE TOJTB Business object repository: Basic data NAME
0 EMMA_CASE PREVPROC USR02 Logon Data (Kernel-Side Use) BNAME
1 EMMA_CASE REACODE EMMAC_CREACODE Forwarding Reasons CIENT
1 EMMA_CASE REACODE EMMAC_CREACODE Forwarding Reasons REACODE