Faa_Rec_Anlp_Base

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_Rec_Anlp_Base.
-- 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_REC_ANLP

CREATE VIEW Faa_Rec_Anlp_Base AS
SELECT
  anlp.mandt AS mandt,
  anlp.bukrs AS bukrs,
  anlp.gjahr AS gjahr,
  anlp.afbnr AS afbnr,
  anlp.anln1 AS anln1,
  anlp.anln2 AS anln2,
  anlp.afaber AS afaber,
  anlp.aufwz AS aufwz,
  anlp.nafaz AS nafaz,
  anlp.safaz AS safaz,
  anlp.aafaz AS aafaz,
  anlp.mafaz AS mafaz,
  anlp.zinsz AS zinsz,
  anlp.aufnz as aufnz AS mandtasmandt,
  mig.peraf AS peraf,
  - mig.aufnz AS aufnz
FROM t093c
INNER JOIN t093 ON /* join condition not captured in parsed metadata */
INNER JOIN anlp ON /* join condition not captured in parsed metadata */
INNER JOIN faav_anlp AS mig ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): t093c
;