FAA_SIL_ITEMS

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

CREATE VIEW FAA_SIL_ITEMS AS
SELECT
  a.mandt AS mandt,
  a.bukrs AS bukrs,
  a.anlkl AS anlkl,
  a.anln1 AS anln1,
  a.anln2 AS anln2,
  i.awtyp AS awtyp,
  i.awref AS awref,
  i.aworg AS aworg,
  i.awsys AS awsys,
  i.gjahr AS gjahr,
  i.afabe AS afabe,
  i.slalittype AS slalittype,
  sum ( i.hsl ) AS hsl,
  sum ( i.ksl ) AS ksl,
  sum ( i.osl ) AS osl,
  sum ( i.vsl ) AS vsl,
  sum ( i.bsl ) AS bsl,
  sum ( i.csl ) AS csl,
  sum ( i.dsl ) AS dsl,
  sum ( i.esl ) AS esl,
  sum ( i.fsl ) AS fsl,
  sum ( i.gsl ) AS gsl
FROM faav_lineitems AS i
INNER JOIN anla AS a ON /* join condition not captured in parsed metadata */
;