EMMA_CASE

Transparent Table Application Table
35 Fields 2 CDS Views

Clarification Case

EMMA_CASE is an SAP database table in S/4HANA. Clarification Case. It contains 35 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_BPEMClrfctnCase view from EXTENSION BPEM Clarification Case - Extension
I_BPEMCase view from BASIC Klärungsfall

Fields (35)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY casenr EMMA_CNR Case
case_guid EMMA_CGUID Case GUID
runid EMMA_RUNID Int. Job Number
intnr EMMA_INTNR Interval Number
logsys LOGSYS Logical system
bpguid EMMA_BPGUID BusTrGUID
bpcode EMMA_BPCODE BusinessProcess
ctype EMMA_CTYPE Case Type
status EMMA_CSTATUS Status
ccat EMMA_CCAT Case Category
prio EMMA_CPRIO Case Priority
prioorig EMMA_CPORIG Priority Origin
brgru BRGRU Authorization
mainobjtype EMMA_MAINOBJTYPE Prim.ObjectType
mainobjkey SWO_TYPEID Key
orig_date EMMA_CORIGDATE Original Date
orig_time EMMA_CORIGTIME Original Time
currproc EMMA_CPROCESSOR Processor
reacode EMMA_CREACODE Forwarding Reason
cancode EMMA_CANCODE Reversal Reason
prevproc EMMA_CPREVPROC Prev. Processor
due_date EMMA_CDUEDATE Due Date
due_time EMMA_CDUETIME Due Time
xnote EMMA_XNOTE Note Entered
casetxt EMMA_CASETXT Case Text
fwm EMMA_FWM Forwarding Mthd
custstatus EMMA_CCUSTSTATUS Substatus
created_date UDFDATE Created On
created_time UDFTIME Created At
created_by UDFUSER Created by
changed_date UDLDATE Changed on
changed_time UDLTIME Changed At
changed_by UDLUSER Changed by
dummy_bpemclrfncs_incl_eew_ps E_BPEMCLRFNCS_INCL_EEW Dummy

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Clarification Case
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EMMA_CASE (
    CLIENT,                         -- Client [MANDT]
    CASENR,                         -- Case [EMMA_CNR]
    CASE_GUID,                      -- Case GUID [EMMA_CGUID]
    RUNID,                          -- Int. Job Number [EMMA_RUNID]
    INTNR,                          -- Interval Number [EMMA_INTNR]
    LOGSYS,                         -- Logical system [LOGSYS]
    BPGUID,                         -- BusTrGUID [EMMA_BPGUID]
    BPCODE,                         -- BusinessProcess [EMMA_BPCODE]
    CTYPE,                          -- Case Type [EMMA_CTYPE]
    STATUS,                         -- Status [EMMA_CSTATUS]
    CCAT,                           -- Case Category [EMMA_CCAT]
    PRIO,                           -- Case Priority [EMMA_CPRIO]
    PRIOORIG,                       -- Priority Origin [EMMA_CPORIG]
    BRGRU,                          -- Authorization [BRGRU]
    MAINOBJTYPE,                    -- Prim.ObjectType [EMMA_MAINOBJTYPE]
    MAINOBJKEY,                     -- Key [SWO_TYPEID]
    ORIG_DATE,                      -- Original Date [EMMA_CORIGDATE]
    ORIG_TIME,                      -- Original Time [EMMA_CORIGTIME]
    CURRPROC,                       -- Processor [EMMA_CPROCESSOR]
    REACODE,                        -- Forwarding Reason [EMMA_CREACODE]
    CANCODE,                        -- Reversal Reason [EMMA_CANCODE]
    PREVPROC,                       -- Prev. Processor [EMMA_CPREVPROC]
    DUE_DATE,                       -- Due Date [EMMA_CDUEDATE]
    DUE_TIME,                       -- Due Time [EMMA_CDUETIME]
    XNOTE,                          -- Note Entered [EMMA_XNOTE]
    CASETXT,                        -- Case Text [EMMA_CASETXT]
    FWM,                            -- Forwarding Mthd [EMMA_FWM]
    CUSTSTATUS,                     -- Substatus [EMMA_CCUSTSTATUS]
    CREATED_DATE,                   -- Created On [UDFDATE]
    CREATED_TIME,                   -- Created At [UDFTIME]
    CREATED_BY,                     -- Created by [UDFUSER]
    CHANGED_DATE,                   -- Changed on [UDLDATE]
    CHANGED_TIME,                   -- Changed At [UDLTIME]
    CHANGED_BY,                     -- Changed by [UDLUSER]
    DUMMY_BPEMCLRFNCS_INCL_EEW_PS,  -- Dummy [E_BPEMCLRFNCS_INCL_EEW]
    PRIMARY KEY (CLIENT, CASENR)
);

Learn More