ACE_ACDOCA_MIG_ACCR

CDS View

Get original source from ACDOCA

ACE_ACDOCA_MIG_ACCR is a CDS View in S/4HANA. Get original source from ACDOCA. It contains 21 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 21 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
ACE_ACDOCA_MIG_ACRTYPE_RULE view from Get original source from ACDOCA

Fields (21)

KeyField CDS FieldsUsed in Views
KEY acrobjtype acrobjtype 1
KEY gjahr gjahr 1
KEY rbukrs rbukrs 1
acritmtype acritmtype 1
acrobj_id acrobj_id 1
acrsobj_id acrsobj_id 1
awkey awkey 1
awsys awsys 1
awtyp awtyp 1
currency currency 1
effdate effdate 1
mig_source mig_source 1
podate podate 1
poper poper 1
poyear poyear 1
pre_gjahr pre_gjahr 1
rldnr rldnr 1
slalittype slalittype 1
timestamp timestamp 1
transtype transtype 1
valtbp valtbp 1 
@AbapCatalog.sqlViewName: 'ACEV_MIG_ACCR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass:  #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #X
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Get original source from ACDOCA'
@AbapCatalog.preserveKey:true

define view ACE_ACDOCA_MIG_ACCR
  as select from acdoca
{
  key rldnr,
  key rbukrs,
  key gjahr,
  key belnr,
  key docln,
      acrobjtype,
      acrlogsys,
      cast ( acritmtype as ace_itemtype ) as acritmtype,
      acrobj_id,
      acrsobj_id,
      cast( ( cast( acdoca.gjahr as abap.int4 ) - 1 ) as abap.char( 40 ) ) as pre_gjahr,
      slalittype,
      case slalittype
        when '09001' then wsl
        when '09002' then wsl
        when '09003' then (-1)*wsl
        when '09004' then (-1)*wsl
        when '09005' then wsl
      end                                                                  as valtbp,
      rwcur                                                                as currency,
      cast( case slalittype
        when '09001' then 'I'
        when '09002' then 'U'
        when '09003' then 'P'
        when '09004' then 'C'
        when '09005' then 'F'
      end as ace_transtype )                                               as transtype,
      bldat                                                                as effdate,
      budat                                                                as podate,
      poper,
      ryear                                                                as poyear,
      awtyp,
      concat( awref, aworg )                                               as awkey,
      awsys,
      timestamp,
      mig_source

}
where
       acrobj_id  <> ''
  and  acrsobj_id <> ''
  and  acrobjtype <> ''
  and  acritmtype <> ''
  and(
       slalittype =  '09001'
    or slalittype =  '09002'
    or slalittype =  '09003'
    or slalittype =  '09004'
    or slalittype =  '09005'
  )
  and mig_source = 'D'

Learn More