SDRAFT_USER

Transparent Table Application Table
10 Fields 3 CDS Views

Draft Admin. Data User

SDRAFT_USER is an SAP database table in S/4HANA. Draft Admin. Data User. It contains 10 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 (10)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY draft_entity SDRAFT_ENTITY_NAME Draft Entity ID
KEY draft_key SDRAFT_KEY Draft (Technical ID)
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]
    DRAFT_ENTITY,     -- Draft Entity ID [SDRAFT_ENTITY_NAME]
    DRAFT_KEY,        -- Draft (Technical ID) [SDRAFT_KEY]
    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, DRAFT_ENTITY, DRAFT_KEY, USER_NAME)
);

Learn More