P_WorkflowVerifyDialogItem

@AbapCatalog.sqlViewName: 'PFIWFVERDIAI'
@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

//latest singe Dialog Item with latest timestamp

define view P_WorkflowVerifyDialogItem
  as select from P_Facvd_Ver_Diag_Max_Timestamp as _timestamp
    inner join   sww_wi2obj                     as _wi2obj on _wi2obj.instid = _timestamp.instid
    inner join   swwwihead                      as _head   on  _wi2obj.wi_id   = _head.wi_id
                                                           and _head.top_wi_id = _timestamp.Workflow
                                                           and _head.crea_tmp  = _timestamp.timestamp
{
  key _head.top_wi_id  as Workflow,
  key max(_head.wi_id) as WorkItem,
      _wi2obj.instid
}
where
  (
       _head.wi_type    =  'W'
  ) // 'W'=Dialog Work Item, 'Q'=Dialog Block

  and(
       _head.wi_rh_task <> 'TS00008267'
  ) // exculde redo

  and(
       _head.wfd_id     =  'WS02800046'
    or _head.wfd_id     =  'WS78500019'
    or ( _head.wfd_id   = '' and _head.top_task = 'WS02800046' ) // note 3399634

  )

// 201900709 modified by JINAGSE +

/*
where ( wi_type = 'W' ) // 'W'=Dialog Work Item, 'Q'=Dialog Block

    and ( step_id = 'VerifyMultiInstance' or step_id = 'Verify' or step_id = 'Redo' )
    and ( wfd_id = 'WS02800046')
// 201900709 modified by JINAGSE +

*/
group by
  _head.top_wi_id,
  _wi2obj.instid