I_LglCntntMParentCatAggrgn

DDL: I_LGLCNTNTMPARENTCATAGGRGN SQL: ILCMPARCATAGR Type: view COMPOSITE
10 Fields 2 Associations

Aggregations for LCM Parent Category

I_LglCntntMParentCatAggrgn is a Composite CDS View that provides data about "Aggregations for LCM Parent Category" in SAP S/4HANA. It has 2 associations to related views.

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_LglCntntMCategory _LglCntntMParentCategory $projection.LglCntntMParentCategory = _LglCntntMParentCategory.LglCntntMCategory
[1..1] I_LglCntntMCategory _LglCntntMRootCategory I_LglCntntMCategoryBasic.LglCntntMRootCategory = _LglCntntMRootCategory.LglCntntMCategory

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ILCMPARCATAGR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #CLIENT_DEPENDENT view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Aggregations for LCM Parent Category view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey LglCntntMParentCategory view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMParentCategory LglCntntMParentCategory Parent Category ID
LglCntntMParentCategoryName _LglCntntMParentCategory LglCntntMCategoryNameSyst
LglCntntMRootCategory LglCntntMRootCategory Root Category ID
LglCntntMRootCategoryName _LglCntntMRootCategory LglCntntMCategoryNameSyst
LglCntntMRootCatEnglishName
LglCntntMParCatSystName
LglCntntMParCatEnglishName
LglCntntMCatIsMultiSelection _LglCntntMParentCategory LglCntntMCatIsMultiSelection Multiple Selection
_LglCntntMParentCategory _LglCntntMParentCategory
_LglCntntMRootCategory _LglCntntMRootCategory

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 I_LglCntntMParentCatAggrgn.
-- 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: ILCMPARCATAGR

CREATE VIEW I_LglCntntMParentCatAggrgn AS
SELECT
  LglCntntMParentCategory,
  _LglCntntMParentCategory.LglCntntMCategoryNameSyst AS LglCntntMParentCategoryName,
  LglCntntMRootCategory,
  _LglCntntMRootCategory.LglCntntMCategoryNameSyst AS LglCntntMRootCategoryName,
  _LglCntntMRootCategory._LglCntntMCategoryText[1: Language = 'E'].LglCntntMCategoryName AS LglCntntMRootCatEnglishName,
  _LglCntntMParentCategory._LglCntntMCategoryText[1: Language = $session.system_language].LglCntntMCategoryName AS LglCntntMParCatSystName,
  _LglCntntMParentCategory._LglCntntMCategoryText[1: Language = 'E'].LglCntntMCategoryName AS LglCntntMParCatEnglishName,
  _LglCntntMParentCategory.LglCntntMCatIsMultiSelection AS LglCntntMCatIsMultiSelection
LEFT OUTER JOIN I_LglCntntMCategory AS _LglCntntMParentCategory ON LglCntntMParentCategory = _LglCntntMParentCategory.LglCntntMCategory  -- association [1..1]
LEFT OUTER JOIN I_LglCntntMCategory AS _LglCntntMRootCategory ON I_LglCntntMCategoryBasic.LglCntntMRootCategory = _LglCntntMRootCategory.LglCntntMCategory  -- association [1..1]
;

Learn More