I_CO_GLAccountHierSubtree

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_GLAccountHierSubtree.
-- 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_GLAccountHierSubtree AS
SELECT
  GLAccount.GLAccountHierarchy AS GLAccountHierarchy,
  GLAccount.HierarchyNode AS HierarchyNode,
  cast( left( GLAccount.GLAccount, 10 ) as fis_racct preserving type ) AS GLAccount,
  cast( left( GLAccount.ChartOfAccounts, 4 ) as fis_ktopl preserving type ) AS ChartOfAccounts,
  GLAccount.ValidityEndDate AS ValidityEndDate,
  Hierarchy.GLAcctHierarchyNodeCategory AS GLAcctHierarchyNodeCategory,
  Hierarchy.NodeType AS NodeType
FROM I_GLAccountHierSubTree AS GLAccount
INNER JOIN I_CO_FinStmntHierSubtree ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_GLAccountHierarchy AS _GLAccountHierarchy ON GLAccountHierarchy = _GLAccountHierarchy.GLAccountHierarchy AND ValidityEndDate = _GLAccountHierarchy.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_GLAccountHierarchyNode AS _GLAccountHierarchyNode ON GLAccountHierarchy = _GLAccountHierarchyNode.GLAccountHierarchy AND HierarchyNode = _GLAccountHierarchyNode.HierarchyNode AND ValidityEndDate = _GLAccountHierarchyNode.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
;