FAA_SDM_DOCIT_CP130

@AbapCatalog.sqlViewName: 'FAAVDOCITCP130'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'DOC_IT projection'

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

define view FAA_SDM_DOCIT_CP130
  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 <> ''
{
  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,
      ledger.rldnr,
      ledger.tech_ledger,
      doc_it.awitem,
      doc_it.vorgn,
      doc_it.budat,
      doc_it.bzdat,
      doc_it.poper,
      doc_it.bwasl,
      doc_it.movcat,
      @Semantics.amount.currencyCode: 'rhcur'
      doc_it.hsl,
      @Semantics.amount.currencyCode: 'rkcur'
      doc_it.ksl,
      @Semantics.amount.currencyCode: 'rocur'
      doc_it.osl,
      @Semantics.amount.currencyCode: 'rvcur'
      doc_it.vsl,
      @Semantics.currencyCode: true
      doc_it.rhcur,
      @Semantics.currencyCode: true
      doc_it.rkcur,
      @Semantics.currencyCode: true
      doc_it.rocur,
      @Semantics.currencyCode: true
      doc_it.rvcur,
      doc_it.has_fi_doc,
      doc_it.afabe_fi_doc,
      doc_it.xreversing,
      doc_it.xreversed,
      doc_it.xsettling,
      doc_it.xsettled,
      doc_it.prec_awtyp,
      doc_it.prec_aworg,
      doc_it.prec_awref,
      doc_it.prec_subta,
      doc_it.awtyp_rev,
      doc_it.awref_rev,
      doc_it.aworg_rev,
      doc_it.subta_rev,
      doc_it.anlkl,
      doc_it.ktogr,
      doc_it.panl1,
      doc_it.panl2,
      doc_it.mig_source,
      doc_it.recid,
      doc_it.bldat,
      doc_it.sgtxt,
      doc_it.zuonr,
      doc_it.obart,
      doc_it.objid,
      doc_it.ubzdt_pn,
      doc_it.xvabg_pn,
      doc_it.prozs_pn,
      doc_it.xmanpropval_pn,
      doc_it.sdm_status
}
where
      doc_it.sdm_status =  '1A'
  and doc_it.movcat     <> '00'
  and doc_it.movcat     <> '46'
  and doc_it.movcat     <> '65'

union 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
                                                     and cfg_depr_area.POSTING_TYPE = '0'
  inner join      fins_tech_ledger      as ledger        on  ledger.rldnr       =  cfg_depr_area.ledger
                                                     and ledger.tech_ledger <> ''
{
  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 case doc_it.slalittype
        when '07003' then '07103'
        when '07004' then '07104'
        when '07005' then '07105'
        when '07006' then '07106'
        when '07007' then '07107'
        when '07008' then '07108'
        when '07009' then '07109'
        when '07023' then '07123'
        when '07024' then '07124'
        when '07025' then '07125'
        when '07026' then '07126'
        when '07027' then '07127'
        when '07028' then '07128'
        when '07029' then '07129'
        when '07043' then '07143'
        when '07044' then '07144'
        when '07045' then '07145'
        when '07046' then '07146'
        when '07047' then '07147'
        when '07048' then '07148'
        when '07049' then '07149'
        else doc_it.slalittype
      end as slalittype,
  key doc_it.drcrk,
      ledger.rldnr,
      ledger.tech_ledger,
      doc_it.awitem,
      doc_it.vorgn,
      doc_it.budat,
      doc_it.bzdat,
      doc_it.poper,
      doc_it.bwasl,
      doc_it.movcat,
      @Semantics.amount.currencyCode: 'rhcur'
      doc_it.hsl,
      @Semantics.amount.currencyCode: 'rkcur'
      doc_it.ksl,
      @Semantics.amount.currencyCode: 'rocur'
      doc_it.osl,
      @Semantics.amount.currencyCode: 'rvcur'
      doc_it.vsl,
      @Semantics.currencyCode: true
      doc_it.rhcur,
      @Semantics.currencyCode: true
      doc_it.rkcur,
      @Semantics.currencyCode: true
      doc_it.rocur,
      @Semantics.currencyCode: true
      doc_it.rvcur,
      doc_it.has_fi_doc,
      doc_it.afabe_fi_doc,
      doc_it.xreversing,
      doc_it.xreversed,
      doc_it.xsettling,
      doc_it.xsettled,
      doc_it.prec_awtyp,
      doc_it.prec_aworg,
      doc_it.prec_awref,
      doc_it.prec_subta,
      doc_it.awtyp_rev,
      doc_it.awref_rev,
      doc_it.aworg_rev,
      doc_it.subta_rev,
      doc_it.anlkl,
      doc_it.ktogr,
      doc_it.panl1,
      doc_it.panl2,
      doc_it.mig_source,
      doc_it.recid,
      doc_it.bldat,
      doc_it.sgtxt,
      doc_it.zuonr,
      doc_it.obart,
      doc_it.objid,
      doc_it.ubzdt_pn,
      doc_it.xvabg_pn,
      doc_it.prozs_pn,
      doc_it.xmanpropval_pn,
      doc_it.sdm_status
}
where
       doc_it.sdm_status =  '1A'
  and  doc_it.movcat     <> '00'
  and(
       doc_it.movcat     =  '46'
    or doc_it.movcat     =  '65'
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAA_CFG_DEPR_AREA",
"FAAT_DOC_IT",
"FINS_TECH_LEDGER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/