FISVD_HRRP_NODE_DEX

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 FISVD_HRRP_NODE_DEX.
-- 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 FISVD_HRRP_NODE_DEX AS
SELECT
  hrrp_node.hryid AS GLAccountHierarchy,
  hrrp_node.hrynode AS HierarchyNode,
  hrrp_node.hryvalto AS ValidityEndDate,
  hrrp_node.nodecls AS ChartOfAccounts,
  hrrp_node.hryver AS HierarchyVersion,
  hrrp_node.parnode AS HierarchyParentNode,
  hrrp_node.hryvalfrom AS ValidityStartDate,
  hrrp_node.nodetype AS HierarchyNodeType,
  hrrp_node.nodevalue AS GLAccount,
  hrrp_node.balind AS BalanceIndicator
FROM hrrp_node
LEFT OUTER JOIN I_GLAccountHierarchyNode AS _GLAccountHierarchyNode ON GLAccountHierarchy = _GLAccountHierarchyNode.GLAccountHierarchy AND HierarchyNode = _GLAccountHierarchyNode.HierarchyNode  -- association [0..*]
LEFT OUTER JOIN I_GLAccountHierarchyNode AS _GLAccountParentNode ON GLAccountHierarchy = _GLAccountParentNode.GLAccountHierarchy AND HierarchyParentNode = _GLAccountParentNode.HierarchyNode  -- association [0..*]
LEFT OUTER JOIN I_GLAccountHierarchy AS _Hierarchy ON GLAccountHierarchy = _Hierarchy.GLAccountHierarchy  -- association [0..*]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
;