FAA_SDM_DOCIT_CP111
Compare from DOC_IT to ACDOCA
FAA_SDM_DOCIT_CP111 is a CDS View in S/4HANA. Compare from DOC_IT to ACDOCA. It contains 154 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FAA_SDM_DOCIT_CP11 | view | from | Compare from DOC_IT to ACDOCA |
Fields (154)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | afabe | afabe | 1 |
| KEY | anln1 | anln1 | 1 |
| KEY | anln2 | anln2 | 1 |
| KEY | aworg | aworg | 1 |
| KEY | awref | awref | 1 |
| KEY | awsys | awsys | 1 |
| KEY | awtyp | awtyp | 1 |
| KEY | belnr | belnr | 1 |
| KEY | bukrs | bukrs | 1 |
| KEY | docln | docln | 1 |
| KEY | drcrk | drcrk | 1 |
| KEY | gjahr | gjahr | 1 |
| KEY | rldnr | rldnr | 1 |
| KEY | slalittype | slalittype | 1 |
| KEY | subta | subta | 1 |
| anlkl | anlkl | 1 | |
| anlkl_d | anlkl_d | 1 | |
| awitem_d | awitem_d | 1 | |
| aworg_rev_d | aworg_rev_d | 1 | |
| awref_rev_d | awref_rev_d | 1 | |
| awtyp_rev_d | awtyp_rev_d | 1 | |
| bldat_d | bldat_d | 1 | |
| budat_d | budat_d | 1 | |
| bwasl | bwasl | 1 | |
| bwasl_d | bwasl_d | 1 | |
| bzdat_d | bzdat_d | 1 | |
| direction | direction | 1 | |
| hsl_d | hsl_d | 1 | |
| ksl_d | ksl_d | 1 | |
| ktogr_d | ktogr_d | 1 | |
| mig_source_d | mig_source_d | 1 | |
| movcat | movcat | 1 | |
| movcat_d | movcat_d | 1 | |
| obart_d | obart_d | 1 | |
| objid_d | objid_d | 1 | |
| osl_d | osl_d | 1 | |
| panl1_d | panl1_d | 1 | |
| panl2_d | panl2_d | 1 | |
| poper_d | poper_d | 1 | |
| prec_aworg_d | prec_aworg_d | 1 | |
| prec_awref_d | prec_awref_d | 1 | |
| prec_awtyp_d | prec_awtyp_d | 1 | |
| prec_subta_d | prec_subta_d | 1 | |
| prozs_pn_d | prozs_pn_d | 1 | |
| recid_d | recid_d | 1 | |
| rfccur_d | rfccur_d | 1 | |
| rhcur_d | rhcur_d | 1 | |
| rkcur_d | rkcur_d | 1 | |
| rocur_d | rocur_d | 1 | |
| rvcur_d | rvcur_d | 1 | |
| s_anlkl | s_anlkl | 1 | |
| s_awitem | s_awitem | 1 | |
| s_aworg_rev | s_aworg_rev | 1 | |
| s_awref_rev | s_awref_rev | 1 | |
| s_awtyp_rev | s_awtyp_rev | 1 | |
| s_bldat | s_bldat | 1 | |
| s_budat | s_budat | 1 | |
| s_bwasl | s_bwasl | 1 | |
| s_bzdat | s_bzdat | 1 | |
| s_hsl | s_hsl | 1 | |
| s_ksl | s_ksl | 1 | |
| s_ktogr | s_ktogr | 1 | |
| s_mig_source | s_mig_source | 1 | |
| s_movcat | s_movcat | 1 | |
| s_obart | s_obart | 1 | |
| s_objid | s_objid | 1 | |
| s_osl | s_osl | 1 | |
| s_panl1 | s_panl1 | 1 | |
| s_panl2 | s_panl2 | 1 | |
| s_poper | s_poper | 1 | |
| s_prec_aworg | s_prec_aworg | 1 | |
| s_prec_awref | s_prec_awref | 1 | |
| s_prec_awtyp | s_prec_awtyp | 1 | |
| s_prec_subta | s_prec_subta | 1 | |
| s_prozs_pn | s_prozs_pn | 1 | |
| s_recid | s_recid | 1 | |
| s_rfccur | s_rfccur | 1 | |
| s_rhcur | s_rhcur | 1 | |
| s_rkcur | s_rkcur | 1 | |
| s_rocur | s_rocur | 1 | |
| s_rvcur | s_rvcur | 1 | |
| s_sgtxt | s_sgtxt | 1 | |
| s_subta_rev | s_subta_rev | 1 | |
| s_tech_ledger | s_tech_ledger | 1 | |
| s_ubzdt_pn | s_ubzdt_pn | 1 | |
| s_vorgn | s_vorgn | 1 | |
| s_vsl | s_vsl | 1 | |
| s_xmanpropval_pn | s_xmanpropval_pn | 1 | |
| s_xreversed | s_xreversed | 1 | |
| s_xreversing | s_xreversing | 1 | |
| s_xsettled | s_xsettled | 1 | |
| s_xsettling | s_xsettling | 1 | |
| s_xvabg_pn | s_xvabg_pn | 1 | |
| s_zuonr | s_zuonr | 1 | |
| sdm_status | sdm_status | 1 | |
| sgtxt_d | sgtxt_d | 1 | |
| split_number | split_number | 1 | |
| subta_rev_d | subta_rev_d | 1 | |
| t_anlkl | t_anlkl | 1 | |
| t_awitem | t_awitem | 1 | |
| t_aworg_rev | t_aworg_rev | 1 | |
| t_awref_rev | t_awref_rev | 1 | |
| t_awtyp_rev | t_awtyp_rev | 1 | |
| t_bldat | t_bldat | 1 | |
| t_budat | t_budat | 1 | |
| t_bwasl | t_bwasl | 1 | |
| t_bzdat | t_bzdat | 1 | |
| t_hsl | t_hsl | 1 | |
| t_ksl | t_ksl | 1 | |
| t_ktogr | t_ktogr | 1 | |
| t_mig_source | t_mig_source | 1 | |
| t_movcat | t_movcat | 1 | |
| t_obart | t_obart | 1 | |
| t_objid | t_objid | 1 | |
| t_osl | t_osl | 1 | |
| t_panl1 | t_panl1 | 1 | |
| t_panl2 | t_panl2 | 1 | |
| t_poper | t_poper | 1 | |
| t_prec_aworg | t_prec_aworg | 1 | |
| t_prec_awref | t_prec_awref | 1 | |
| t_prec_awtyp | t_prec_awtyp | 1 | |
| t_prec_subta | t_prec_subta | 1 | |
| t_prozs_pn | t_prozs_pn | 1 | |
| t_recid | t_recid | 1 | |
| t_rfccur | t_rfccur | 1 | |
| t_rhcur | t_rhcur | 1 | |
| t_rkcur | t_rkcur | 1 | |
| t_rocur | t_rocur | 1 | |
| t_rvcur | t_rvcur | 1 | |
| t_sgtxt | t_sgtxt | 1 | |
| t_subta_rev | t_subta_rev | 1 | |
| t_tech_ledger | t_tech_ledger | 1 | |
| t_ubzdt_pn | t_ubzdt_pn | 1 | |
| t_vorgn | t_vorgn | 1 | |
| t_vsl | t_vsl | 1 | |
| t_xmanpropval_pn | t_xmanpropval_pn | 1 | |
| t_xreversed | t_xreversed | 1 | |
| t_xreversing | t_xreversing | 1 | |
| t_xsettled | t_xsettled | 1 | |
| t_xsettling | t_xsettling | 1 | |
| t_xvabg_pn | t_xvabg_pn | 1 | |
| t_zuonr | t_zuonr | 1 | |
| tech_ledger_d | tech_ledger_d | 1 | |
| ubzdt_pn_d | ubzdt_pn_d | 1 | |
| vorgn | vorgn | 1 | |
| vorgn_d | vorgn_d | 1 | |
| vsl_d | vsl_d | 1 | |
| xmanpropval_pn_d | xmanpropval_pn_d | 1 | |
| xreversed_d | xreversed_d | 1 | |
| xreversing_d | xreversing_d | 1 | |
| xsettled_d | xsettled_d | 1 | |
| xsettling_d | xsettling_d | 1 | |
| xvabg_pn_d | xvabg_pn_d | 1 | |
| zuonr_d | zuonr_d | 1 |
@AbapCatalog.sqlViewName: 'FAAVDOCITCP111'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Compare from DOC_IT to ACDOCA'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XXL
define view FAA_SDM_DOCIT_CP111
as select from faat_doc_it as doc_it
inner join FAA_CFG_DEPR_AREA as cfg_depr_area on doc_it.bukrs = cfg_depr_area.comp_code
and doc_it.afabe = cfg_depr_area.depr_area
inner join fins_tech_ledger as ledger on ledger.rldnr = cfg_depr_area.ledger
and ledger.tech_ledger <> ''
left outer join acdoca as acdoca on doc_it.bukrs = acdoca.rbukrs
and doc_it.anln1 = acdoca.anln1
and doc_it.anln2 = acdoca.anln2
and doc_it.gjahr = acdoca.gjahr
and doc_it.awtyp = acdoca.awtyp
and doc_it.awref = acdoca.awref
and doc_it.aworg = acdoca.aworg
and doc_it.awsys = acdoca.awsys
and doc_it.subta = acdoca.subta
and doc_it.afabe = acdoca.afabe
and doc_it.slalittype = acdoca.slalittype
and doc_it.drcrk = acdoca.drcrk
and ledger.tech_ledger = acdoca.rldnr
and acdoca.awtyp <> 'AMDP'
and acdoca.mig_source = 'A'
left outer join FAA_SDM_DOCIT_CP02 as split_number on split_number.bukrs = doc_it.bukrs
and split_number.anln1 = doc_it.anln1
and split_number.anln2 = doc_it.anln2
and split_number.gjahr = doc_it.gjahr
and split_number.awtyp = doc_it.awtyp
and split_number.awref = doc_it.awref
and split_number.aworg = doc_it.aworg
and split_number.awsys = doc_it.awsys
and split_number.subta = doc_it.subta
and split_number.afabe = doc_it.afabe
and split_number.slalittype = doc_it.slalittype
and split_number.drcrk = doc_it.drcrk
and split_number.source_table = 'DOC_IT'
left outer to one join acdoca as fi_doc on doc_it.has_fi_doc = 'X'
and fi_doc.rldnr = ledger.rldnr
and fi_doc.awtyp = doc_it.awtyp
and fi_doc.awref = doc_it.awref
and fi_doc.aworg = doc_it.aworg
and fi_doc.awsys = doc_it.awsys
and fi_doc.rbukrs = doc_it.bukrs
and fi_doc.anln1 = doc_it.anln1
and fi_doc.anln2 = doc_it.anln2
and fi_doc.gjahr = doc_it.gjahr
and fi_doc.subta = doc_it.subta
and fi_doc.afabe = doc_it.afabe_fi_doc
and fi_doc.movcat = doc_it.movcat
{
key doc_it.bukrs,
key doc_it.anln1,
key doc_it.anln2,
key doc_it.gjahr,
key doc_it.awtyp,
key doc_it.awref,
key doc_it.aworg,
key doc_it.awsys,
key doc_it.subta,
key doc_it.afabe,
key doc_it.slalittype,
key doc_it.drcrk,
key cast( acdoca.rldnr as fins_technical_ledger preserving type ) as rldnr,
key acdoca.belnr,
key acdoca.docln,
cast( case
when split_number.counter is null then 0
else split_number.counter
end as int4 preserving type ) as split_number,
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,
cast( ledger.tech_ledger as fins_technical_ledger preserving type ) as s_tech_ledger,
cast( acdoca.rldnr as fins_technical_ledger preserving type ) as t_tech_ledger,
case
when acdoca.rbukrs is null then 'X'
when ledger.tech_ledger <> acdoca.rldnr then 'X'
else ''
end as tech_ledger_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,
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,
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,
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,
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,
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,
@Semantics.amount.currencyCode: 's_rhcur'
doc_it.hsl as s_hsl,
@Semantics.amount.currencyCode: 't_rhcur'
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,
@Semantics.amount.currencyCode: 's_rkcur'
doc_it.ksl as s_ksl,
@Semantics.amount.currencyCode: 't_rkcur'
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,
@Semantics.amount.currencyCode: 's_rocur'
doc_it.osl as s_osl,
@Semantics.amount.currencyCode: 't_rocur'
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,
@Semantics.amount.currencyCode: 's_rvcur'
doc_it.vsl as s_vsl,
@Semantics.amount.currencyCode: 't_rvcur'
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,
@Semantics.currencyCode: true
doc_it.rhcur as s_rhcur,
@Semantics.currencyCode: true
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,
@Semantics.currencyCode: true
doc_it.rkcur as s_rkcur,
@Semantics.currencyCode: true
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,
@Semantics.currencyCode: true
doc_it.rocur as s_rocur,
@Semantics.currencyCode: true
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,
@Semantics.currencyCode: true
doc_it.rvcur as s_rvcur,
@Semantics.currencyCode: true
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,
@Semantics.currencyCode: true
cast( '' as fins_currfc ) as s_rfccur,
@Semantics.currencyCode: true
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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 = '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,
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,
case
when fi_doc.rbukrs is null then doc_it.bldat
else fi_doc.bldat
end as s_bldat,
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,
case
when fi_doc.rbukrs is null then doc_it.sgtxt
else fi_doc.sgtxt
end as s_sgtxt,
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,
case
when fi_doc.rbukrs is null then doc_it.zuonr
else fi_doc.zuonr
end as s_zuonr,
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,
case
when fi_doc.rbukrs is null then doc_it.obart
when fi_doc.rbukrs is not null and fi_doc.parob1 is initial then doc_it.obart
else cast( substring(fi_doc.parob1,1,2) as a_obart preserving type )
end as s_obart,
cast( substring(acdoca.parob1,1,2)
as a_obart preserving type ) as t_obart,
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,
case
when fi_doc.rbukrs is null then doc_it.objid
when fi_doc.rbukrs is not null and fi_doc.parob1 is initial then doc_it.objid
else cast( substring(fi_doc.parob1,3,20) as a_objid preserving type )
end as s_objid,
cast( substring(acdoca.parob1,3,20)
as a_objid preserving type ) as t_objid,
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,
case
when fi_doc.rbukrs is null then doc_it.ubzdt_pn
else fi_doc.ubzdt_pn
end as s_ubzdt_pn,
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,
case
when fi_doc.xvabg_pn = 'X' then fi_doc.xvabg_pn
else doc_it.xvabg_pn
end as s_xvabg_pn,
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,
case
when fi_doc.rbukrs is null then doc_it.prozs_pn
else fi_doc.prozs_pn
end as s_prozs_pn,
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,
case
when fi_doc.rbukrs is null then doc_it.xmanpropval_pn
else fi_doc.xmanpropval_pn
end as s_xmanpropval_pn,
acdoca.xmanpropval_pn as t_xmanpropval_pn,
case
when acdoca.rbukrs is null then 'X'
when fi_doc.rbukrs is null and doc_it.xmanpropval_pn <> acdoca.xmanpropval_pn then 'X'
when fi_doc.rbukrs is not null and fi_doc.xmanpropval_pn <> acdoca.xmanpropval_pn then 'X'
else ''
end as xmanpropval_pn_d,
@EndUserText.label: 'Different'
@EndUserText.quickInfo: 'Has some differences'
case
when acdoca.rbukrs is null then 'Y'
else ''
end as different,
cast( '+' as char01 preserving type ) as direction,
doc_it.anlkl,
doc_it.movcat,
doc_it.bwasl,
doc_it.vorgn,
doc_it.sdm_status
}
where
doc_it.sdm_status = '19'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAA_CFG_DEPR_AREA",
"FAA_SDM_DOCIT_CP02",
"ACDOCA",
"FAAT_DOC_IT",
"FINS_TECH_LEDGER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/