/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