Faa_Anep1

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_Anep1.
-- 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_ANEP1

CREATE VIEW Faa_Anep1 AS
SELECT
  rclnt AS mandt,
  rbukrs AS bukrs,
  anln1,
  anln2,
  ryear AS gjahr,
  substring( subta, 2,5 ) AS lnran,
  afabe,
  awref AS belnr,
  bzdat,
  anbwa AS bwasl,
  slalittype,
  movcat,
  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 AS xstoreXkeyrclntasmandt,
  substring(awitem,4,3) AS buzei,
  sum ( gsl ) AS gsl
FROM FAA_REP_LEDGER_WO_BF AS ldnr
INNER JOIN acdoca AS adoc ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): faat_doc_it
;