LCM_DOCUMENT

Transparent Table Application Table

Document / attachment

LCM_DOCUMENT is an SAP database table in S/4HANA. Document / attachment. It contains 42 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_LegalDocument view from EXTENSION Exteneded View for Legal Document
I_LegalDocument view from BASIC Document

Fields (42)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY lglcntntmdocumentuuid LCM_UUID Universal Unique ID
lglcntntmdocument LCM_DOCUMENT_ID Document ID
lglcntntmdocumentlinkedobject DOKOB Object
lglcntntmdocumentlinkedobjkey LCM_UUID_C32 UUID Char32
lglcntntmdoccontenttype LCM_DOC_CONTENT_TYPE Content Type
lglcntntmlanguage LCM_LANGUAGE Language
lglcntntmdocumentistopversion BOOLE_D TRUE
documentdescription LCM_DESCRIPTION Doc. Name
lglcntntmismandatory LCM_IS_MANDATORY Is Mandatory
lglcntntmdocaccesslvl LCM_ACCESS_LVL Acs. Level
isendofpurposeblocked EOPBLOCKED Busin. Purp. Cmpltd.
lglcntntmcreatedutcdatetime LCM_CREATED_ON Created On
lglcntntmcreatedbyuser LCM_CREATED_BY Created By
lglcntntmchangedutcdatetime LCM_CHANGED_ON Changed On
lglcntntmchangedbyuser LCM_CHANGED_BY Changed By
legaltransaction LCM_LEGALTR_ID Legal Transaction ID
legaltransactionuuid LCM_UUID Universal Unique ID
lglcntntmparentdocument LCM_PARENT_DOCUMENT_ID Parent Document ID
_dataaging DATA_TEMPERATURE Data Aging
lglcntntmarchivestatus LCM_ARCHIVE_STATUS Data Arch Status
lglcntntmlongtextuuid LCM_LONGTEXT_ID Description UUID
legaldocumentsource LCM_DOC_SOURCE Legal Doc Source
dummy_lcm_document_incl_eew_ps CFD_DUMMY Dummy
internaldocumentstatus LCM_DOCUMENT_STATUS Status
lglcntntmsignaturedocstatus LCM_ESIGN_DOC_STATUS Sign Document Status
documentversion LCM_DOCUMENT_VERSION Docu. Version
legaldocumentversion LCM_DOC_VERSION_NUM Docu. Version
lglcntntmdoctype LCM_DOCUMENT_TYPE Document Type
lglcntntmtmpluuid LCM_TMPL_UUID Template UUID
lglcntntmvirtualdocverskey LCM_VIRTUAL_DOC_VERS_KEY Virtual Doc Version
lglcntntmcntxtdocuuid LCM_UUID Universal Unique ID
lglcntntmvirtualdocsyncsts LCM_VIRTUAL_DOC_SYNC_STATUS Doc Content Sync Sts
lglcntntmdocistobedeleted LCM_DOC_TO_BE_DELETED Doc. To Be Deleted
lglcntntmdocreferencenumber LCM_DOC_REFERENCE_NUM Reference Number
lglcntntmcntxtdocumentid LCM_CTX_DOC_ID Context Document ID
lglcntntmisintegrelevant LCM_IS_INTEG_RELEVANT Integrated
lglcntntmdoclowtouchlevel LCM_DOC_LOW_TOUCH_LEVEL Doc Low touch level
lglcntntmcreatedfromdocuuid LCM_UUID Universal Unique ID
lglcntntmnmbrofadminvdocupdt LCM_ADMIN_UPDATE_NMBR No of Admin Update
lglcntntmdocumentkind LCM_DOCUMENT_KIND Document Kind
lglcntntmdocpapertype LCM_DOC_PAPER_TYPE Paper Type

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.

