I_XB_CostStatementReportNode

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_XB_CostStatementReportNode.
-- 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.

CREATE VIEW I_XB_CostStatementReportNode AS
SELECT
  XB_CostStatementHierarchy,
  UniversalHierNodeID,
  UniversalHierNodeParentID,
  UniversalHierVersValidTo AS ValidityEndDate,
  UniversalHierVersValidFrom AS ValidityStartDate,
  XB_CostStmntLeafReportingNode,
  UniversalHierNodeSequence
FROM P_XB_COSTSTATEMENTHIERNODE
LEFT OUTER JOIN I_XB_CostStatementReportNodeT AS _Text ON UniversalHierNodeID = _Text.UniversalHierNodeID  -- association [0..*]
LEFT OUTER JOIN I_XB_CostStmntLeafRptgNode AS _CostStatementLeafItem ON XB_CostStmntLeafReportingNode = _CostStatementLeafItem.XB_CostStmntLeafReportingNode  -- association [0..1]
LEFT OUTER JOIN I_XB_CostStatementHierarchy AS _Hierarchy ON XB_CostStatementHierarchy = _Hierarchy.XB_CostStatementHierarchy AND ValidityEndDate = _Hierarchy.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_XB_CostStatementReportNode AS _ParentNode ON XB_CostStatementHierarchy = _ParentNode.XB_CostStatementHierarchy AND ValidityEndDate = _ParentNode.ValidityEndDate AND UniversalHierNodeParentID = _ParentNode.UniversalHierNodeID  -- association [0..*]
;