SCMGSTATPROFS

Transparent Table Customizing Table
7 Fields 2 CDS Views

Fall: Einzelstatus

SCMGSTATPROFS is an SAP database table in S/4HANA. Fall: Einzelstatus. It contains 7 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_Caseindividualstatus view from BASIC Case Individual Status
I_CaseIndivStatus view from BASIC Case Individual Status

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY profile_id scmgstatusprofid Status Profile
KEY stat_orderno scmgstatusonr Status
stat_para scmgstatpara System Status
stat_orderno_l scmgstatusonr_l Lowest Status
stat_orderno_h scmgstatusonr_h Highest Status
wf_event scmgevent Case Event

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.

-- Fall: Einzelstatus
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SCMGSTATPROFS (
    CLIENT,          -- Client [mandt]
    PROFILE_ID,      -- Status Profile [scmgstatusprofid]
    STAT_ORDERNO,    -- Status [scmgstatusonr]
    STAT_PARA,       -- System Status [scmgstatpara]
    STAT_ORDERNO_L,  -- Lowest Status [scmgstatusonr_l]
    STAT_ORDERNO_H,  -- Highest Status [scmgstatusonr_h]
    WF_EVENT,        -- Case Event [scmgevent]
    PRIMARY KEY (CLIENT, PROFILE_ID, STAT_ORDERNO)
);

Learn More