C_GLAccountHierarchyNode

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_GLAccountHierarchyNode.
-- 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: CFIGLACCOUNTHN

CREATE VIEW C_GLAccountHierarchyNode AS
SELECT
  _Node.GLAccountHierarchy AS GLAccountHierarchy,
  _Node.HierarchyNode AS HierarchyNode,
  _Node.ValidityEndDate AS ValidityEndDate,
  ParentNode,
  HierarchyVersion,
  _Node.ValidityStartDate AS ValidityStartDate,
  _Node.ChartOfAccounts AS ChartOfAccounts,
  GLAccount,
  SequenceNumber,
  HierarchyNodeSequence,
  HierarchyNodeLevel,
  _Node.NodeType AS NodeType,
  _SemanticTag.SemanticTag AS SemanticTag
FROM I_GLAccountHierarchyNode AS _Node
INNER JOIN I_GLAccountHierarchy AS _Hierarchy ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_GLAcctHierNodeSemanticTag AS _SemanticTag ON _SemanticTag.GLAccountHierarchy = _Node.GLAccountHierarchy AND _SemanticTag.HierarchyNode = _Node.HierarchyNode AND _SemanticTag.ValidityEndDate = _Node.ValidityEndDate AND ( _SemanticTag.SemanticTag = 'ASSET' OR _SemanticTag.SemanticTag = 'LIAB_EQUIT' )  -- association [0..1]
LEFT OUTER JOIN C_GLAccountHierarchyNodeT AS _Text ON GLAccountHierarchy = _Text.GLAccountHierarchy AND HierarchyNode = _Text.HierarchyNode AND ValidityEndDate = _Text.ValidityEndDate AND GLAccount = ''  -- association [0..*]
;