Faa_Rc1_Tt_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_Rc1_Tt_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_RC1_TT_BASE

CREATE VIEW Faa_Rc1_Tt_Base AS
SELECT
  it.mandt AS mandt,
  it.bukrs AS bukrs,
  it.anln1 AS anln1,
  it.anln2 AS anln2,
  gjahr,
  it.afabe AS afabe,
  - ANSWL AS answl,
  - ANSAZ AS ansaz,
  - AUFWM AS aufwm,
  - INVZM AS invzm,
  - NAFAM AS nafam,
  - SAFAM AS safam,
  - AAFAM AS aafam,
  - MAFAM AS mafam,
  - AUFNM AS aufnm,
  - SANSL AS sansl,
  - ZUSNA AS zusna,
  - ZUSSA AS zussa,
  - ZUSAA AS zusaa,
  - ZUSMA AS zusma,
  case when anlb.anlgr <> '' AS anlgrnote2226771then0elseINVZVendasinvzv,
  case when anlb.anlgr <> '' AS anlgrnote2226771then0elseNAFAVendasnafav,
  case when anlb.anlgr <> '' AS anlgrnote2226771then0elseSAFAVendassafav,
  case when anlb.anlgr <> '' AS anlgrnote2226771then0elseAAFAVendasaafav,
  case when anlb.anlgr <> '' AS anlgrnote2226771then0elseMAFAVendasmafav,
  case when anlb.anlgr <> '' AS anlgrnote2226771then0elseAUFNVendasaufnv,
  case when anlb.anlgr <> '' AS anlgrnote2226771then0elseINVZLendasinvzl,
  case when anlb.anlgr <> '' AS anlgrnote2226771then0elseNAFALendasnafal,
  case when anlb.anlgr <> '' AS anlgrnote2226771then0elseSAFALendassafal,
  case when anlb.anlgr <> '' AS anlgrnote2226771then0elseAAFALendasaafal,
  case when anlb.anlgr <> '' AS anlgrnote2226771then0elseMAFALendasmafal,
  case when anlb.anlgr <> '' AS mandtasmandt
FROM Faa_Rc1_It_Sum AS it
INNER JOIN anlb ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): Faa_Anlc_Ori
;