SDRAFT_ADMIN_CC

Transparent Table Application Table
20 Fields 4 CDS Views

Draft Administrative Data Cross-Client

SDRAFT_ADMIN_CC is an SAP database table in S/4HANA. Draft Administrative Data Cross-Client. It contains 20 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_DraftAdminDataUserAuth_cc view_entity from Coll. Draft User Authority x-client
I_DraftAdminDataUserAuthExc_cc view_entity from Excl. Draft User Authority x-client
I_DraftAdministrativeData view union_all Draft Administration Data
I_DSP_MY_DRAFTS_BASE view_entity union DSP: My drafts base

Fields (20)

KeyField Data ElementDescription DomainTypeLength
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
created_by_client SDRAFT_USER_CLIENT Source Client
last_changed_by_client SDRAFT_USER_CLIENT Source Client

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 Cross-Client
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SDRAFT_ADMIN_CC (
    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]
    CREATED_BY_CLIENT,       -- Source Client [SDRAFT_USER_CLIENT]
    LAST_CHANGED_BY_CLIENT,  -- Source Client [SDRAFT_USER_CLIENT]
    PRIMARY KEY (DRAFT_ENTITY, DRAFT_KEY)
);

Learn More