-- Document / attachment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LCM_DOCUMENT (
    MANDT,                           -- Client [MANDT]
    LGLCNTNTMDOCUMENTUUID,           -- Universal Unique ID [LCM_UUID]
    LGLCNTNTMDOCUMENT,               -- Document ID [LCM_DOCUMENT_ID]
    LGLCNTNTMDOCUMENTLINKEDOBJECT,   -- Object [DOKOB]
    LGLCNTNTMDOCUMENTLINKEDOBJKEY,   -- UUID Char32 [LCM_UUID_C32]
    LGLCNTNTMDOCCONTENTTYPE,         -- Content Type [LCM_DOC_CONTENT_TYPE]
    LGLCNTNTMLANGUAGE,               -- Language [LCM_LANGUAGE]
    LGLCNTNTMDOCUMENTISTOPVERSION,   -- TRUE [BOOLE_D]
    DOCUMENTDESCRIPTION,             -- Doc. Name [LCM_DESCRIPTION]
    LGLCNTNTMISMANDATORY,            -- Is Mandatory [LCM_IS_MANDATORY]
    LGLCNTNTMDOCACCESSLVL,           -- Acs. Level [LCM_ACCESS_LVL]
    ISENDOFPURPOSEBLOCKED,           -- Busin. Purp. Cmpltd. [EOPBLOCKED]
    LGLCNTNTMCREATEDUTCDATETIME,     -- Created On [LCM_CREATED_ON]
    LGLCNTNTMCREATEDBYUSER,          -- Created By [LCM_CREATED_BY]
    LGLCNTNTMCHANGEDUTCDATETIME,     -- Changed On [LCM_CHANGED_ON]
    LGLCNTNTMCHANGEDBYUSER,          -- Changed By [LCM_CHANGED_BY]
    LEGALTRANSACTION,                -- Legal Transaction ID [LCM_LEGALTR_ID]
    LEGALTRANSACTIONUUID,            -- Universal Unique ID [LCM_UUID]
    LGLCNTNTMPARENTDOCUMENT,         -- Parent Document ID [LCM_PARENT_DOCUMENT_ID]
    _DATAAGING,                      -- Data Aging [DATA_TEMPERATURE]
    LGLCNTNTMARCHIVESTATUS,          -- Data Arch Status [LCM_ARCHIVE_STATUS]
    LGLCNTNTMLONGTEXTUUID,           -- Description UUID [LCM_LONGTEXT_ID]
    LEGALDOCUMENTSOURCE,             -- Legal Doc Source [LCM_DOC_SOURCE]
    DUMMY_LCM_DOCUMENT_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    INTERNALDOCUMENTSTATUS,          -- Status [LCM_DOCUMENT_STATUS]
    LGLCNTNTMSIGNATUREDOCSTATUS,     -- Sign Document Status [LCM_ESIGN_DOC_STATUS]
    DOCUMENTVERSION,                 -- Docu. Version [LCM_DOCUMENT_VERSION]
    LEGALDOCUMENTVERSION,            -- Docu. Version [LCM_DOC_VERSION_NUM]
    LGLCNTNTMDOCTYPE,                -- Document Type [LCM_DOCUMENT_TYPE]
    LGLCNTNTMTMPLUUID,               -- Template UUID [LCM_TMPL_UUID]
    LGLCNTNTMVIRTUALDOCVERSKEY,      -- Virtual Doc Version [LCM_VIRTUAL_DOC_VERS_KEY]
    LGLCNTNTMCNTXTDOCUUID,           -- Universal Unique ID [LCM_UUID]
    LGLCNTNTMVIRTUALDOCSYNCSTS,      -- Doc Content Sync Sts [LCM_VIRTUAL_DOC_SYNC_STATUS]
    LGLCNTNTMDOCISTOBEDELETED,       -- Doc. To Be Deleted [LCM_DOC_TO_BE_DELETED]
    LGLCNTNTMDOCREFERENCENUMBER,     -- Reference Number [LCM_DOC_REFERENCE_NUM]
    LGLCNTNTMCNTXTDOCUMENTID,        -- Context Document ID [LCM_CTX_DOC_ID]
    LGLCNTNTMISINTEGRELEVANT,        -- Integrated [LCM_IS_INTEG_RELEVANT]
    LGLCNTNTMDOCLOWTOUCHLEVEL,       -- Doc Low touch level [LCM_DOC_LOW_TOUCH_LEVEL]
    LGLCNTNTMCREATEDFROMDOCUUID,     -- Universal Unique ID [LCM_UUID]
    LGLCNTNTMNMBROFADMINVDOCUPDT,    -- No of Admin Update [LCM_ADMIN_UPDATE_NMBR]
    LGLCNTNTMDOCUMENTKIND,           -- Document Kind [LCM_DOCUMENT_KIND]
    LGLCNTNTMDOCPAPERTYPE,           -- Paper Type [LCM_DOC_PAPER_TYPE]
    PRIMARY KEY (MANDT, LGLCNTNTMDOCUMENTUUID)
);