P_FinStmtLeafWithFuncArea

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_FinStmtLeafWithFuncArea.
-- 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: PFSLEAFFUNAREA

CREATE VIEW P_FinStmtLeafWithFuncArea AS
SELECT
  cast (concat(concat( fsitem.HierarchyNode,I_FunctionalArea.FunctionalArea ),'=') as abap.char(50) ) AS HierarchyUniqueNodeID,
  cast (concat( concat(concat( fsitem.HierarchyNode,fc_leaf.vonfb ),'-'),fc_leaf.bisfb ) as abap.char(50) ) AS UniqueParentID,
  fc_leaf.versn AS versn,
  dis_zc.ktopl AS ktopl,
  fc_leaf.ergsl AS ergsl,
  I_FunctionalArea.FunctionalArea AS fkber,
  cast ('L' as seu_type) AS type,
  cast ( '' as abap.char( 50 )) AS Description,
  fsitem.HierarchyNode as id AS char50asHierarchyUniqueNodeID,
  fsitem.HierarchyNode AS id
FROM fagl_011fc AS fc_leaf
INNER JOIN P_Distinct_Coa_Fagl_Zc AS dis_zc ON /* join condition not captured in parsed metadata */
INNER JOIN I_FunctionalArea ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FinancialStatementItem AS fsitem ON /* join condition not captured in parsed metadata */
INNER JOIN I_ChartOfAccounts ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): fagl_011fc
;