LCM_DOCUMENT
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_LegalDocument | view | from | EXTENSION | Exteneded View for Legal Document |
| I_LegalDocument | view | from | BASIC | Document |
Fields (42)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA