FAA_CompDrvdAreaDocit01

@AbapCatalog.sqlViewName: 'FAAVPDADI01'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Compare Derived Area DOC_IT 01'

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

define view FAA_CompDrvdAreaDocit01
  as select from    faat_doc_it                 as doc_it
    inner join      I_DepreciationAreaForLedger as CalculatedDeprAreaForLedger on  doc_it.bukrs = CalculatedDeprAreaForLedger.CompanyCode
                                                                               and doc_it.afabe = CalculatedDeprAreaForLedger.AssetDepreciationArea
    inner join      I_AssetValuationView        as AssetValuationView          on  CalculatedDeprAreaForLedger.AssetValuationView = AssetValuationView.AssetValuationView
                                                                               and AssetValuationView.AssetValuationViewType      = 'C01'
    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 acdoca.awtyp      <> 'AMDP'
                                                                               and acdoca.mig_source =  'A'
    left outer join FAA_CompDrvdAreaSplitNum    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'
{
  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,

      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.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
      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 = '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,

      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,

      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,

      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,

      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,

      doc_it.obart                                                  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 doc_it.obart <> substring(acdoca.parob1,1,2) then 'X'
        else ''
      end                                                           as obart_d,

      doc_it.objid                                                  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 doc_it.objid <> substring(acdoca.parob1,3,20) then 'X'
        else ''
      end                                                           as objid_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,

      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,

      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,

      doc_it.xmanpropval_pn                                         as s_xmanpropval_pn,
      acdoca.xmanpropval_pn                                         as t_xmanpropval_pn,
      case
        when acdoca.rbukrs is null then 'X'
        when doc_it.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,

      doc_it.sdm_status
}