I_FsvHierarchyInCOCD

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_FsvHierarchyInCOCD.
-- 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: IFSVHIERCOCD

CREATE VIEW I_FsvHierarchyInCOCD AS
SELECT
  HierarchyUniqueNodeID AS HierarchyNodeUniqueID,
  versn AS FinancialStatementVariant,
  ktopl AS ChartOfAccounts,
  bukrs AS CompanyCode,
  UniqueParentID AS ParentNodeUniqueID,
  ergsl AS FinancialStatementItem,
  saknr AS GLAccount,
  fkber AS FunctionalArea,
  AlternativeGLAccount,
  CountryChartOfAccounts,
  Description AS HierarchyNodeDescription,
  type AS NodeType,
  id AS HierarchyNode,
  nextn AS SiblingNode,
  stufe AS FinStatementHierarchyLevelVal,
  ergs2 AS OffsettingItem,
  segment AS GLAcctHierarchyNodeCategory,
  case when type = 'P' then _FSITEMSEMTAG.SemanticTags when type = 'B' then _RANGESEMTAG.SemanticTags else '' end as SemanticTag AS SemanticTagselseendasSemanticTag
FROM P_FsvHierarchWithCOCD
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_FinancialStatementItem AS _FinancialStatementItem ON FinancialStatementVariant = _FinancialStatementItem.FinancialStatementVariant AND HierarchyNode = _FinancialStatementItem.HierarchyNode  -- association [1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [1]
LEFT OUTER JOIN I_FinancialStatementVersion AS _FinancialStatementVersion ON FinancialStatementVariant = _FinancialStatementVersion.FinancialStatementVariant  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- 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]
;