DMS_DOC2LOIO_D

Transparent Table Application Table
39 Fields 1 CDS Views

Draft table for entity R_DOCUMENTINFORECORDATTCHTP

DMS_DOC2LOIO_D is an SAP database table in S/4HANA. Draft table for entity R_DOCUMENTINFORECORDATTCHTP. It contains 39 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_DocumentInfoRecordAttchDraft view_entity from BASIC Document Info Record Attachment - Draft

Fields (39)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY documentinforecorddoctype DOKAR Document Type
KEY documentinforecorddocnumber DOKNR Document
KEY documentinforecorddocversion DOKVR Doc. Version
KEY documentinforecorddocpart DOKTL_D Document Part
KEY originaltype DMS_FILE_TYPE Original type
KEY documentindex DMS_DOC_INDEX Counter
KEY logicaldocument SDOK_LOID Log. document
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
fileuuid SYSUUID_C UUID
physicaldocument SDOK_PHID Phys. Document
filename FILEP Original
filedescription SDOK_DESCR Description
mimetype W3CONTTYPE MIME type
workstationapplication DAPPL Applic.
storagecategory SDOK_STCAT Category
internalcomment SDOK_COMMT Comment
filesize abap.char
logicaldocumentisreference abap.char
logicaldocumentclass SDOK_LOCL LOIO class
physicaldoctechnicalstatus SDOK_PHSTA Tech. Status
documenttitle SDOK_TITEL Title
documentformat SDOK_FORM Document format
originalisprotected CVFLAG Flag
originalcheckedoutuser SDOK_CKUSR Agent
originalcheckedouttime TZNTSTMPS Time Stamp
creationdatetime TZNTSTMPS Time Stamp
createdbyuser SDOK_CRUSR Created By
changeddatetime TZNTSTMPS Time Stamp
lastchangedbyuser SDOK_CHUSR Last Changed By
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes
attachmentasurllength abap.int4
attachmentasurl abap.lchr

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_DOCUMENTINFORECORDATTCHTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DMS_DOC2LOIO_D (
    MANDT,                          -- Client [MANDT]
    DOCUMENTINFORECORDDOCTYPE,      -- Document Type [DOKAR]
    DOCUMENTINFORECORDDOCNUMBER,    -- Document [DOKNR]
    DOCUMENTINFORECORDDOCVERSION,   -- Doc. Version [DOKVR]
    DOCUMENTINFORECORDDOCPART,      -- Document Part [DOKTL_D]
    ORIGINALTYPE,                   -- Original type [DMS_FILE_TYPE]
    DOCUMENTINDEX,                  -- Counter [DMS_DOC_INDEX]
    LOGICALDOCUMENT,                -- Log. document [SDOK_LOID]
    DRAFTUUID,                      -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                -- Draft Document ID [SDRAFT_UUID]
    FILEUUID,                       -- UUID [SYSUUID_C]
    PHYSICALDOCUMENT,               -- Phys. Document [SDOK_PHID]
    FILENAME,                       -- Original [FILEP]
    FILEDESCRIPTION,                -- Description [SDOK_DESCR]
    MIMETYPE,                       -- MIME type [W3CONTTYPE]
    WORKSTATIONAPPLICATION,         -- Applic. [DAPPL]
    STORAGECATEGORY,                -- Category [SDOK_STCAT]
    INTERNALCOMMENT,                -- Comment [SDOK_COMMT]
    FILESIZE,                       -- abap.char
    LOGICALDOCUMENTISREFERENCE,     -- abap.char
    LOGICALDOCUMENTCLASS,           -- LOIO class [SDOK_LOCL]
    PHYSICALDOCTECHNICALSTATUS,     -- Tech. Status [SDOK_PHSTA]
    DOCUMENTTITLE,                  -- Title [SDOK_TITEL]
    DOCUMENTFORMAT,                 -- Document format [SDOK_FORM]
    ORIGINALISPROTECTED,            -- Flag [CVFLAG]
    ORIGINALCHECKEDOUTUSER,         -- Agent [SDOK_CKUSR]
    ORIGINALCHECKEDOUTTIME,         -- Time Stamp [TZNTSTMPS]
    CREATIONDATETIME,               -- Time Stamp [TZNTSTMPS]
    CREATEDBYUSER,                  -- Created By [SDOK_CRUSR]
    CHANGEDDATETIME,                -- Time Stamp [TZNTSTMPS]
    LASTCHANGEDBYUSER,              -- Last Changed By [SDOK_CHUSR]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    ATTACHMENTASURLLENGTH,          -- abap.int4
    ATTACHMENTASURL,                -- abap.lchr
    PRIMARY KEY (MANDT, DOCUMENTINFORECORDDOCTYPE, DOCUMENTINFORECORDDOCNUMBER, DOCUMENTINFORECORDDOCVERSION, DOCUMENTINFORECORDDOCPART, ORIGINALTYPE, DOCUMENTINDEX, LOGICALDOCUMENT, DRAFTUUID)
);

Learn More