FAA_CalctDrvdAreaDocit04

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_CalctDrvdAreaDocit04.
-- 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: FAAVCDADI04

CREATE VIEW FAA_CalctDrvdAreaDocit04 AS
SELECT
  Values.rbukrs AS bukrs,
  Values.anln1 AS anln1,
  Values.anln2 AS anln2,
  Values.gjahr AS gjahr,
  Values.awtyp AS awtyp,
  Values.awref AS awref,
  Values.aworg AS aworg,
  Values.awsys AS awsys,
  Values.subta AS subta,
  Values.afabe AS afabe,
  Values.slalittype AS slalittype,
  Values.drcrk AS drcrk,
  Values.awitem AS awitem,
  Values.vorgn AS vorgn,
  Values.budat AS budat,
  Values.bzdat AS bzdat,
  Values.poper AS poper,
  Values.anbwa AS bwasl,
  Values.movcat AS movcat,
  Values.hsl AS hsl,
  Values.ksl AS ksl,
  Values.osl AS osl,
  Values.rhcur AS rhcur,
  Values.rkcur AS rkcur,
  Values.rocur AS rocur,
  Values.xreversing AS xreversing,
  Values.xreversed AS xreversed,
  Values.xsettling AS xsettling,
  Values.xsettled AS xsettled,
  Values.prec_awtyp AS prec_awtyp,
  Values.prec_aworg AS prec_aworg,
  Values.prec_awref AS prec_awref,
  Values.prec_subta AS prec_subta,
  Values.awtyp_rev AS awtyp_rev,
  Values.awref_rev AS awref_rev,
  Values.aworg_rev AS aworg_rev,
  Values.subta_rev AS subta_rev,
  Values.anlkl AS anlkl,
  Values.ktogr AS ktogr,
  Values.panl1 AS panl1,
  Values.panl2 AS panl2,
  Values.bldat AS bldat,
  Values.sgtxt AS sgtxt,
  Values.zuonr AS zuonr,
  Values.anln2_pn AS anln2_pn,
  Values.bwasl_pn AS bwasl_pn,
  Values.bzdat_pn AS bzdat_pn,
  Values.ubzdt_pn AS ubzdt_pn,
  Values.xvabg_pn AS xvabg_pn,
  Values.prozs_pn AS prozs_pn,
  'A' AS origin,
  Values.bstat AS bstat,
  Values.bttype AS bttype
FROM acdoca AS Values
INNER JOIN FAA_CalctDrvdAreaValnVws02 AS CalculatedAssetValuationView ON /* join condition not captured in parsed metadata */
;