DFKKLOCKS_DOC_D

Transparent Table Application Table
20 Fields 1 CDS Views

Draft table for entity R_CADocumentBPItemBusLockTP

DFKKLOCKS_DOC_D is an SAP database table in S/4HANA. Draft table for entity R_CADocumentBPItemBusLockTP. It contains 20 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_CADocumentBPItemBusLockDraft view_entity from BASIC Document BP Item Business Lock - Draft

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY cadocumentnumber opbel_kk Document Number
KEY carepetitionitemnumber opupw_kk Repetition Item
KEY cabpitemnumber opupk_kk Item
KEY casubitemnumber opupz_kk Subitem
KEY cabusinessprocess proid_kk Process
KEY cabusinesslockreason lockr_kk Lock Reason
KEY cabusinesslockvalidfrom fdate_kk From
KEY cabusinesslockvalidto tdate_kk To
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
rootdraftuuid sdraft_uuid Draft Document ID
cabusinesslocktext lock_comment_kk Comment
lastchangedbyuser syuname User Name
lastchangedate udatum Date
lastchangetime uzeit Time
cabusinessprocessforedit proid_kk Process
cabusinesslockreasonforedit lockr_kk Lock Reason
cabusinesslockvalidfromforedit fdate_kk From
cabusinesslockvalidtoforedit tdate_kk To

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 table for entity R_CADocumentBPItemBusLockTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKLOCKS_DOC_D (
    MANDT,                           -- Client [mandt]
    CADOCUMENTNUMBER,                -- Document Number [opbel_kk]
    CAREPETITIONITEMNUMBER,          -- Repetition Item [opupw_kk]
    CABPITEMNUMBER,                  -- Item [opupk_kk]
    CASUBITEMNUMBER,                 -- Subitem [opupz_kk]
    CABUSINESSPROCESS,               -- Process [proid_kk]
    CABUSINESSLOCKREASON,            -- Lock Reason [lockr_kk]
    CABUSINESSLOCKVALIDFROM,         -- From [fdate_kk]
    CABUSINESSLOCKVALIDTO,           -- To [tdate_kk]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                 -- Draft Document ID [sdraft_uuid]
    ROOTDRAFTUUID,                   -- Draft Document ID [sdraft_uuid]
    CABUSINESSLOCKTEXT,              -- Comment [lock_comment_kk]
    LASTCHANGEDBYUSER,               -- User Name [syuname]
    LASTCHANGEDATE,                  -- Date [udatum]
    LASTCHANGETIME,                  -- Time [uzeit]
    CABUSINESSPROCESSFOREDIT,        -- Process [proid_kk]
    CABUSINESSLOCKREASONFOREDIT,     -- Lock Reason [lockr_kk]
    CABUSINESSLOCKVALIDFROMFOREDIT,  -- From [fdate_kk]
    CABUSINESSLOCKVALIDTOFOREDIT,    -- To [tdate_kk]
    PRIMARY KEY (MANDT, CADOCUMENTNUMBER, CAREPETITIONITEMNUMBER, CABPITEMNUMBER, CASUBITEMNUMBER, CABUSINESSPROCESS, CABUSINESSLOCKREASON, CABUSINESSLOCKVALIDFROM, CABUSINESSLOCKVALIDTO, DRAFTUUID)
);

Learn More