SDRAFT_ADMIN

Transparent Table Application Table
19 Fields 9 CDS Views

Draft Administrative Data

SDRAFT_ADMIN is an SAP database table in S/4HANA. Draft Administrative Data. It contains 19 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
I_CmmdtyOrdDraftAdminvData view from BASIC Order Request Draft Administrative Data
I_DRAFTADMIN_DATA view from Draft Administration Data
I_DraftAdminDataUserAuth view_entity from Coll. Draft User Authority
I_DraftAdminDataUserAuthExc view_entity from Excl. Draft User Authority
I_DraftAdministrativeData view from Draft Administration Data
I_DSP_MY_DRAFTS_BASE view_entity from DSP: My drafts base
I_PPS_DrftAdminDataBasic view_entity from BASIC PPS Administrative Data - Draft
I_SrcgEnvelopeParticipantVH view_entity inner BASIC Sourcing Envelope Participant
P_VCH_SIM_DRAFTADMINDATA view inner BASIC

Fields (19)

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)
principal_draft_entity SDRAFT_ENTITY_NAME Draft Entity ID
principal_draft_key SDRAFT_KEY Draft (Technical ID)
created_at SDRAFT_CREATED_AT Draft Created On
created_by SDRAFT_CREATED_BY Draft Created By
last_changed_at SDRAFT_LAST_CHANGED_AT Draft Last Changed On
last_changed_by SDRAFT_LAST_CHANGED_BY Draft Last Changed By
active_document_id SDRAFT_ACTIVE_DOCUMENT_ID Act. Doc. - Obj. ID
active_document_etag SDRAFT_ACTIVE_DOCUMENT_ETAG Active doc. ent. tag
access_type SDRAFT_ACCESS_TYPE Draft Access Type
in_process_by SDRAFT_IN_PROCESS_BY Draft In Process By
in_process_since SDRAFT_IN_PROCESS_SINCE Draft In Process Since
kept_by_user SDRAFT_KEPT_BY_USER Draft Is Kept By User
enqueue_context SDRAFT_ENQ_CONTEXT_ID Context ID
enqueue_since SDRAFT_ENQUEUE_SINCE Draft Locked Since
consistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
transformation_level SDRAFT_TRANSFORMATION_LEVEL Transformation Level

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 Administrative Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SDRAFT_ADMIN (
    CLIENT,                  -- Client [MANDT]
    DRAFT_ENTITY,            -- Draft Entity ID [SDRAFT_ENTITY_NAME]
    DRAFT_KEY,               -- Draft (Technical ID) [SDRAFT_KEY]
    PRINCIPAL_DRAFT_ENTITY,  -- Draft Entity ID [SDRAFT_ENTITY_NAME]
    PRINCIPAL_DRAFT_KEY,     -- Draft (Technical ID) [SDRAFT_KEY]
    CREATED_AT,              -- Draft Created On [SDRAFT_CREATED_AT]
    CREATED_BY,              -- Draft Created By [SDRAFT_CREATED_BY]
    LAST_CHANGED_AT,         -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    LAST_CHANGED_BY,         -- Draft Last Changed By [SDRAFT_LAST_CHANGED_BY]
    ACTIVE_DOCUMENT_ID,      -- Act. Doc. - Obj. ID [SDRAFT_ACTIVE_DOCUMENT_ID]
    ACTIVE_DOCUMENT_ETAG,    -- Active doc. ent. tag [SDRAFT_ACTIVE_DOCUMENT_ETAG]
    ACCESS_TYPE,             -- Draft Access Type [SDRAFT_ACCESS_TYPE]
    IN_PROCESS_BY,           -- Draft In Process By [SDRAFT_IN_PROCESS_BY]
    IN_PROCESS_SINCE,        -- Draft In Process Since [SDRAFT_IN_PROCESS_SINCE]
    KEPT_BY_USER,            -- Draft Is Kept By User [SDRAFT_KEPT_BY_USER]
    ENQUEUE_CONTEXT,         -- Context ID [SDRAFT_ENQ_CONTEXT_ID]
    ENQUEUE_SINCE,           -- Draft Locked Since [SDRAFT_ENQUEUE_SINCE]
    CONSISTENCYSTATUS,       -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    TRANSFORMATION_LEVEL,    -- Transformation Level [SDRAFT_TRANSFORMATION_LEVEL]
    PRIMARY KEY (CLIENT, DRAFT_ENTITY, DRAFT_KEY)
);

Learn More