SDRAFT_USER

Transparent Table Application Table
8 Fields 3 CDS Views

Draft Admin. Data User

SDRAFT_USER is an SAP database table in S/4HANA. Draft Admin. Data User. It contains 8 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_DRAFTADMIN_COLLABORATION_USR view_entity from Draft Administrative Data Collaboration User
I_DraftAdminDataUserAuth view_entity left_outer Coll. Draft User Authority
I_DraftAdministrativeUser view_entity from Draft Administrative Data Draft User

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY user_name sdraft_user_name Draft User Name
user_role sdraft_user_role Draft User Role
editing_state sdraft_user_editing_state Editing State
created_by sdraft_user_added_by Added by
last_change_ts sdraft_user_last_change_at Last Change by User Timestamp
last_changed_at sdraft_last_changed_at Draft Last Changed On
last_changed_by sdraft_last_changed_by Draft Last Changed By

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.

-- Draft Admin. Data User
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SDRAFT_USER (
    CLIENT,           -- Client [mandt]
    USER_NAME,        -- Draft User Name [sdraft_user_name]
    USER_ROLE,        -- Draft User Role [sdraft_user_role]
    EDITING_STATE,    -- Editing State [sdraft_user_editing_state]
    CREATED_BY,       -- Added by [sdraft_user_added_by]
    LAST_CHANGE_TS,   -- Last Change by User Timestamp [sdraft_user_last_change_at]
    LAST_CHANGED_AT,  -- Draft Last Changed On [sdraft_last_changed_at]
    LAST_CHANGED_BY,  -- Draft Last Changed By [sdraft_last_changed_by]
    PRIMARY KEY (CLIENT, USER_NAME)
);

Learn More