I_CO_FinStmntHierSubtree

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_CO_FinStmntHierSubtree.
-- 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.
-- Parameters: P_FinancialStatementVersion : versn_011

CREATE VIEW I_CO_FinStmntHierSubtree AS
SELECT
  HierarchySubtree.FinancialStatementHierarchy AS FinancialStatementHierarchy,
  HierarchySubtree.HierarchyNode AS HierarchyNode,
  HierarchySubtree.ValidityEndDate AS ValidityEndDate,
  cast( HierarchySubtree.ValidityStartDate as fis_datab preserving type ) AS ValidityStartDate,
  HierarchySubtree.HierarchyNodeText AS HierarchyNodeText,
  HierarchySubtree.GLAcctHierarchyNodeCategory AS GLAcctHierarchyNodeCategory,
  HierarchySubtree.ParentNode AS ParentNode,
  HierarchySubtree.NodeType AS NodeType,
  HierarchySubtree.FinancialStatementNodeType AS FinancialStatementNodeType,
  HierarchySubtree.HierarchyNodeSequence AS HierarchyNodeSequence,
  HierarchySubtree.HierarchyLevel AS HierarchyLevel
FROM P_CO_FinStmntHierSubtree
LEFT OUTER JOIN I_FinancialStatementHier AS _FinStmntHierarchy ON FinancialStatementHierarchy = _FinStmntHierarchy.FinancialStatementHierarchy AND ValidityEndDate = _FinStmntHierarchy.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_FinancialStatementHierNode AS _FinStmntHierNode ON FinancialStatementHierarchy = _FinStmntHierNode.FinancialStatementHierarchy AND HierarchyNode = _FinStmntHierNode.HierarchyNode AND ValidityEndDate = _FinStmntHierNode.ValidityEndDate  -- association [0..1]
;