Faa_Anlc1_P_Stat

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 Faa_Anlc1_P_Stat.
-- 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: FAAV_ANLC1_PSTAT

CREATE VIEW Faa_Anlc1_P_Stat AS
SELECT
  mandt,
  bukrs,
  anln1,
  anln2,
  gjahr,
  afabe,
  slalittype,
  movcat,
  faat_doc_it.poper AS poperx,
  faat_doc_it.poper AS poperg,
  sum ( hsl ) AS hsl,
  sum ( ksl ) AS ksl,
  sum ( osl ) AS osl,
  sum ( vsl ) AS vsl,
  sum ( bsl ) AS bsl,
  sum ( csl ) AS csl,
  sum ( dsl ) AS dsl,
  sum ( esl ) AS esl,
  sum ( fsl ) AS fsl,
  sum ( gsl ) AS gsl
FROM faat_doc_it
;