P_Facvd_Wf_Task_Max_Timestamp

DDL: P_FACVD_WF_TASK_MAX_TIMESTAMP SQL: PWFTASKTS Type: view BASIC Package: ODATA_GL_JOURNALENTRY_VER

max timestamp of workflow

P_Facvd_Wf_Task_Max_Timestamp is a Basic CDS View that provides data about "max timestamp of workflow" in SAP S/4HANA. It reads from 3 data sources (vbkpf, sww_wi2obj, swwwihead) and exposes 2 fields with key field wi_id. Part of development package ODATA_GL_JOURNALENTRY_VER.

3 data source(s) 2 fields

Data Sources (3)

SourceAliasJoin Type
vbkpf _doc from
sww_wi2obj _wi2obj inner
swwwihead task inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PWFTASKTS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #BASIC view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY wi_id swwwihead top_wi_id
timestamp 
@AbapCatalog.sqlViewName: 'PWFTASKTS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private:true
@VDM.viewType: #BASIC
define view P_Facvd_Wf_Task_Max_Timestamp
  as select from vbkpf      as _doc
    inner join   sww_wi2obj as _wi2obj on _doc.awkey = _wi2obj.instid
    inner join   swwwihead  as task    on _wi2obj.wi_id = task.wi_id

{
  key task.top_wi_id                            as wi_id,
      cast( max( task.crea_tmp ) as swfrcrets ) as timestamp
}
/* changed by i337033 2020-01-02
   enable currency adjustement workflow*/
where
  (
       task.top_task =    'WS02800046'
    or task.top_task =    'WS78500019' 
  )
  /* exclude review workflow dialog workitem*/
  and  task.wi_rh_task <> 'TS78500090' and task.wi_rh_task <> 'TS78500091' 
  
  /* changed by i337033
     workflow team deliver new feature 'Review workflow' in CE2105 after DC
     should include POST step in this CDS view
  */
  and(
       task.wi_type  =    'W'
    or task.wi_type  =    'B'
  )
  and  _doc.tcode    like 'FBDC_P%'
  and  _doc.ausbk    =    _doc.bukrs
group by
  task.top_wi_id

Learn More