C_LCMCategoryValueHelp

DDL: C_LCMCATEGORYVALUEHELP SQL: CLCMCATVH Type: view CONSUMPTION
9 Fields 1 Data Sources

Value Help for LCM Category

C_LCMCategoryValueHelp is a Consumption CDS View that provides data about "Value Help for LCM Category" in SAP S/4HANA. It reads from 1 data source (I_LglCntntMCategory) and exposes 9 fields with key field LglCntntMCategory.

Data Sources (1)

SourceAliasJoin Type
I_LglCntntMCategory I_LglCntntMCategory from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CLCMCATVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.semanticKey LglCntntMCategory view
ObjectModel.representativeKey LglCntntMCategory view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Value Help for LCM Category view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMCategory LglCntntMCategory Category ID
LglCntntMCategoryName LglCntntMCategoryName Category Description
LglCntntMCategoryNameSyst LglCntntMCategoryNameSyst
LglCntntMCategoryNameInEnglish LglCntntMCategoryNameInEnglish
LglCntntMParentCategory LglCntntMParentCategory Parent Category ID
LglCntntMCatPurpose LglCntntMCatPurpose Category Purpose
LglCntntMParentCategoryText _LglCntntMParentCatAggrgn LglCntntMParentCategoryText
LglCntntMCatIsMultiSelection _LglCntntMParentCatAggrgn LglCntntMCatIsMultiSelection Multiple Selection
LglCntntMCategoryPath

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_LCMCategoryValueHelp.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CLCMCATVH

CREATE VIEW C_LCMCategoryValueHelp AS
SELECT
  LglCntntMCategory,
  LglCntntMCategoryName,
  LglCntntMCategoryNameSyst,
  LglCntntMCategoryNameInEnglish,
  LglCntntMParentCategory,
  LglCntntMCatPurpose,
  _LglCntntMParentCatAggrgn.LglCntntMParentCategoryText AS LglCntntMParentCategoryText,
  _LglCntntMParentCatAggrgn.LglCntntMCatIsMultiSelection AS LglCntntMCatIsMultiSelection,
  cast( '' as lcm_categ_path ) AS LglCntntMCategoryPath
FROM I_LglCntntMCategory
;

Learn More