CRMS4C_STATUS

Transparent Table Customizing Table
5 Fields 1 CDS Views

User Status mapping for Reporting

CRMS4C_STATUS is an SAP database table in S/4HANA. User Status mapping for Reporting. It contains 5 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CustMgmtLfcycUsrStsMapping view from BASIC Mapping of Lfcyc Sts to Usr Sts in Service

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY fieldname fieldname Field Name
KEY fieldvalue crms4_user_stat_lifecycle Unique Custom Status
KEY status_profile crm_j_stsma Status Profile
user_status crm_j_status Status

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.

-- User Status mapping for Reporting
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4C_STATUS (
    CLIENT,          -- Client [mandt]
    FIELDNAME,       -- Field Name [fieldname]
    FIELDVALUE,      -- Unique Custom Status [crms4_user_stat_lifecycle]
    STATUS_PROFILE,  -- Status Profile [crm_j_stsma]
    USER_STATUS,     -- Status [crm_j_status]
    PRIMARY KEY (CLIENT, FIELDNAME, FIELDVALUE, STATUS_PROFILE)
);

Learn More