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. | ||||
| 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)
);
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