DMS_DOC2LOIOCV_D

Transparent Table Application Table
35 Fields 1 CDS Views

Draft table for entity R_DOCUMENTINFORECORDATTCHTP

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_DocInfoRecdAttchCntntVersD view_entity from BASIC Doc Info Rec Attch Content Vers - Draft

Fields (35)

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 physicaldocument sdok_phid Phys. Document
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
fileuuid sysuuid_c UUID
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
isoriginalversionactive dappl Applic.
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
docinforecorddraftuuid sdraft_uuid Draft Document ID
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_DOC2LOIOCV_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]
    PHYSICALDOCUMENT,              -- Phys. Document [sdok_phid]
    DRAFTUUID,                     -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,               -- Draft Document ID [sdraft_uuid]
    FILEUUID,                      -- UUID [sysuuid_c]
    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]
    ISORIGINALVERSIONACTIVE,       -- Applic. [dappl]
    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]
    DOCINFORECORDDRAFTUUID,        -- Draft Document ID [sdraft_uuid]
    ATTACHMENTASURLLENGTH,         -- abap.int4
    ATTACHMENTASURL,               -- abap.lchr
    PRIMARY KEY (MANDT, DOCUMENTINFORECORDDOCTYPE, DOCUMENTINFORECORDDOCNUMBER, DOCUMENTINFORECORDDOCVERSION, DOCUMENTINFORECORDDOCPART, ORIGINALTYPE, DOCUMENTINDEX, LOGICALDOCUMENT, PHYSICALDOCUMENT, DRAFTUUID)
);

Learn More