LCM_CATEGORY
LCM Category
LCM_CATEGORY is an SAP database table in S/4HANA. LCM Category. It contains 20 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_LglCntntMCategoryBasic | view | from | BASIC | LCM Categories basic data |
Fields (20)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | lglcntntmcategory | lcm_category_id | Category ID | |||
| lglcntntmcatlevel | lcm_category_level | Category Level | ||||
| lglcntntmcattype | lcm_category_type | Category Type | ||||
| lglcntntmcatisselect | lcm_cat_is_selectable | Is Selectable | ||||
| lglcntntmcatismultiselection | lcm_cat_multi_select | Multiple Selection | ||||
| lglcntntmcatisobsolete | lcm_cat_is_obsolete | Obsolete | ||||
| lglcntntmparentcategory | lcm_parent_category_id | Parent Category ID | ||||
| lglcntntmrootcategory | lcm_root_category_id | Root Category ID | ||||
| lglcntntmcatmodel | lcm_model_source | Model for Dnmc. Ctg. | ||||
| lglcntntmcategoryvalue | lcm_category_value | Category Value | ||||
| lglcntntmlongtextuuid | lcm_longtext_id | Description UUID | ||||
| lglcntntmcatisupdatefromtable | lcm_is_update | Is Update From Table | ||||
| lglcntntmcreatedutcdatetime | lcm_created_on_21 | Created On | ||||
| lglcntntmcreatedbyuser | lcm_created_by | Created By | ||||
| lglcntntmchangedutcdatetime | lcm_changed_on | Changed On | ||||
| lglcntntmchangedbyuser | lcm_changed_by | Changed By | ||||
| lglcntntmcatpurpose | lcm_cat_purpose | Category Purpose | ||||
| lglcntntmcatissystgenerated | lcm_cat_sys_generated | System gen. category | ||||
| lglcntntmcatconstant | lcm_cat_constant | Category Qualifier |
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.
-- LCM Category
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LCM_CATEGORY (
MANDT, -- Client [mandt]
LGLCNTNTMCATEGORY, -- Category ID [lcm_category_id]
LGLCNTNTMCATLEVEL, -- Category Level [lcm_category_level]
LGLCNTNTMCATTYPE, -- Category Type [lcm_category_type]
LGLCNTNTMCATISSELECT, -- Is Selectable [lcm_cat_is_selectable]
LGLCNTNTMCATISMULTISELECTION, -- Multiple Selection [lcm_cat_multi_select]
LGLCNTNTMCATISOBSOLETE, -- Obsolete [lcm_cat_is_obsolete]
LGLCNTNTMPARENTCATEGORY, -- Parent Category ID [lcm_parent_category_id]
LGLCNTNTMROOTCATEGORY, -- Root Category ID [lcm_root_category_id]
LGLCNTNTMCATMODEL, -- Model for Dnmc. Ctg. [lcm_model_source]
LGLCNTNTMCATEGORYVALUE, -- Category Value [lcm_category_value]
LGLCNTNTMLONGTEXTUUID, -- Description UUID [lcm_longtext_id]
LGLCNTNTMCATISUPDATEFROMTABLE, -- Is Update From Table [lcm_is_update]
LGLCNTNTMCREATEDUTCDATETIME, -- Created On [lcm_created_on_21]
LGLCNTNTMCREATEDBYUSER, -- Created By [lcm_created_by]
LGLCNTNTMCHANGEDUTCDATETIME, -- Changed On [lcm_changed_on]
LGLCNTNTMCHANGEDBYUSER, -- Changed By [lcm_changed_by]
LGLCNTNTMCATPURPOSE, -- Category Purpose [lcm_cat_purpose]
LGLCNTNTMCATISSYSTGENERATED, -- System gen. category [lcm_cat_sys_generated]
LGLCNTNTMCATCONSTANT, -- Category Qualifier [lcm_cat_constant]
PRIMARY KEY (MANDT, LGLCNTNTMCATEGORY)
);
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