C_Childgroup_Funded_prg

DDL: C_CHILDGROUP_FUNDED_PRG SQL: CCHILDFUNDEDGRP Type: view CONSUMPTION
11 Fields 1 Data Sources 1 Associations

Funded Program Child Group

C_Childgroup_Funded_prg is a Consumption CDS View that provides data about "Funded Program Child Group" in SAP S/4HANA. It reads from 1 data source (I_Setnode) and exposes 11 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 (8)

NameValueLevelField
AbapCatalog.sqlViewName CCHILDFUNDEDGRP view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Funded Program Child Group view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (11)

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
FinancialManagementArea

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_Childgroup_Funded_prg.
-- 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: CCHILDFUNDEDGRP

CREATE VIEW C_Childgroup_Funded_prg 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,
  cast ( substring( I_Setnode.SetSubClass, 1, 4 ) as fikrs preserving type ) AS FinancialManagementArea
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