LCM_TEMPLATE
Templates
LCM_TEMPLATE is an SAP database table in S/4HANA. Templates. It contains 21 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_LglCntntMTemplate | view | from | BASIC | Templates |
Fields (21)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | lglcntntmtmpluuid | lcm_tmpl_uuid | Template UUID | |||
| lglcntntmtmplextuuid | lcm_tmpl_ext_uuid | Template Ext UUID | ||||
| lglcntntmtmplextversuuid | lcm_tmpl_ext_vers_uuid | Ext Vers UUID of Tmp | ||||
| lglcntntmtmplextrevisionuuid | lcm_tmpl_ext_revision_uuid | External Revsn UUID | ||||
| lglcntntmtmplid | lcm_tmpl_id | Template ID | ||||
| lglcntntmtmplvers | lcm_tmpl_version | Template Version | ||||
| lglcntntmtmplextrevisionid | lcm_tmpl_ext_revision_id | External Revsn ID | ||||
| lglcntntmtmplname | lcm_tmpl_name | Template Name | ||||
| lglcntntmtmplvaldfrm | lcm_tmpl_valid_from | Valid From of Tmpl | ||||
| lglcntntmtmplvaldto | lcm_tmpl_valid_to | Valid To of Template | ||||
| lglcntntmtmplstskey | lcm_tmpl_sts_key | Template Status Key | ||||
| lglcntntmtmplcntnttype | lcm_doc_content_type | Content Type | ||||
| lglcntntmtmpllang | lcm_language | Language | ||||
| lglcntntmtmplownr | lcm_tmpl_owner | Template Owner | ||||
| lglcntntmtmplownreml | lcm_tmpl_owner_email | Owner E-Mail ID | ||||
| lglcntntmcreatedbyuser | lcm_tmpl_created_by | Created By | ||||
| lglcntntmcreatedutcdatetime | lcm_created_on | Created On | ||||
| lglcntntmchangedbyuser | lcm_tmpl_changed_by | Changed By | ||||
| lglcntntmchangedutcdatetime | lcm_changed_on | Changed On | ||||
| lglcntntmcreatedbyuser2 | lcm_tmpl_created_by | Created By |
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.
-- Templates
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LCM_TEMPLATE (
MANDT, -- Client [mandt]
LGLCNTNTMTMPLUUID, -- Template UUID [lcm_tmpl_uuid]
LGLCNTNTMTMPLEXTUUID, -- Template Ext UUID [lcm_tmpl_ext_uuid]
LGLCNTNTMTMPLEXTVERSUUID, -- Ext Vers UUID of Tmp [lcm_tmpl_ext_vers_uuid]
LGLCNTNTMTMPLEXTREVISIONUUID, -- External Revsn UUID [lcm_tmpl_ext_revision_uuid]
LGLCNTNTMTMPLID, -- Template ID [lcm_tmpl_id]
LGLCNTNTMTMPLVERS, -- Template Version [lcm_tmpl_version]
LGLCNTNTMTMPLEXTREVISIONID, -- External Revsn ID [lcm_tmpl_ext_revision_id]
LGLCNTNTMTMPLNAME, -- Template Name [lcm_tmpl_name]
LGLCNTNTMTMPLVALDFRM, -- Valid From of Tmpl [lcm_tmpl_valid_from]
LGLCNTNTMTMPLVALDTO, -- Valid To of Template [lcm_tmpl_valid_to]
LGLCNTNTMTMPLSTSKEY, -- Template Status Key [lcm_tmpl_sts_key]
LGLCNTNTMTMPLCNTNTTYPE, -- Content Type [lcm_doc_content_type]
LGLCNTNTMTMPLLANG, -- Language [lcm_language]
LGLCNTNTMTMPLOWNR, -- Template Owner [lcm_tmpl_owner]
LGLCNTNTMTMPLOWNREML, -- Owner E-Mail ID [lcm_tmpl_owner_email]
LGLCNTNTMCREATEDBYUSER, -- Created By [lcm_tmpl_created_by]
LGLCNTNTMCREATEDUTCDATETIME, -- Created On [lcm_created_on]
LGLCNTNTMCHANGEDBYUSER, -- Changed By [lcm_tmpl_changed_by]
LGLCNTNTMCHANGEDUTCDATETIME, -- Changed On [lcm_changed_on]
LGLCNTNTMCREATEDBYUSER2, -- Created By [lcm_tmpl_created_by]
PRIMARY KEY (MANDT, LGLCNTNTMTMPLUUID)
);
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