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.
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
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
lglcntntmmainlinkdobjtype lcm_doc_main_linkd_obj_type Main Linked Obj Type
lglcntntmmainlinkedobject lcm_doc_main_linked_object
lglcntntmdoceffectivefromdate lcm_doc_effective_from_date Effective From
lglcntntmdocamendmenttype lcm_doc_amendment_type Amendment Type
lglcntntmsgntrpreference lcm_doc_sgntr_preference Signature Preference

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]
    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]
    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]
    LGLCNTNTMMAINLINKDOBJTYPE,      -- Main Linked Obj Type [lcm_doc_main_linkd_obj_type]
    LGLCNTNTMMAINLINKEDOBJECT,      -- lcm_doc_main_linked_object
    LGLCNTNTMDOCEFFECTIVEFROMDATE,  -- Effective From [lcm_doc_effective_from_date]
    LGLCNTNTMDOCAMENDMENTTYPE,      -- Amendment Type [lcm_doc_amendment_type]
    LGLCNTNTMSGNTRPREFERENCE,       -- Signature Preference [lcm_doc_sgntr_preference]
    PRIMARY KEY (MANDT, LGLCNTNTMDOCUMENTUUID)
);