P_FinStmtHierarchy

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 P_FinStmtHierarchy.
-- 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: PFSITEMHIER

CREATE VIEW P_FinStmtHierarchy AS
SELECT
  cast(I_FinancialStatementItem.HierarchyNode as abap.char(50)) AS HierarchyUniqueNodeID,
  cast (I_FinancialStatementItem.ParentNode as abap.char(50)) AS UniqueParentID,
  I_FinancialStatementItem.FinancialStatementVariant AS versn,
  I_FinancialStatementItem.FinancialStatementItem AS ergsl,
  dis_zc.ktopl AS ktopl,
  cast ('' as saknr) AS saknr,
  cast ('' as fkber) AS fkber,
  I_FinancialStatementItem.NodeType AS type,
  cast ('' as abap.char(50)) AS Description,
  t011.dspra AS MaintenanceLanguage,
  cast ('' as xsoll_f02e) AS xsoll,
  cast ('' as xhabn_f02e) AS xhabn,
  I_FinancialStatementItem.HierarchyNode AS id,
  I_FinancialStatementItem.ParentNode AS parent,
  I_FinancialStatementItem.ChildNode AS child,
  I_FinancialStatementItem.SiblingNode AS nextn,
  cast(I_FinancialStatementItem.FinStatementHierarchyLevelVal as abap.int4) AS stufe,
  I_FinancialStatementItem.OffsettingItem AS ergs2
FROM I_FinancialStatementItem
INNER JOIN t011 ON /* join condition not captured in parsed metadata */
INNER JOIN P_Distinct_Coa_Fagl_Zc AS dis_zc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_FSHierarchy_Calc_Item AS calc_item ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_FinStmtLeafItem
;