/IAM/C_STPRFD

Transparent Table Customizing Table
5 Fields 3 CDS Views

Default Status for Status Profile

/IAM/C_STPRFD is an SAP database table in S/4HANA. Default Status for Status Profile. It contains 5 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ChangeRecdStatusBsc view_entity from BASIC Change Record Status
I_ChgMgmtUserStatusPrflFld view from BASIC Change Management User Sts Profile Field
I_CRUserStatusProField view from BASIC User Status Field

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY application /iam/application Application
KEY status_profile /iam/user_status_profile Status Profile
KEY status_field /iam/user_status_field UsrStatusField
user_status_initial /iam/user_status_initial InitUsrStatus

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.

-- Default Status for Status Profile
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /IAM/C_STPRFD (
    CLIENT,               -- Client [mandt]
    APPLICATION,          -- Application [/iam/application]
    STATUS_PROFILE,       -- Status Profile [/iam/user_status_profile]
    STATUS_FIELD,         -- UsrStatusField [/iam/user_status_field]
    USER_STATUS_INITIAL,  -- InitUsrStatus [/iam/user_status_initial]
    PRIMARY KEY (CLIENT, APPLICATION, STATUS_PROFILE, STATUS_FIELD)
);

Learn More