SCMG_T_CASE

Transparent Table Application Table

Case: Entity Table for Case

SCMG_T_CASE is an SAP database table in S/4HANA. Case: Entity Table for Case. It contains 5 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_Caseentity view from BASIC Case Entiry

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY case_guid SCMG_CASE_GUID Case Key
record_pdir SCMG_RECORD_PDIR_ID Record POID ID
note_pdir SCMG_NOTE_PDIR_ID Note POID ID
wfpthid SRMWFPTHID Route ID

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.

-- Case: Entity Table for Case
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SCMG_T_CASE (
    MANDT,        -- Client [MANDT]
    CASE_GUID,    -- Case Key [SCMG_CASE_GUID]
    RECORD_PDIR,  -- Record POID ID [SCMG_RECORD_PDIR_ID]
    NOTE_PDIR,    -- Note POID ID [SCMG_NOTE_PDIR_ID]
    WFPTHID,      -- Route ID [SRMWFPTHID]
    PRIMARY KEY (MANDT, CASE_GUID)
);