FAA_UPA_MIG_DA_CONS_DOCIT

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_UPA_MIG_DA_CONS_DOCIT.
-- 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.

CREATE VIEW FAA_UPA_MIG_DA_CONS_DOCIT 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.vsl AS vsl,
  Values.bsl AS bsl,
  Values.csl AS csl,
  Values.dsl AS dsl,
  Values.esl AS esl,
  Values.fsl AS fsl,
  Values.gsl AS gsl,
  Values.rhcur AS rhcur,
  Values.rkcur AS rkcur,
  Values.rocur AS rocur,
  Values.rvcur AS rvcur,
  Values.rbcur AS rbcur,
  Values.rccur AS rccur,
  Values.rdcur AS rdcur,
  Values.recur AS recur,
  Values.rfcur AS rfcur,
  Values.rgcur AS rgcur,
  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_UPA_MIG_DA_CONS_AREA AS ConstitutionalArea ON /* join condition not captured in parsed metadata */
;