SAP Table BIW_EMMA_CASE (Delta Queue for Process Statistics for Clarification Cases)
SAP table BIW_EMMA_CASE has 2 primary key fields being CLIENT,DELTA.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CLIENT | Client | CLNT | 3 | 0 | MANDT | ||||||||||||||||
| DELTA | GUID in 'RAW' format | RAW | 16 | 0 | GUID_16 | ||||||||||||||||
| CASE_GUID | GUID of Clarification Case | RAW | 16 | 0 | EMMA_CGUID | ||||||||||||||||
| CTYPE | Case Type | CHAR | 4 | 0 | EMMAC_CTYPE | EMMA_CTYPE | |||||||||||||||
| CCAT | Clarification Case Category | CHAR | 4 | 0 | EMMAC_CCAT_HDR | EMMA_CCAT | |||||||||||||||
| STATUS | Processing Status of Clarification Case | NUMC | 1 | 0 | EMMA_CSTATUS |
|
|||||||||||||||
| DUE_DATE | Case Due Date | DATS | 8 | 0 | EMMA_CDUEDATE | ||||||||||||||||
| BPGUID | GUID of Transaction/Process | RAW | 16 | 0 | EMMA_BPGUID | ||||||||||||||||
| BPAREA | Business Process Area | CHAR | 4 | 0 | EMMA_BPA | EMMA_BPAREA | |||||||||||||||
| BPCODE | Business Process Code | CHAR | 8 | 0 | EMMA_BPC | EMMA_BPCODE | |||||||||||||||
| CASENR | Clarification Case | CHAR | 10 | 0 | EMMA_CASE | EMMA_CNR | |||||||||||||||
| PRIO | Clarification Case Priority | CHAR | 1 | 0 | EMMA_CPRIO |
|
|||||||||||||||
| 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 | |||||||||||||||
| CURRPROC | Processor for Clarification Case | CHAR | 12 | 0 | USR02 | EMMA_CPROCESSOR | |||||||||||||||
| ORIG_DATE | Original Date of Clarification Case | DATS | 8 | 0 | EMMA_CORIGDATE | ||||||||||||||||
| CUSTSTATUS | Processing Substatus of Clarification Case | CHAR | 1 | 0 | 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 | ||||||||||||||||
| CONF_DATE | Confirmation Date of Clarification Case | DATS | 8 | 0 | EMMA_CCONFDATE | ||||||||||||||||
| UPDMODE | BW Delta Process: Record Mode | CHAR | 1 | 0 | RODMUPDMOD |
|
BIW_EMMA_CASE foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 BIW_EMMA_CASE | BPAREA | EMMA_BPA | Business Process Area | BPAREA |
| 1 BIW_EMMA_CASE | CANCODE | EMMAC_CANCODE | Reversal Reason | CLIENT |
| 1 BIW_EMMA_CASE | CANCODE | EMMAC_CANCODE | Reversal Reason | CANCODE |
| 0 BIW_EMMA_CASE | CASENR | EMMA_CASE | Clarification Case | CASENR |
| 1 BIW_EMMA_CASE | CTYPE | EMMAC_CTYPE | Case Types | CLIENT |
| 1 BIW_EMMA_CASE | CTYPE | EMMAC_CTYPE | Case Types | CTYPE |
| 0 BIW_EMMA_CASE | CURRPROC | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| 1 BIW_EMMA_CASE | PREVPROC | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| 0 BIW_EMMA_CASE | REACODE | EMMAC_CREACODE | Forwarding Reasons | CIENT |
| 0 BIW_EMMA_CASE | REACODE | EMMAC_CREACODE | Forwarding Reasons | REACODE |