SCMGSTATPROFST

Transparent Table Customizing Table
5 Fields 6 CDS Views

Case: Text Table for Individual Status

SCMGSTATPROFST is an SAP database table in S/4HANA. Case: Text Table for Individual Status. It contains 5 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_CaseIndividualStatusText view from BASIC Case Individual Status Text
I_CaseIndivStatusText view from BASIC Case Individual Status - Text
I_InvgCsMCasePhaseText view from BASIC Basic View for ICM Case Phase Text
Udm_Attr_Key_View view left_outer Collections management attributes with FIN keys
udmo_dc_attr_view view left_outer
v_scmgstatprofst view from Texts for Individual Status

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY langu LANGU Language
KEY profile_id SCMGSTATUSPROFID Status Profile
KEY stat_orderno SCMGSTATUSONR Status
stat_ordno_descr SCMGSTAT_DESCR Status Descr.

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: Text Table for Individual Status
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SCMGSTATPROFST (
    CLIENT,            -- Client [MANDT]
    LANGU,             -- Language [LANGU]
    PROFILE_ID,        -- Status Profile [SCMGSTATUSPROFID]
    STAT_ORDERNO,      -- Status [SCMGSTATUSONR]
    STAT_ORDNO_DESCR,  -- Status Descr. [SCMGSTAT_DESCR]
    PRIMARY KEY (CLIENT, LANGU, PROFILE_ID, STAT_ORDERNO)
);

Learn More