FAA_SDM_DOCIT_CP11

@AbapCatalog.sqlViewName: 'FAAVDOCITCP11'
@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_CP11
  as select from FAA_SDM_DOCIT_CP111 as doc_comp
{
  key doc_comp.bukrs,
  key doc_comp.anln1,
  key doc_comp.anln2,
  key doc_comp.gjahr,
  key doc_comp.awtyp,
  key doc_comp.awref,
  key doc_comp.aworg,
  key doc_comp.awsys,
  key doc_comp.subta,
  key doc_comp.afabe,
  key doc_comp.slalittype,
  key doc_comp.drcrk,
  key doc_comp.rldnr,
  key doc_comp.belnr,
  key doc_comp.docln,
      @EndUserText.label: 'Number of splits'
      @EndUserText.quickInfo: 'Number of splits'
      doc_comp.split_number,
      doc_comp.s_awitem,
      doc_comp.t_awitem,
      doc_comp.awitem_d,

      doc_comp.s_tech_ledger,
      doc_comp.t_tech_ledger,
      doc_comp.tech_ledger_d,

      doc_comp.s_vorgn,
      doc_comp.t_vorgn,
      doc_comp.vorgn_d,

      doc_comp.s_budat,
      doc_comp.t_budat,
      doc_comp.budat_d,

      doc_comp.s_bzdat,
      doc_comp.t_bzdat,
      doc_comp.bzdat_d,

      doc_comp.s_poper,
      doc_comp.t_poper,
      doc_comp.poper_d,

      doc_comp.s_bwasl,
      doc_comp.t_bwasl,
      doc_comp.bwasl_d,

      doc_comp.s_movcat,
      doc_comp.t_movcat,
      doc_comp.movcat_d,

      @Semantics.amount.currencyCode: 's_rhcur'
      doc_comp.s_hsl,
      @Semantics.amount.currencyCode: 't_rhcur'
      doc_comp.t_hsl,
      doc_comp.hsl_d,

      @Semantics.amount.currencyCode: 's_rkcur'
      doc_comp.s_ksl,
      @Semantics.amount.currencyCode: 't_rkcur'
      doc_comp.t_ksl,
      doc_comp.ksl_d,

      @Semantics.amount.currencyCode: 's_rocur'
      doc_comp.s_osl,
      @Semantics.amount.currencyCode: 't_rocur'
      doc_comp.t_osl,
      doc_comp.osl_d,

      @Semantics.amount.currencyCode: 's_rvcur'
      doc_comp.s_vsl,
      @Semantics.amount.currencyCode: 't_rvcur'
      doc_comp.t_vsl,
      doc_comp.vsl_d,

      @Semantics.currencyCode: true
      doc_comp.s_rhcur,
      @Semantics.currencyCode: true
      doc_comp.t_rhcur,
      doc_comp.rhcur_d,

      @Semantics.currencyCode: true
      doc_comp.s_rkcur,
      @Semantics.currencyCode: true
      doc_comp.t_rkcur,
      doc_comp.rkcur_d,

      @Semantics.currencyCode: true
      doc_comp.s_rocur,
      @Semantics.currencyCode: true
      doc_comp.t_rocur,
      doc_comp.rocur_d,

      @Semantics.currencyCode: true
      doc_comp.s_rvcur,
      @Semantics.currencyCode: true
      doc_comp.t_rvcur,
      doc_comp.rvcur_d,

      @Semantics.currencyCode: true
      doc_comp.s_rfccur,
      @Semantics.currencyCode: true
      doc_comp.t_rfccur,
      doc_comp.rfccur_d,

      doc_comp.s_xreversing,
      doc_comp.t_xreversing,
      doc_comp.xreversing_d,

      doc_comp.s_xreversed,
      doc_comp.t_xreversed,
      doc_comp.xreversed_d,

      doc_comp.s_xsettling,
      doc_comp.t_xsettling,
      doc_comp.xsettling_d,

      doc_comp.s_xsettled,
      doc_comp.t_xsettled,
      doc_comp.xsettled_d,

      doc_comp.s_prec_awtyp,
      doc_comp.t_prec_awtyp,
      doc_comp.prec_awtyp_d,

      doc_comp.s_prec_aworg,
      doc_comp.t_prec_aworg,
      doc_comp.prec_aworg_d,

      doc_comp.s_prec_awref,
      doc_comp.t_prec_awref,
      doc_comp.prec_awref_d,

      doc_comp.s_prec_subta,
      doc_comp.t_prec_subta,
      doc_comp.prec_subta_d,

      doc_comp.s_awtyp_rev,
      doc_comp.t_awtyp_rev,
      doc_comp.awtyp_rev_d,

      doc_comp.s_awref_rev,
      doc_comp.t_awref_rev,
      doc_comp.awref_rev_d,

      doc_comp.s_aworg_rev,
      doc_comp.t_aworg_rev,
      doc_comp.aworg_rev_d,

      doc_comp.s_subta_rev,
      doc_comp.t_subta_rev,
      doc_comp.subta_rev_d,

      doc_comp.s_anlkl,
      doc_comp.t_anlkl,
      doc_comp.anlkl_d,

      doc_comp.s_ktogr,
      doc_comp.t_ktogr,
      doc_comp.ktogr_d,

      doc_comp.s_panl1,
      doc_comp.t_panl1,
      doc_comp.panl1_d,

      doc_comp.s_panl2,
      doc_comp.t_panl2,
      doc_comp.panl2_d,

      doc_comp.s_mig_source,
      doc_comp.t_mig_source,
      doc_comp.mig_source_d,

      doc_comp.s_recid,
      doc_comp.t_recid,
      doc_comp.recid_d,

      doc_comp.s_bldat,
      doc_comp.t_bldat,
      doc_comp.bldat_d,

      doc_comp.s_sgtxt,
      doc_comp.t_sgtxt,
      doc_comp.sgtxt_d,

      doc_comp.s_zuonr,
      doc_comp.t_zuonr,
      doc_comp.zuonr_d,

      doc_comp.s_obart,
      doc_comp.t_obart,
      doc_comp.obart_d,

      doc_comp.s_objid,
      doc_comp.t_objid,
      doc_comp.objid_d,

      doc_comp.s_ubzdt_pn,
      doc_comp.t_ubzdt_pn,
      doc_comp.ubzdt_pn_d,

      doc_comp.s_xvabg_pn,
      doc_comp.t_xvabg_pn,
      doc_comp.xvabg_pn_d,

      doc_comp.s_prozs_pn,
      doc_comp.t_prozs_pn,
      doc_comp.prozs_pn_d,

      doc_comp.s_xmanpropval_pn,
      doc_comp.t_xmanpropval_pn,
      doc_comp.xmanpropval_pn_d,

      @EndUserText.label: 'Different'
      @EndUserText.quickInfo: 'Has some differences'
      case
        when doc_comp.different = 'Y' then 'Y'
        when doc_comp.awitem_d = 'X' then 'X'
        when doc_comp.tech_ledger_d = 'X' then 'X'
        when doc_comp.vorgn_d = 'X' then 'X'
        when doc_comp.budat_d = 'X' then 'X'
        when doc_comp.bzdat_d = 'X' then 'X'
        when doc_comp.poper_d = 'X' then 'X'
        when doc_comp.bwasl_d = 'X' then 'X'
        when doc_comp.movcat_d = 'X' then 'X'
        when doc_comp.hsl_d = 'X' then 'X'
        when doc_comp.ksl_d = 'X' then 'X'
        when doc_comp.osl_d = 'X' then 'X'
        when doc_comp.vsl_d = 'X' then 'X'
        when doc_comp.rhcur_d = 'X' then 'X'
        when doc_comp.rkcur_d = 'X' then 'X'
        when doc_comp.rocur_d = 'X' then 'X'
        when doc_comp.rvcur_d = 'X' then 'X'
        when doc_comp.rfccur_d = 'X' then 'X'
        when doc_comp.xreversing_d = 'X' then 'X'
        when doc_comp.xreversed_d = 'X' then 'X'
        when doc_comp.xsettling_d = 'X' then 'X'
        when doc_comp.xsettled_d = 'X' then 'X'
        when doc_comp.prec_awtyp_d = 'X' then 'X'
        when doc_comp.prec_aworg_d = 'X' then 'X'
        when doc_comp.prec_awref_d = 'X' then 'X'
        when doc_comp.prec_subta_d = 'X' then 'X'
        when doc_comp.awtyp_rev_d = 'X' then 'X'
        when doc_comp.awref_rev_d = 'X' then 'X'
        when doc_comp.aworg_rev_d = 'X' then 'X'
        when doc_comp.subta_rev_d = 'X' then 'X'
        when doc_comp.anlkl_d = 'X' then 'X'
        when doc_comp.ktogr_d = 'X' then 'X'
        when doc_comp.panl1_d = 'X' then 'X'
        when doc_comp.panl2_d = 'X' then 'X'
        when doc_comp.mig_source_d = 'X' then 'X'
        when doc_comp.recid_d = 'X' then 'X'
        when doc_comp.bldat_d = 'X' then 'X'
        when doc_comp.sgtxt_d = 'X' then 'X'
        when doc_comp.zuonr_d = 'X' then 'X'
        when doc_comp.obart_d = 'X' then 'X'
        when doc_comp.objid_d = 'X' then 'X'
        when doc_comp.ubzdt_pn_d = 'X' then 'X'
        when doc_comp.xvabg_pn_d = 'X' then 'X'
        when doc_comp.prozs_pn_d = 'X' then 'X'
        when doc_comp.xmanpropval_pn_d = 'X' then 'X'
        else ''
      end as different,
      doc_comp.direction,
      doc_comp.anlkl,
      doc_comp.movcat,
      doc_comp.bwasl,
      doc_comp.vorgn,
      doc_comp.sdm_status
}

/*define view FAA_SDM_DOCIT_CP11
  with parameters
    P_SDM_STATUS : faa_sdm_status
  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             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 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
{
  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.prec_awtyp = '!BCF!' and acdoca.prec_awtyp <> '') or
             ( doc_it.prec_awtyp <> '!BCF!' 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,
      //doc_it.bldat                                                        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 acdoca.rbukrs is null then 'X'

      //  when doc_it.movcat <> '00' and doc_it.bldat is initial and acdoca.bldat is initial then 'X'

      //  when doc_it.movcat <> '00' and doc_it.bldat is not initial and doc_it.bldat <> acdoca.bldat then 'X'

      //  when doc_it.movcat = '00' and doc_it.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,
      //doc_it.sgtxt                                                        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