C_IlmObjectGroupsTP

DDL: C_ILMOBJECTGROUPSTP SQL: CILMOBJGRPSTP Type: view

Consumption view for Object Groups

C_IlmObjectGroupsTP is a CDS View that provides data about "Consumption view for Object Groups" in SAP S/4HANA. It reads from 1 data source (I_IlmObjectGroupsTP) and exposes 7 fields with key fields ILMObjectGroup, Language, ILMObjectCategory, ILMPolicyCategory.

Data Sources (1)

SourceAliasJoin Type
I_IlmObjectGroupsTP ObjectGroups from

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CILMOBJGRPSTP view
AccessControl.authorizationCheck #NOT_REQUIRED view
OData.publish true view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
EndUserText.label Consumption view for Object Groups view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ILMObjectGroup ILMObjectGroup Object Group
KEY Language Language Report Text Language
KEY ILMObjectCategory ILMObjectCategory Object Category
KEY ILMPolicyCategory ILMPolicyCategory Policy Category
ILMObjectGroupDesc ILMObjectGroupDesc Description
NumberOfILMObjects _ilmobjectscount NumberOfILMObjects
NumberOfILMRuleGroups _rulegroupscount NumberOfILMRuleGroups

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_IlmObjectGroupsTP.
-- 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: CILMOBJGRPSTP
-- Parameters: P_Language : sylangu

CREATE VIEW C_IlmObjectGroupsTP AS
SELECT
  ILMObjectGroup,
  Language,
  ILMObjectCategory,
  ILMPolicyCategory,
  ILMObjectGroupDesc,
  _ilmobjectscount.NumberOfILMObjects AS NumberOfILMObjects,
  _rulegroupscount.NumberOfILMRuleGroups AS NumberOfILMRuleGroups
FROM I_IlmObjectGroupsTP AS ObjectGroups
;