FAA_SDM_DOCIT_CP121

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_SDM_DOCIT_CP121.
-- 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: FAAVDOCITCP121

CREATE VIEW FAA_SDM_DOCIT_CP121 AS
SELECT
  acdoca.rbukrs AS bukrs,
  acdoca.anln1 AS anln1,
  acdoca.anln2 AS anln2,
  acdoca.gjahr AS gjahr,
  acdoca.awtyp AS awtyp,
  acdoca.awref AS awref,
  acdoca.aworg AS aworg,
  acdoca.awsys AS awsys,
  acdoca.subta AS subta,
  acdoca.afabe AS afabe,
  acdoca.slalittype AS slalittype,
  acdoca.drcrk AS drcrk,
  cast( acdoca.rldnr as fins_technical_ledger preserving type ) AS rldnr,
  acdoca.belnr AS belnr,
  acdoca.docln AS docln,
  doc_it.awitem AS s_awitem,
  acdoca.awitem AS t_awitem,
  case when doc_it.bukrs is null then 'X' when doc_it.awitem <> acdoca.awitem then 'X' else '' end as awitem_d AS awitemthenXelseendasawitem_d,
  case when doc_it.bukrs is null then 'X' when ledger_it.tech_ledger <> acdoca.rldnr then 'X' else '' end as tech_ledger_d AS rldnrthenXelseendastech_ledger_d,
  doc_it.vorgn AS s_vorgn,
  acdoca.vorgn AS t_vorgn,
  case when doc_it.bukrs 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 doc_it.bukrs 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 doc_it.bukrs 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 doc_it.bukrs is null then 'X' when acdoca.movcat <> '00' and doc_it.poper is initial and acdoca.poper is initial then 'X' when acdoca.movcat <> '00' and doc_it.poper is not initial and doc_it.poper <> acdoca.poper then 'X' when acdoca.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 doc_it.bukrs 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 doc_it.bukrs 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 doc_it.bukrs is null then 'X' when 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 doc_it.bukrs 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 doc_it.bukrs 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 doc_it.bukrs is null then 'X' when doc_it.vsl <> acdoca.vsl then 'X' else '' end as vsl_d AS vslthenXelseendasvsl_d,
  doc_it.rhcur AS s_rhcur,
  acdoca.rhcur AS t_rhcur,
  case when doc_it.bukrs 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 doc_it.bukrs is null then 'X' when doc_it.rkcur is initial and acdoca.rkcur is initial then 'X' when doc_it.rkcur is not initial and 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 doc_it.bukrs 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 doc_it.bukrs is null then 'X' when doc_it.rvcur <> acdoca.rvcur then 'X' else '' end as rvcur_d AS rvcurthenXelseendasrvcur_d,
  cast( '' as fins_currfc ) AS s_rfccur,
  acdoca.rfccur AS t_rfccur,
  case when doc_it.bukrs 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 doc_it.bukrs 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 doc_it.bukrs 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 doc_it.bukrs 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 doc_it.bukrs 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 doc_it.bukrs 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 doc_it.bukrs 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 doc_it.bukrs 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 doc_it.bukrs 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 doc_it.bukrs 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 doc_it.bukrs 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 doc_it.bukrs 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 doc_it.bukrs 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.anlkl AS s_anlkl,
  acdoca.anlkl AS t_anlkl,
  case when doc_it.bukrs is null then 'X' when doc_it.anlkl <> acdoca.anlkl then 'X' else '' end as anlkl_d AS anlklthenXelseendasanlkl_d,
  doc_it.ktogr AS s_ktogr,
  acdoca.ktogr AS t_ktogr,
  case when doc_it.bukrs is null then 'X' when doc_it.ktogr <> acdoca.ktogr then 'X' else '' end as ktogr_d AS ktogrthenXelseendasktogr_d,
  doc_it.panl1 AS s_panl1,
  acdoca.panl1 AS t_panl1,
  case when doc_it.bukrs 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 doc_it.bukrs 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 doc_it.bukrs is null then 'X' when ( doc_it.sdm_status = '19' and acdoca.mig_source <> 'A') or ( doc_it.sdm_status <> '19' and doc_it.mig_source <> acdoca.mig_source ) then 'X' else '' end as mig_source_d AS mig_sourcethenXelseendasmig_source_d,
  doc_it.recid AS s_recid,
  acdoca.recid AS t_recid,
  case when doc_it.bukrs 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 doc_it.bukrs 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 doc_it.bukrs 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 doc_it.bukrs 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 doc_it.bukrs 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 doc_it.bukrs 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 doc_it.bukrs 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 doc_it.bukrs 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,
  cast( '-' as char01 preserving type ) AS direction,
  acdoca.anlkl AS anlkl,
  acdoca.movcat AS movcat,
  cast( acdoca.anbwa as bwasl preserving type ) AS bwasl,
  acdoca.vorgn AS vorgn,
  cast( '19' as faa_sdm_status ) AS sdm_status
FROM acdoca
INNER JOIN fins_tech_ledger AS ledger_a ON /* join condition not captured in parsed metadata */
INNER JOIN FAA_CFG_DEPR_AREA AS cfg_depr_area ON /* join condition not captured in parsed metadata */
INNER JOIN fins_tech_ledger AS ledger_it ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN FAA_SDM_DOCIT_CP02 AS split_number ON /* join condition not captured in parsed metadata */
;