Faa_Rec_Anea_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_Anea_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_ANEA

CREATE VIEW Faa_Rec_Anea_Base AS
SELECT
  anea.mandt AS mandt,
  anea.bukrs AS bukrs,
  anea.anln1 AS anln1,
  anea.anln2 AS anln2,
  anea.gjahr AS gjahr,
  anea.lnran AS lnran,
  anea.afabe AS afabe,
  anea.aufwv AS aufwv,
  anea.invzv AS invzv,
  anea.nafav AS nafav,
  anea.safav AS safav,
  anea.aafav AS aafav,
  anea.mafav AS mafav,
  anea.aufnv AS aufnv,
  anea.aufwl AS aufwl,
  anea.invzl AS invzl,
  anea.nafal AS nafal,
  anea.safal AS safal,
  anea.aafal AS aafal,
  anea.mafal AS mafal,
  anea.aufnl AS aufnl,
  anea.erlbt AS erlbt,
  anea.verko AS verko,
  - anea.sanwv AS sanwv
FROM anea
INNER JOIN anla ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): faav_anea
;