FAA_SDM_DOCIT_CP131

@AbapCatalog.sqlViewName: 'FAAVDOCITCP131'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Compare for Redundant update'

@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XXL

define view FAA_SDM_DOCIT_CP131
  as select from           FAA_SDM_DOCIT_CP130 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             finsc_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 doc_it.tech_ledger =  acdoca.rldnr
                                                         and acdoca.awtyp       <> 'AMDP'
                                                         and acdoca.mig_source  <> 'A'
    left outer to one join acdoca              as fi_doc on  doc_it.has_fi_doc = 'X'
                                                         and fi_doc.rldnr      = doc_it.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( 1 as int4 )                                                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,

      doc_it.tech_ledger                                               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 doc_it.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.poper is initial and acdoca.poper is initial then 'X'
        when doc_it.poper is not initial 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.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.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
        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 <> acdoca.parob1 then 'X'
        else ''
      end                                                              as obart_d,

      case
        when fi_doc.rbukrs is null 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 <> 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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAA_SDM_DOCIT_CP130",
"ACDOCA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/