FAA_CompDrvdAreaDocit02

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_CompDrvdAreaDocit02.
-- 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: FAAVPDADI02

CREATE VIEW FAA_CompDrvdAreaDocit02 AS
SELECT
  doc_comp.bukrs AS bukrs,
  doc_comp.anln1 AS anln1,
  doc_comp.anln2 AS anln2,
  doc_comp.gjahr AS gjahr,
  doc_comp.awtyp AS awtyp,
  doc_comp.awref AS awref,
  doc_comp.aworg AS aworg,
  doc_comp.awsys AS awsys,
  doc_comp.subta AS subta,
  doc_comp.afabe AS afabe,
  doc_comp.slalittype AS slalittype,
  doc_comp.drcrk AS drcrk,
  doc_comp.rldnr AS rldnr,
  doc_comp.belnr AS belnr,
  doc_comp.docln AS docln,
  doc_comp.split_number AS split_number,
  doc_comp.s_awitem AS s_awitem,
  doc_comp.t_awitem AS t_awitem,
  doc_comp.awitem_d AS awitem_d,
  doc_comp.s_vorgn AS s_vorgn,
  doc_comp.t_vorgn AS t_vorgn,
  doc_comp.vorgn_d AS vorgn_d,
  doc_comp.s_budat AS s_budat,
  doc_comp.t_budat AS t_budat,
  doc_comp.budat_d AS budat_d,
  doc_comp.s_bzdat AS s_bzdat,
  doc_comp.t_bzdat AS t_bzdat,
  doc_comp.bzdat_d AS bzdat_d,
  doc_comp.s_poper AS s_poper,
  doc_comp.t_poper AS t_poper,
  doc_comp.poper_d AS poper_d,
  doc_comp.s_bwasl AS s_bwasl,
  doc_comp.t_bwasl AS t_bwasl,
  doc_comp.bwasl_d AS bwasl_d,
  doc_comp.s_movcat AS s_movcat,
  doc_comp.t_movcat AS t_movcat,
  doc_comp.movcat_d AS movcat_d,
  doc_comp.s_hsl AS s_hsl,
  doc_comp.t_hsl AS t_hsl,
  doc_comp.hsl_d AS hsl_d,
  doc_comp.s_ksl AS s_ksl,
  doc_comp.t_ksl AS t_ksl,
  doc_comp.ksl_d AS ksl_d,
  doc_comp.s_osl AS s_osl,
  doc_comp.t_osl AS t_osl,
  doc_comp.osl_d AS osl_d,
  doc_comp.s_rhcur AS s_rhcur,
  doc_comp.t_rhcur AS t_rhcur,
  doc_comp.rhcur_d AS rhcur_d,
  doc_comp.s_rkcur AS s_rkcur,
  doc_comp.t_rkcur AS t_rkcur,
  doc_comp.rkcur_d AS rkcur_d,
  doc_comp.s_rocur AS s_rocur,
  doc_comp.t_rocur AS t_rocur,
  doc_comp.rocur_d AS rocur_d,
  doc_comp.s_rfccur AS s_rfccur,
  doc_comp.t_rfccur AS t_rfccur,
  doc_comp.rfccur_d AS rfccur_d,
  doc_comp.s_xreversing AS s_xreversing,
  doc_comp.t_xreversing AS t_xreversing,
  doc_comp.xreversing_d AS xreversing_d,
  doc_comp.s_xreversed AS s_xreversed,
  doc_comp.t_xreversed AS t_xreversed,
  doc_comp.xreversed_d AS xreversed_d,
  doc_comp.s_xsettling AS s_xsettling,
  doc_comp.t_xsettling AS t_xsettling,
  doc_comp.xsettling_d AS xsettling_d,
  doc_comp.s_xsettled AS s_xsettled,
  doc_comp.t_xsettled AS t_xsettled,
  doc_comp.xsettled_d AS xsettled_d,
  doc_comp.s_prec_awtyp AS s_prec_awtyp,
  doc_comp.t_prec_awtyp AS t_prec_awtyp,
  doc_comp.prec_awtyp_d AS prec_awtyp_d,
  doc_comp.s_prec_aworg AS s_prec_aworg,
  doc_comp.t_prec_aworg AS t_prec_aworg,
  doc_comp.prec_aworg_d AS prec_aworg_d,
  doc_comp.s_prec_awref AS s_prec_awref,
  doc_comp.t_prec_awref AS t_prec_awref,
  doc_comp.prec_awref_d AS prec_awref_d,
  doc_comp.s_prec_subta AS s_prec_subta,
  doc_comp.t_prec_subta AS t_prec_subta,
  doc_comp.prec_subta_d AS prec_subta_d,
  doc_comp.s_awtyp_rev AS s_awtyp_rev,
  doc_comp.t_awtyp_rev AS t_awtyp_rev,
  doc_comp.awtyp_rev_d AS awtyp_rev_d,
  doc_comp.s_awref_rev AS s_awref_rev,
  doc_comp.t_awref_rev AS t_awref_rev,
  doc_comp.awref_rev_d AS awref_rev_d,
  doc_comp.s_aworg_rev AS s_aworg_rev,
  doc_comp.t_aworg_rev AS t_aworg_rev,
  doc_comp.aworg_rev_d AS aworg_rev_d,
  doc_comp.s_subta_rev AS s_subta_rev,
  doc_comp.t_subta_rev AS t_subta_rev,
  doc_comp.subta_rev_d AS subta_rev_d,
  doc_comp.s_anlkl AS s_anlkl,
  doc_comp.t_anlkl AS t_anlkl,
  doc_comp.anlkl_d AS anlkl_d,
  doc_comp.s_ktogr AS s_ktogr,
  doc_comp.t_ktogr AS t_ktogr,
  doc_comp.ktogr_d AS ktogr_d,
  doc_comp.s_panl1 AS s_panl1,
  doc_comp.t_panl1 AS t_panl1,
  doc_comp.panl1_d AS panl1_d,
  doc_comp.s_panl2 AS s_panl2,
  doc_comp.t_panl2 AS t_panl2,
  doc_comp.panl2_d AS panl2_d,
  doc_comp.s_mig_source AS s_mig_source,
  doc_comp.t_mig_source AS t_mig_source,
  doc_comp.mig_source_d AS mig_source_d,
  doc_comp.s_recid AS s_recid,
  doc_comp.t_recid AS t_recid,
  doc_comp.recid_d AS recid_d,
  doc_comp.s_bldat AS s_bldat,
  doc_comp.t_bldat AS t_bldat,
  doc_comp.bldat_d AS bldat_d,
  doc_comp.s_sgtxt AS s_sgtxt,
  doc_comp.t_sgtxt AS t_sgtxt,
  doc_comp.sgtxt_d AS sgtxt_d,
  doc_comp.s_zuonr AS s_zuonr,
  doc_comp.t_zuonr AS t_zuonr,
  doc_comp.zuonr_d AS zuonr_d,
  doc_comp.s_obart AS s_obart,
  doc_comp.t_obart AS t_obart,
  doc_comp.obart_d AS obart_d,
  doc_comp.s_objid AS s_objid,
  doc_comp.t_objid AS t_objid,
  doc_comp.objid_d AS objid_d,
  doc_comp.s_ubzdt_pn AS s_ubzdt_pn,
  doc_comp.t_ubzdt_pn AS t_ubzdt_pn,
  doc_comp.ubzdt_pn_d AS ubzdt_pn_d,
  doc_comp.s_xvabg_pn AS s_xvabg_pn,
  doc_comp.t_xvabg_pn AS t_xvabg_pn,
  doc_comp.xvabg_pn_d AS xvabg_pn_d,
  doc_comp.s_prozs_pn AS s_prozs_pn,
  doc_comp.t_prozs_pn AS t_prozs_pn,
  doc_comp.prozs_pn_d AS prozs_pn_d,
  case when doc_comp.different = 'Y' then 'Y' when doc_comp.awitem_d = 'X' then 'X' when doc_comp.vorgn_d = 'X' then 'X' when doc_comp.budat_d = 'X' then 'X' when doc_comp.bzdat_d = 'X' then 'X' when doc_comp.poper_d = 'X' then 'X' when doc_comp.bwasl_d = 'X' then 'X' when doc_comp.movcat_d = 'X' then 'X' when doc_comp.hsl_d = 'X' then 'X' when doc_comp.ksl_d = 'X' then 'X' when doc_comp.osl_d = 'X' then 'X' when doc_comp.rhcur_d = 'X' then 'X' when doc_comp.rkcur_d = 'X' then 'X' when doc_comp.rocur_d = 'X' then 'X' when doc_comp.rfccur_d = 'X' then 'X' when doc_comp.xreversing_d = 'X' then 'X' when doc_comp.xreversed_d = 'X' then 'X' when doc_comp.xsettling_d = 'X' then 'X' when doc_comp.xsettled_d = 'X' then 'X' when doc_comp.prec_awtyp_d = 'X' then 'X' when doc_comp.prec_aworg_d = 'X' then 'X' when doc_comp.prec_awref_d = 'X' then 'X' when doc_comp.prec_subta_d = 'X' then 'X' when doc_comp.awtyp_rev_d = 'X' then 'X' when doc_comp.awref_rev_d = 'X' then 'X' when doc_comp.aworg_rev_d = 'X' then 'X' when doc_comp.subta_rev_d = 'X' then 'X' when doc_comp.anlkl_d = 'X' then 'X' when doc_comp.ktogr_d = 'X' then 'X' when doc_comp.panl1_d = 'X' then 'X' when doc_comp.panl2_d = 'X' then 'X' when doc_comp.mig_source_d = 'X' then 'X' when doc_comp.recid_d = 'X' then 'X' when doc_comp.bldat_d = 'X' then 'X' when doc_comp.sgtxt_d = 'X' then 'X' when doc_comp.zuonr_d = 'X' then 'X' when doc_comp.obart_d = 'X' then 'X' when doc_comp.objid_d = 'X' then 'X' when doc_comp.ubzdt_pn_d = 'X' then 'X' when doc_comp.xvabg_pn_d = 'X' then 'X' when doc_comp.prozs_pn_d = 'X' then 'X' when doc_comp.xmanpropval_pn_d = 'X' then 'X' else '' end as different AS xmanpropval_pn_dXthenXelseendasdifferent,
  doc_comp.sdm_status AS sdm_status
FROM FAA_CompDrvdAreaDocit01 AS doc_comp
;