I_FsvHierarchyInCoa

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_FsvHierarchyInCoa.
-- 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: IFSVNODECOA

CREATE VIEW I_FsvHierarchyInCoa AS
SELECT
  P_FsvHierarchyWithCategory.HierarchyUniqueNodeID AS HierarchyNodeUniqueID,
  P_FsvHierarchyWithCategory.versn AS FinancialStatementVariant,
  P_FsvHierarchyWithCategory.ktopl AS ChartOfAccounts,
  P_FsvHierarchyWithCategory.UniqueParentID AS ParentNodeUniqueID,
  P_FsvHierarchyWithCategory.ergsl AS FinancialStatementItem,
  P_FsvHierarchyWithCategory.saknr AS GLAccount,
  P_FsvHierarchyWithCategory.fkber AS FunctionalArea,
  P_FsvHierarchyWithCategory.stufe AS FinStatementHierarchyLevelVal,
  P_FsvHierarchyWithCategory.type AS NodeType,
  P_FsvHierarchyWithCategory.Description AS HierarchyNodeDescription,
  P_FsvHierarchyWithCategory.xsoll AS IsDebitBalanceRelevant,
  P_FsvHierarchyWithCategory.xhabn AS IsCreditBalanceRelevant,
  P_FsvHierarchyWithCategory.ergs2 AS OffsettingItem,
  P_FsvHierarchyWithCategory.id AS HierarchyNode,
  P_FsvHierarchyWithCategory.nextn AS SiblingNode,
  P_FsvHierarchyWithCategory.segment AS GLAcctHierarchyNodeCategory,
  _GLAccountInChartOfAccounts.CorporateGroupAccount AS CorporateGroupAccount,
  case when P_FsvHierarchyWithCategory.type = 'P' then _FSITEMSEMTAG.SemanticTags when P_FsvHierarchyWithCategory.type = 'B' then _RANGESEMTAG.SemanticTags else '' end as SemanticTag AS SemanticTagselseendasSemanticTag
FROM P_FsvHierarchyWithCategory
LEFT OUTER JOIN I_FinancialStatementItem AS _FinancialStatementItem ON FinancialStatementVariant = _FinancialStatementItem.FinancialStatementVariant AND HierarchyNode = _FinancialStatementItem.HierarchyNode  -- 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_GLAcctWithGrpChartOfAccounts AS _GroupAccountExternal ON CorporateGroupChartOfAccounts = _GroupAccountExternal.ChartOfAccounts AND corporategroupaccount = _GroupAccountExternal.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAcctWithGrpChartOfAccounts AS _GLAccountInGrpChartOfAccounts ON ChartOfAccounts = _GLAccountInGrpChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInGrpChartOfAccounts.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _CorporateGroupChartOfAccounts ON CorporateGroupChartOfAccounts = _CorporateGroupChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_FinancialStatementVersion AS _FinancialStatementVersion ON FinancialStatementVariant = _FinancialStatementVersion.FinancialStatementVariant  -- association [0..1]
LEFT OUTER JOIN P_FSVSEMTAG AS _FSITEMSEMTAG ON FinancialStatementVariant = _FSITEMSEMTAG.FinancialStatementVariant AND FinancialStatementItem = _FSITEMSEMTAG.FinancialStatementItem AND NodeType = 'P'  -- association [0..1]
LEFT OUTER JOIN P_FSVSEMTAG AS _RANGESEMTAG ON FinancialStatementVariant = _RANGESEMTAG.FinancialStatementVariant AND HierarchyNodeDescription = _RANGESEMTAG.HierarchyNode AND NodeType = 'B'  -- association [0..1]
;