P_FinStmtLeafWithGLAcct

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_FinStmtLeafWithGLAcct.
-- 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: PFSLEAFGLACC

CREATE VIEW P_FinStmtLeafWithGLAcct AS
SELECT
  cast ( concat(concat(concat( fsitem.HierarchyNode,GLAccount.ChartOfAccounts),GLAccount.GLAccount),'=') as abap.char(50) ) AS HierarchyUniqueNodeID,
  cast (concat(concat( concat(concat( fsitem.HierarchyNode,zc_leaf.ktopl),zc_leaf.vonkt ),'-'),zc_leaf.biskt ) as abap.char(50) ) AS UniqueParentID,
  t011.versn AS versn,
  GLAccount.ChartOfAccounts AS ktopl,
  GLAccount.GLAccount AS saknr,
  cast ('L' as seu_type) AS type,
  cast ( '' as abap.char( 50 )) AS Description,
  zc_leaf.xsoll AS xsoll,
  zc_leaf.xhabn AS xhabn,
  cast (fsitem.FinStatementHierarchyLevelVal as abap.int4) + 2 AS stufe,
  fsitem.HierarchyNode as id AS char50asHierarchyUniqueNodeID,
  zc_range.ergsl AS ergsl,
  fsitem.HierarchyNode AS id
FROM I_GLAccountInChartOfAccounts AS GLAccount
INNER JOIN t011 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fagl_011zc AS zc_leaf ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FinancialStatementItem AS fsitem ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_FAGL_011ZC
;