R_CostElementGroupHierarchy

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 R_CostElementGroupHierarchy.
-- 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: RCOSTELMNTGRPH

CREATE VIEW R_CostElementGroupHierarchy AS
SELECT
  I_SetHeader.SetClass AS SetClass,
  cast (I_SetHeader.SetSubClass as fis_ktopl) AS ChartOfAccounts,
  cast (I_SetHeader.SetID as costelementgrouphierarchynode) AS CostElementGroupHierarchyNode,
  cast('' as costelementgrouphierarchynode) AS HierarchyParentNode,
  cast( '' as setsubcls) AS ParentSetSubClass,
  cast( 1 as abap.int4) AS HierarchyLevel,
  cast('' as kstar) AS CostElement,
  cast('' as kokrs) AS ControllingArea,
  cast(case when _CostElementGroupEndNode.CostElementGroupHierarchyNode is null then 'expanded' else 'leaf' end as abap.char( 10 )) as DrillState AS char10asDrillState,
  cast('R' as costelmntgrphiernodetypefilter) AS CostElmntGrpHierNodeTypeFilter,
  cast('' as ktext) as CostElementName AS CostElementGroupHierarchyNodekeySetClass,
  cast('expanded' as abap.char( 10 )) AS DrillState,
  cast('' as ktext) as CostElementName AS CostElementkeySetClass,
  _CostElement._Text[ Language = $session.system_language ].CostElementName AS CostElementName
FROM I_SetHeader
INNER JOIN I_CostElement AS _CostElement ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_Setnode, I_Setleaf
;