LCM_CATEGORY

Transparent Table Application Table
20 Fields 1 CDS Views

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)

ViewTypeJoinVDMDescription
I_LglCntntMCategoryBasic view from BASIC LCM Categories basic data

Fields (20)

KeyField Data ElementDescription DomainTypeLength
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