C_ChildGrantGroup

DDL: C_CHILDGRANTGROUP SQL: CCHILDGRANTGRP Type: view CONSUMPTION
10 Fields 1 Data Sources 1 Associations

Child Grant Group

C_ChildGrantGroup is a Consumption CDS View that provides data about "Child Grant Group" in SAP S/4HANA. It reads from 1 data source (I_Setnode) and exposes 10 fields with key fields SetClass, SetID, SetSubClass, SetLineNumber. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_Setnode I_Setnode from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_SetHeader _header $projection.ChildSetSubClass = _header.SetSubClass and $projection.ChildSetClass = _header.SetClass and $projection.ChildSetID = _header.SetID

Annotations (9)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CCHILDGRANTGRP view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Child Grant Group view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SetClass I_Setnode SetClass Set Class
KEY SetID I_Setnode SetID SETID
KEY SetSubClass I_Setnode SetSubClass Subclass
KEY SetLineNumber I_Setnode SetLineNumber Set Line
ChildSetSubClass I_Setnode ChildSetSubClass Subset Subclass
ChildSetClass I_Setnode ChildSetClass Subset Class
ChildSetID I_Setnode ChildSetID Child Group
CreatedByUser _header CreatedByUser Created By
CreationDate _header CreationDate Created On
SetDescription Child Group Description

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_ChildGrantGroup.
-- 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: CCHILDGRANTGRP

CREATE VIEW C_ChildGrantGroup AS
SELECT
  I_Setnode.SetClass AS SetClass,
  I_Setnode.SetID AS SetID,
  I_Setnode.SetSubClass AS SetSubClass,
  I_Setnode.SetLineNumber AS SetLineNumber,
  I_Setnode.ChildSetSubClass AS ChildSetSubClass,
  I_Setnode.ChildSetClass AS ChildSetClass,
  I_Setnode.ChildSetID AS ChildSetID,
  _header.CreatedByUser AS CreatedByUser,
  _header.CreationDate AS CreationDate,
  _header._SetHeaderText[1:Language=$session.system_language].SetDescription AS SetDescription
FROM I_Setnode
LEFT OUTER JOIN I_SetHeader AS _header ON ChildSetSubClass = _header.SetSubClass AND ChildSetClass = _header.SetClass AND ChildSetID = _header.SetID  -- association [0..1]
;

Learn More