SCMGSTATPROFS

Transparent Table Customizing Table
7 Fields 3 CDS Views

Case: Individual Status

SCMGSTATPROFS is an SAP database table in S/4HANA. Case: Individual Status. It contains 7 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_Caseindividualstatus view from BASIC Case Individual Status
I_CaseIndivStatus view from BASIC Case Individual Status
I_InvgCsMCasePhase view from BASIC Basic View for ICM Case Phase

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.

-- Case: Individual Status
-- 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