FAA_CompDrvdAreaDocit01

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_CompDrvdAreaDocit01.
-- 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: FAAVPDADI01

CREATE VIEW FAA_CompDrvdAreaDocit01 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.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 <> 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.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 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 acdoca.rbukrs is null then 'X' when doc_it.rocur <> acdoca.rocur then 'X' else '' end as rocur_d AS rocurthenXelseendasrocur_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.anlkl AS s_anlkl,
  acdoca.anlkl AS t_anlkl,
  case when acdoca.rbukrs 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 acdoca.rbukrs 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 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 ( doc_it.sdm_status = '22' and acdoca.mig_source <> 'A') or ( doc_it.sdm_status <> '22' 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 acdoca.rbukrs is null then 'X' when doc_it.recid <> acdoca.recid then 'X' else '' end as recid_d AS recidthenXelseendasrecid_d,
  doc_it.bldat AS s_bldat,
  acdoca.bldat AS t_bldat,
  case when acdoca.rbukrs is null then 'X' when doc_it.bldat <> acdoca.bldat then 'X' else '' end as bldat_d AS bldatthenXelseendasbldat_d,
  doc_it.sgtxt AS s_sgtxt,
  acdoca.sgtxt AS t_sgtxt,
  case when acdoca.rbukrs is null then 'X' when doc_it.sgtxt <> acdoca.sgtxt then 'X' else '' end as sgtxt_d AS sgtxtthenXelseendassgtxt_d,
  doc_it.zuonr AS s_zuonr,
  acdoca.zuonr AS t_zuonr,
  case when acdoca.rbukrs is null then 'X' when doc_it.zuonr <> acdoca.zuonr then 'X' else '' end as zuonr_d AS zuonrthenXelseendaszuonr_d,
  doc_it.obart AS s_obart,
  case when acdoca.rbukrs is null then 'X' when doc_it.obart <> substring(acdoca.parob1,1,2) then 'X' else '' end as obart_d AS parob112thenXelseendasobart_d,
  doc_it.objid AS s_objid,
  case when acdoca.rbukrs is null then 'X' when doc_it.objid <> substring(acdoca.parob1,3,20) then 'X' else '' end as objid_d AS parob1320thenXelseendasobjid_d,
  doc_it.ubzdt_pn AS s_ubzdt_pn,
  acdoca.ubzdt_pn AS t_ubzdt_pn,
  case when acdoca.rbukrs is null then 'X' when doc_it.ubzdt_pn <> acdoca.ubzdt_pn then 'X' else '' end as ubzdt_pn_d AS ubzdt_pnthenXelseendasubzdt_pn_d,
  doc_it.xvabg_pn AS s_xvabg_pn,
  acdoca.xvabg_pn AS t_xvabg_pn,
  case when acdoca.rbukrs is null then 'X' when doc_it.xvabg_pn <> acdoca.xvabg_pn then 'X' else '' end as xvabg_pn_d AS xvabg_pnthenXelseendasxvabg_pn_d,
  doc_it.prozs_pn AS s_prozs_pn,
  acdoca.prozs_pn AS t_prozs_pn,
  case when acdoca.rbukrs is null then 'X' when doc_it.prozs_pn <> acdoca.prozs_pn then 'X' else '' end as prozs_pn_d AS prozs_pnthenXelseendasprozs_pn_d,
  doc_it.sdm_status AS sdm_status
FROM faat_doc_it AS doc_it
INNER JOIN I_DepreciationAreaForLedger AS CalculatedDeprAreaForLedger ON /* join condition not captured in parsed metadata */
INNER JOIN I_AssetValuationView AS AssetValuationView ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN acdoca ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN FAA_CompDrvdAreaSplitNum AS split_number ON /* join condition not captured in parsed metadata */
;