EMMA_CASE

Transparent Table Application Table
28 Fields 1 CDS Views

Klärungsfall

EMMA_CASE is an SAP database table in S/4HANA. Klärungsfall. It contains 28 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BPEMCase view from BASIC Klärungsfall

Fields (28)

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

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.

-- Klärungsfall
-- 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]
    PRIMARY KEY (CLIENT, CASENR)
);

Learn More