FAA_SIL_DEPR

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_SIL_DEPR.
-- 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_SIL_DEPR

CREATE VIEW FAA_SIL_DEPR AS
SELECT
  a.mandt AS mandt,
  a.bukrs AS bukrs,
  a.anlkl AS anlkl,
  a.anln1 AS anln1,
  a.anln2 AS anln2,
  v.gjahr AS gjahr,
  v.depr_period AS depr_period,
  v.afaber AS afaber,
  sum ( v.hsl ) AS hsl,
  sum ( v.ksl ) AS ksl,
  sum ( v.osl ) AS osl,
  sum ( v.vsl ) AS vsl,
  sum ( v.bsl ) AS bsl,
  sum ( v.csl ) AS csl,
  sum ( v.dsl ) AS dsl,
  sum ( v.esl ) AS esl,
  sum ( v.fsl ) AS fsl,
  sum ( v.gsl ) AS gsl
FROM faav_plan_values AS v
INNER JOIN anla AS a ON /* join condition not captured in parsed metadata */
;