FAA_UPA_MIG_DI_DOCIT_CMPR01

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_DI_DOCIT_CMPR01.
-- 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_DI_DOCIT_CMPR01 AS
SELECT
  doc_it.bukrs AS bukrs,
  doc_it.anln1 AS anln1,
  doc_it.anln2 AS anln2,
  doc_it.gjahr AS gjahr,
  doc_it.awtyp AS awtyp,
  doc_it.awref AS awref,
  doc_it.aworg AS aworg,
  doc_it.awsys AS awsys,
  doc_it.subta AS subta,
  doc_it.afabe AS afabe,
  doc_it.slalittype AS slalittype,
  doc_it.drcrk AS drcrk,
  cast( acdoca.rldnr as fins_technical_ledger preserving type ) AS rldnr,
  acdoca.belnr AS belnr,
  acdoca.docln AS docln,
  doc_it.anlkl AS s_anlkl,
  acdoca.anlkl AS t_anlkl,
  doc_it.awitem AS s_awitem,
  acdoca.awitem AS t_awitem,
  case when acdoca.rbukrs is null then 'X' when doc_it.awitem <> acdoca.awitem then 'X' else '' end as awitem_d AS awitemthenXelseendasawitem_d,
  doc_it.vorgn AS s_vorgn,
  acdoca.vorgn AS t_vorgn,
  case when acdoca.rbukrs is null then 'X' when doc_it.vorgn <> acdoca.vorgn then 'X' else '' end as vorgn_d AS vorgnthenXelseendasvorgn_d,
  doc_it.budat AS s_budat,
  acdoca.budat AS t_budat,
  case when acdoca.rbukrs is null then 'X' when doc_it.budat <> acdoca.budat then 'X' else '' end as budat_d AS budatthenXelseendasbudat_d,
  doc_it.bzdat AS s_bzdat,
  acdoca.bzdat AS t_bzdat,
  case when acdoca.rbukrs is null then 'X' when doc_it.bzdat <> acdoca.bzdat then 'X' else '' end as bzdat_d AS bzdatthenXelseendasbzdat_d,
  doc_it.poper AS s_poper,
  acdoca.poper AS t_poper,
  case when acdoca.rbukrs is null then 'X' when doc_it.movcat <> '00' and doc_it.poper is initial and acdoca.poper is initial then 'X' when doc_it.movcat <> '00' and doc_it.poper is not initial and doc_it.poper <> acdoca.poper then 'X' when doc_it.movcat = '00' and doc_it.poper <> acdoca.poper then 'X' else '' end as poper_d AS poperthenXelseendaspoper_d,
  doc_it.bwasl AS s_bwasl,
  cast( acdoca.anbwa as bwasl preserving type ) AS t_bwasl,
  case when acdoca.rbukrs is null then 'X' when doc_it.bwasl <> acdoca.anbwa then 'X' else '' end as bwasl_d AS anbwathenXelseendasbwasl_d,
  doc_it.movcat AS s_movcat,
  acdoca.movcat AS t_movcat,
  case when acdoca.rbukrs is null then 'X' when doc_it.movcat <> acdoca.movcat then 'X' else '' end as movcat_d AS movcatthenXelseendasmovcat_d,
  doc_it.hsl AS s_hsl,
  acdoca.hsl AS t_hsl,
  case when acdoca.rbukrs is null then 'X' when doc_it.hsl >= 0 and doc_it.hsl <> acdoca.hsl then 'X' else '' end as hsl_d AS hslthenXelseendashsl_d,
  doc_it.ksl AS s_ksl,
  acdoca.ksl AS t_ksl,
  case when acdoca.rbukrs is null then 'X' when doc_it.ksl <> acdoca.ksl then 'X' else '' end as ksl_d AS kslthenXelseendasksl_d,
  doc_it.osl AS s_osl,
  acdoca.osl AS t_osl,
  case when acdoca.rbukrs is null then 'X' when doc_it.osl <> acdoca.osl then 'X' else '' end as osl_d AS oslthenXelseendasosl_d,
  doc_it.vsl AS s_vsl,
  acdoca.vsl AS t_vsl,
  case when acdoca.rbukrs is null then 'X' when doc_it.vsl <> acdoca.vsl then 'X' else '' end as vsl_d AS vslthenXelseendasvsl_d,
  doc_it.bsl AS s_bsl,
  acdoca.bsl AS t_bsl,
  case when acdoca.rbukrs is null then 'X' when doc_it.bsl <> acdoca.bsl then 'X' else '' end as bsl_d AS bslthenXelseendasbsl_d,
  doc_it.csl AS s_csl,
  acdoca.csl AS t_csl,
  case when acdoca.rbukrs is null then 'X' when doc_it.csl <> acdoca.csl then 'X' else '' end as csl_d AS cslthenXelseendascsl_d,
  doc_it.dsl AS s_dsl,
  acdoca.dsl AS t_dsl,
  case when acdoca.rbukrs is null then 'X' when doc_it.dsl <> acdoca.dsl then 'X' else '' end as dsl_d AS dslthenXelseendasdsl_d,
  doc_it.esl AS s_esl,
  acdoca.esl AS t_esl,
  case when acdoca.rbukrs is null then 'X' when doc_it.esl <> acdoca.esl then 'X' else '' end as esl_d AS eslthenXelseendasesl_d,
  doc_it.fsl AS s_fsl,
  acdoca.fsl AS t_fsl,
  case when acdoca.rbukrs is null then 'X' when doc_it.fsl <> acdoca.fsl then 'X' else '' end as fsl_d AS fslthenXelseendasfsl_d,
  doc_it.gsl AS s_gsl,
  acdoca.gsl AS t_gsl,
  case when acdoca.rbukrs is null then 'X' when doc_it.gsl <> acdoca.gsl then 'X' else '' end as gsl_d AS gslthenXelseendasgsl_d,
  doc_it.rhcur AS s_rhcur,
  acdoca.rhcur AS t_rhcur,
  case when acdoca.rbukrs is null then 'X' when doc_it.rhcur <> acdoca.rhcur then 'X' else '' end as rhcur_d AS rhcurthenXelseendasrhcur_d,
  doc_it.rkcur AS s_rkcur,
  acdoca.rkcur AS t_rkcur,
  case when acdoca.rkcur is null then 'X' when doc_it.rkcur <> acdoca.rkcur then 'X' else '' end as rkcur_d AS rkcurthenXelseendasrkcur_d,
  doc_it.rocur AS s_rocur,
  acdoca.rocur AS t_rocur,
  case when acdoca.rbukrs is null then 'X' when doc_it.rocur <> acdoca.rocur then 'X' else '' end as rocur_d AS rocurthenXelseendasrocur_d,
  doc_it.rvcur AS s_rvcur,
  acdoca.rvcur AS t_rvcur,
  case when acdoca.rbukrs is null then 'X' when doc_it.rvcur <> acdoca.rvcur then 'X' else '' end as rvcur_d AS rvcurthenXelseendasrvcur_d,
  doc_it.rbcur AS s_rbcur,
  acdoca.rbcur AS t_rbcur,
  case when acdoca.rbukrs is null then 'X' when doc_it.rbcur <> acdoca.rbcur then 'X' else '' end as rbcur_d AS rbcurthenXelseendasrbcur_d,
  doc_it.rccur AS s_rccur,
  acdoca.rccur AS t_rccur,
  case when acdoca.rbukrs is null then 'X' when doc_it.rccur <> acdoca.rccur then 'X' else '' end as rccur_d AS rccurthenXelseendasrccur_d,
  doc_it.rdcur AS s_rdcur,
  acdoca.rdcur AS t_rdcur,
  case when acdoca.rbukrs is null then 'X' when doc_it.rdcur <> acdoca.rdcur then 'X' else '' end as rdcur_d AS rdcurthenXelseendasrdcur_d,
  doc_it.recur AS s_recur,
  acdoca.recur AS t_recur,
  case when acdoca.rbukrs is null then 'X' when doc_it.recur <> acdoca.recur then 'X' else '' end as recur_d AS recurthenXelseendasrecur_d,
  doc_it.rfcur AS s_rfcur,
  acdoca.rfcur AS t_rfcur,
  case when acdoca.rbukrs is null then 'X' when doc_it.rfcur <> acdoca.rfcur then 'X' else '' end as rfcur_d AS rfcurthenXelseendasrfcur_d,
  doc_it.rgcur AS s_rgcur,
  acdoca.rgcur AS t_rgcur,
  case when acdoca.rbukrs is null then 'X' when doc_it.rgcur <> acdoca.rgcur then 'X' else '' end as rgcur_d AS rgcurthenXelseendasrgcur_d,
  cast( '' as fins_currfc ) AS s_rfccur,
  acdoca.rfccur AS t_rfccur,
  case when acdoca.rbukrs is null then 'X' when acdoca.rfccur is initial then 'X' else '' end as rfccur_d AS rfccurisinitialthenXelseendasrfccur_d,
  doc_it.xreversing AS s_xreversing,
  acdoca.xreversing AS t_xreversing,
  case when acdoca.rbukrs is null then 'X' when doc_it.xreversing <> acdoca.xreversing then 'X' else '' end as xreversing_d AS xreversingthenXelseendasxreversing_d,
  doc_it.xreversed AS s_xreversed,
  acdoca.xreversed AS t_xreversed,
  case when acdoca.rbukrs is null then 'X' when doc_it.xreversed <> acdoca.xreversed then 'X' else '' end as xreversed_d AS xreversedthenXelseendasxreversed_d,
  doc_it.xsettling AS s_xsettling,
  acdoca.xsettling AS t_xsettling,
  case when acdoca.rbukrs is null then 'X' when doc_it.xsettling <> acdoca.xsettling then 'X' else '' end as xsettling_d AS xsettlingthenXelseendasxsettling_d,
  doc_it.xsettled AS s_xsettled,
  acdoca.xsettled AS t_xsettled,
  case when acdoca.rbukrs is null then 'X' when doc_it.xsettled <> acdoca.xsettled then 'X' else '' end as xsettled_d AS xsettledthenXelseendasxsettled_d,
  doc_it.prec_awtyp AS s_prec_awtyp,
  acdoca.prec_awtyp AS t_prec_awtyp,
  case when acdoca.rbukrs is null then 'X' when doc_it.movcat = '00' and acdoca.prec_awtyp <> '' then 'X' when doc_it.movcat <> '00' and doc_it.prec_awtyp <> acdoca.prec_awtyp then 'X' else '' end as prec_awtyp_d AS prec_awtypthenXelseendasprec_awtyp_d,
  doc_it.prec_aworg AS s_prec_aworg,
  acdoca.prec_aworg AS t_prec_aworg,
  case when acdoca.rbukrs is null then 'X' when doc_it.prec_aworg <> acdoca.prec_aworg then 'X' else '' end as prec_aworg_d AS prec_aworgthenXelseendasprec_aworg_d,
  doc_it.prec_awref AS s_prec_awref,
  acdoca.prec_awref AS t_prec_awref,
  case when acdoca.rbukrs is null then 'X' when doc_it.prec_awref <> acdoca.prec_awref then 'X' else '' end as prec_awref_d AS prec_awrefthenXelseendasprec_awref_d,
  doc_it.prec_subta AS s_prec_subta,
  acdoca.prec_subta AS t_prec_subta,
  case when acdoca.rbukrs is null then 'X' when doc_it.prec_subta <> acdoca.prec_subta then 'X' else '' end as prec_subta_d AS prec_subtathenXelseendasprec_subta_d,
  doc_it.awtyp_rev AS s_awtyp_rev,
  acdoca.awtyp_rev AS t_awtyp_rev,
  case when acdoca.rbukrs is null then 'X' when doc_it.awtyp_rev <> acdoca.awtyp_rev then 'X' else '' end as awtyp_rev_d AS awtyp_revthenXelseendasawtyp_rev_d,
  doc_it.awref_rev AS s_awref_rev,
  acdoca.awref_rev AS t_awref_rev,
  case when acdoca.rbukrs is null then 'X' when doc_it.awref_rev <> acdoca.awref_rev then 'X' else '' end as awref_rev_d AS awref_revthenXelseendasawref_rev_d,
  doc_it.aworg_rev AS s_aworg_rev,
  acdoca.aworg_rev AS t_aworg_rev,
  case when acdoca.rbukrs is null then 'X' when doc_it.aworg_rev <> acdoca.aworg_rev then 'X' else '' end as aworg_rev_d AS aworg_revthenXelseendasaworg_rev_d,
  doc_it.subta_rev AS s_subta_rev,
  acdoca.subta_rev AS t_subta_rev,
  case when acdoca.rbukrs is null then 'X' when doc_it.subta_rev <> acdoca.subta_rev then 'X' else '' end as subta_rev_d AS subta_revthenXelseendassubta_rev_d,
  doc_it.panl1 AS s_panl1,
  acdoca.panl1 AS t_panl1,
  case when acdoca.rbukrs is null then 'X' when doc_it.panl1 <> acdoca.panl1 then 'X' else '' end as panl1_d AS panl1thenXelseendaspanl1_d,
  doc_it.panl2 AS s_panl2,
  acdoca.panl2 AS t_panl2,
  case when acdoca.rbukrs is null then 'X' when doc_it.panl2 <> acdoca.panl2 then 'X' else '' end as panl2_d AS panl2thenXelseendaspanl2_d,
  doc_it.mig_source AS s_mig_source,
  acdoca.mig_source AS t_mig_source,
  case when acdoca.rbukrs is null then 'X' when acdoca.mig_source = 'A' then '' when acdoca.mig_source = 'R' then '' else 'X' end as mig_source_d AS mig_sourceRthenelseXendasmig_source_d,
  doc_it.recid AS s_recid,
  acdoca.recid AS t_recid,
  case when acdoca.rbukrs is null then 'X' when doc_it.recid <> acdoca.recid then 'X' else '' end as recid_d AS recidthenXelseendasrecid_d,
  acdoca.bldat AS t_bldat,
  case when acdoca.rbukrs is null then 'X' when fi_doc.rbukrs is null and doc_it.bldat <> acdoca.bldat then 'X' when fi_doc.rbukrs is not null and fi_doc.bldat <> acdoca.bldat then 'X' else '' end as bldat_d AS bldatthenXelseendasbldat_d,
  acdoca.sgtxt AS t_sgtxt,
  case when acdoca.rbukrs is null then 'X' when fi_doc.rbukrs is null and doc_it.sgtxt <> acdoca.sgtxt then 'X' when fi_doc.rbukrs is not null and fi_doc.sgtxt <> acdoca.sgtxt then 'X' else '' end as sgtxt_d AS sgtxtthenXelseendassgtxt_d,
  acdoca.zuonr AS t_zuonr,
  case when acdoca.rbukrs is null then 'X' when fi_doc.rbukrs is null and doc_it.zuonr <> acdoca.zuonr then 'X' when fi_doc.rbukrs is not null and fi_doc.zuonr <> acdoca.zuonr then 'X' else '' end as zuonr_d AS zuonrthenXelseendaszuonr_d,
  case when acdoca.rbukrs is null then 'X' when fi_doc.rbukrs is null and doc_it.obart <> substring(acdoca.parob1,1,2) then 'X' when fi_doc.rbukrs is not null and fi_doc.parob1 is initial and doc_it.obart <> substring(acdoca.parob1,1,2) then 'X' when fi_doc.rbukrs is not null and fi_doc.parob1 is not initial and fi_doc.parob1 <> acdoca.parob1 then 'X' else '' end as obart_d AS parob1thenXelseendasobart_d,
  case when acdoca.rbukrs is null then 'X' when fi_doc.rbukrs is null and doc_it.objid <> substring(acdoca.parob1,3,20) then 'X' when fi_doc.rbukrs is not null and fi_doc.parob1 is initial and doc_it.objid <> substring(acdoca.parob1,3,20) then 'X' when fi_doc.rbukrs is not null and fi_doc.parob1 is not initial and fi_doc.parob1 <> acdoca.parob1 then 'X' else '' end as objid_d AS parob1thenXelseendasobjid_d,
  acdoca.ubzdt_pn AS t_ubzdt_pn,
  case when acdoca.rbukrs is null then 'X' when fi_doc.rbukrs is null and doc_it.ubzdt_pn <> acdoca.ubzdt_pn then 'X' when fi_doc.rbukrs is not null and fi_doc.ubzdt_pn <> acdoca.ubzdt_pn then 'X' else '' end as ubzdt_pn_d AS ubzdt_pnthenXelseendasubzdt_pn_d,
  acdoca.xvabg_pn AS t_xvabg_pn,
  case when fi_doc.xvabg_pn = 'X' and fi_doc.xvabg_pn <> acdoca.xvabg_pn then 'X' when fi_doc.xvabg_pn <> 'X' and doc_it.xvabg_pn <> acdoca.xvabg_pn then 'X' else '' end as xvabg_pn_d AS xvabg_pnthenXelseendasxvabg_pn_d,
  acdoca.prozs_pn AS t_prozs_pn,
  case when acdoca.rbukrs is null then 'X' when fi_doc.rbukrs is null and doc_it.prozs_pn <> acdoca.prozs_pn then 'X' when fi_doc.rbukrs is not null and fi_doc.prozs_pn <> acdoca.prozs_pn then 'X' else '' end as prozs_pn_d AS prozs_pnthenXelseendasprozs_pn_d,
  doc_it.anlkl AS anlkl,
  doc_it.movcat AS movcat,
  doc_it.bwasl AS bwasl,
  doc_it.vorgn AS vorgn,
  doc_it.sdm_status AS sdm_status
INNER JOIN FAA_CFG_DEPR_AREA AS cfg_depr_area ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN acdoca ON /* join condition not captured in parsed metadata */
;