I_FinancialStatementStructure

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_FinancialStatementStructure.
-- 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: IFSVSTR

CREATE VIEW I_FinancialStatementStructure AS
SELECT
  h.FinancialStatementHierarchy AS FinancialStatementHierarchy,
  h.ValidityEndDate AS ValidityEndDate,
  case h.ChartOfAccounts when '' then n.ChartOfAccounts else h.ChartOfAccounts end as ChartOfAccounts AS ChartOfAccountsendasChartOfAccounts,
  n.HierarchyNode AS HierarchyNode,
  n.ParentNode AS ParentNode,
  n.FinancialStatementNodeType AS FinancialStatementNodeType,
  case n.HierarchyNodeVal when '0ASSETS' then case when h.FinancialStatementAssetsItem is not null then h.FinancialStatementAssetsItem else 'ASSETS' end when '0LIABILITS' then case when h.FinStatementLiabilitiesItem is not null then h.FinStatementLiabilitiesItem else 'LIABILITS' end when '0BSLOSS' then case when h.FinancialStatementNetLossItem is not null then h.FinancialStatementNetLossItem else 'BSLOSS' end when '0BSPROFIT' then case when h.FinStatementNetProfitItem is not null then h.FinStatementNetProfitItem else 'BSPROFIT' end when '0PLPROFIT' then case when h.FinStatementProfitAndLossItem is not null then h.FinStatementProfitAndLossItem else 'PLPROFIT' end when '0BSNOTES' then case when h.FinancialStatementNotesItem is not null then h.FinancialStatementNotesItem else 'BSNOTES' end when '0NOTASSGND' then case when h.FinancialStatementOrphansItem is not null then h.FinancialStatementOrphansItem else 'NOTASSGND' end else n.HierarchyNodeVal end as HierarchyNodeVal AS HierarchyNodeValendasHierarchyNodeVal,
  h.ValidityStartDate AS ValidityStartDate,
  h.HierarchyType AS HierarchyType,
  h.GroupChartOfAccountIsUsed AS GroupChartOfAccountIsUsed,
  h.FunctionalAreaIsUsed AS FunctionalAreaIsUsed,
  n.HierarchyLevel AS HierarchyLevel,
  n.HierarchyNodeSequence AS HierarchyNodeSequence,
  n.SignIsInverted AS SignIsInverted,
  h._Text AS _HierText
FROM I_FinancialStatementHier AS h
INNER JOIN I_FinancialStatementHierNode AS n ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FinancialStatementHierNodeT AS _HierNodeText ON FinancialStatementHierarchy = _HierNodeText.FinancialStatementHierarchy AND ValidityEndDate = _HierNodeText.ValidityEndDate AND HierarchyNode = _HierNodeText.HierarchyNode  -- association [0..*]
;