I_WorkflowTaskStartEvent

DDL: I_WORKFLOWTASKSTARTEVENT Type: view BASIC

Work item starting event

I_WorkflowTaskStartEvent is a Basic CDS View that provides data about "Work item starting event" in SAP S/4HANA. It reads from 1 data source (swwloghist) and exposes 4 fields with key field WorkflowTaskInternalID.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
swwloghist swwloghist from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IWFTASKEVENT view
AbapCatalog.buffering.type #NONE view
EndUserText.label Work item starting event view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID wi_id
WrkflwStrtEvtReceivedUTCDteTme
WrkflwStartEventObjectCategory
WorkflowStartEventName 
@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'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SWWLOGHIST"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More