atpc_dvol_peak_creation_tstmp

DDL: ATPC_DVOL_PEAK_CREATION_TSTMP SQL: ATPC_DVOLP_CTS Type: view Package: ATP_LIVECHACHE_DEL

Data Volume for Peaks with Creation Timestamp

atpc_dvol_peak_creation_tstmp is a CDS View that provides data about "Data Volume for Peaks with Creation Timestamp" in SAP S/4HANA. It reads from 5 data sources (aufk, plaf, resb, vbap, vbbe) and exposes 7 fields with key fields mandt, matnr, werks, mandt, matnr. Part of development package ATP_LIVECHACHE_DEL.

5 data source(s) 7 fields

Data Sources (5)

SourceAliasJoin Type
aufk aufk left_outer
plaf plaf left_outer
resb resb union
vbap vbap from
vbbe vbbe inner

Parameters (1)

NameTypeDefault
iv_time_zone timezone

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ATPC_DVOLP_CTS view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Data Volume for Peaks with Creation Timestamp view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY mandt vbap mandt
KEY matnr vbap matnr
KEY werks vbap werks
KEY mandt
KEY matnr resb matnr
KEY werks resb werks
KEY clientNULLendascreation_tstmp 
@AbapCatalog.sqlViewName: 'ATPC_DVOLP_CTS'
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType: {
    serviceQuality: #X,
    sizeCategory: #XXL,
    dataClass: #MIXED
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Data Volume for Peaks with Creation Timestamp'
define view atpc_dvol_peak_creation_tstmp
  with parameters
    iv_time_zone : timezone
  as

  select from  vbap
    inner join vbbe on  vbap.mandt = vbbe.mandt
                    and vbap.matnr = vbbe.matnr
                    and vbap.werks = vbbe.werks
{
  key vbap.mandt,
  key vbap.matnr,
  key vbap.werks,
  key dats_tims_to_tstmp( erdat, erzet, :iv_time_zone, $session.client, 'NULL' )             as creation_tstmp
}
where
      vbap.matnr <> ''
  and vbap.werks <> ''
  and vbap.sobkz =  ''

union

select from       resb
  left outer join plaf on  resb.mandt = plaf.mandt
                       and resb.plnum = plaf.plnum
  left outer join aufk on  resb.mandt = aufk.mandt
                       and resb.aufnr = aufk.aufnr
{
  key resb.mandt,
  key resb.matnr,
  key resb.werks,
  key case when plaf.plnum is not null
             then plaf.pstmp
           when aufk.aufnr is not null
             then dats_tims_to_tstmp(aedat, aezeit, :iv_time_zone, $session.client, 'NULL' )
      //       else null

           end                                                                              as creation_tstmp
}
where
       resb.xloek   =  ''
  and  resb.kzear   =  ''
  and  resb.bdmng   >  resb.enmng
  and  resb.dumps   =  ''
  and  resb.no_disp =  ''
  and  resb.txtps   =  ''
  and  resb.schgt   =  ''
  and  resb.dbskz   =  ''
  and(
       resb.vorab   is null
    or resb.vorab   =  ''
  )

  and  resb.matnr   <> ''
  and  resb.werks   <> ''
  and  resb.sobkz   =  '';

Learn More