I_WORKFLOWTASKSTARTEVENT

CDS View

Work item starting event

I_WORKFLOWTASKSTARTEVENT is a CDS View in S/4HANA. Work item starting event. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_EHSTaskInstanceStartEvent32 view from COMPOSITE
@AbapCatalog : {
  sqlViewName: 'IWFTASKEVENT',
  buffering.type: #NONE
}
@EndUserText.label: 'Work item starting event'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType : {
  dataClass: #MASTER,
  serviceQuality: #B,
  sizeCategory: #M
}
define view I_WorkflowTaskStartEvent
  as select from swwloghist

{
  key wi_id                                                                                                      as WorkflowTaskInternalID,
      cast( timestamp as sww_start_event_timestamp )                                                             as WrkflwStrtEvtReceivedUTCDteTme,
      cast( substring( para_val_1, 1, 2 ) as sibfcatid )                                                         as WrkflwStartEventObjectCategory,
      //      typeid        as TechnicalObjectType,

      //      instid        as TechnicalObjectInstance,

      case substring( para_val_1, 1, 2 )
        when 'BO' then cast( substring( para_val_1, 3, 10 ) as sibftypeid )
        when 'CL' then cast( substring( para_val_1, 3, 30 ) as sibftypeid )
        else substring( para_val_1, 3, 30 )
      end                                                                                                        as WorkflowStartEventObjectType,
      case substring( para_val_1, 1, 2 )
        when 'BO' then cast( substring( para_val_1, 13, 90 ) as sibfboriid )
        when 'CL' then cast( substring( para_val_1, 33, 64 ) as sibfboriid )
        else cast( substring( para_val_1, 33, 64 ) as sibfboriid )
      end                                                                                                        as WorkflowStartEventObject,
      cast( para_val_2 as swo_event )                                                                            as WorkflowStartEventName

}
where
      method     = 'SWW_WI_CREATE_VIA_EVENT_INTERN'
  and para_nam_1 = '$OBJECT'