/IAM/C_STAT

Transparent Table Customizing Table
4 Fields 12 CDS Views

Status for User Status Fields

/IAM/C_STAT is an SAP database table in S/4HANA. Status for User Status Fields. It contains 4 fields. 12 CDS views read from this table.

CDS Views using this table (12)

ViewTypeJoinVDMDescription
I_ChgMgmtUserStatus view from BASIC Change Management User Status
I_ChgMgmtUserStatus1 view from BASIC Change Management User Status 1
I_ChgMgmtUserStatus2 view from BASIC Change Management User Status 2
I_ChgMgmtUserStatus3 view from BASIC Change Management User Status 3
I_ChgMgmtUserStatus4 view from BASIC Change Management User Status 4
I_ChgMgmtUserStatus5 view from BASIC Change Management User Status 5
I_ChgRecordUserStatus view_entity from BASIC Change Record User Status
I_IssActyMgmtUserStatus1 view from BASIC User Status 1
I_IssActyMgmtUserStatus2 view from BASIC User Status 2
I_IssActyMgmtUserStatus3 view from BASIC User Status 3
I_IssActyMgmtUserStatus4 view from BASIC User Status 4
I_IssActyMgmtUserStatus5 view from BASIC User Status 5

Fields (4)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY status_field /IAM/USER_STATUS_FIELD UsrStatusField
KEY status /IAM/USER_STATUS User Status
inactive /IAM/INACTIVE Inactive

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.

-- Status for User Status Fields
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /IAM/C_STAT (
    CLIENT,        -- Client [MANDT]
    STATUS_FIELD,  -- UsrStatusField [/IAM/USER_STATUS_FIELD]
    STATUS,        -- User Status [/IAM/USER_STATUS]
    INACTIVE,      -- Inactive [/IAM/INACTIVE]
    PRIMARY KEY (CLIENT, STATUS_FIELD, STATUS)
);

Learn More