I_WorkflowTaskResult

DDL: I_WORKFLOWTASKRESULT SQL: IWRKFLWTSKRESULT Type: view BASIC

Workflow Task Result

I_WorkflowTaskResult is a Basic CDS View that provides data about "Workflow Task Result" in SAP S/4HANA. It reads from 2 data sources (swwwihead, swpsteplog) and exposes 8 fields with key fields WorkflowInternalID, WorkflowTaskInternalID. It has 2 associations to related views.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
swwwihead head left_outer
swpsteplog steplog from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_WorkflowTaskResultComment _WorkflowTaskResultComment _WorkflowTaskResultComment.WorkflowTaskInternalID = steplog.wi_id
[0..1] I_WorkflowTaskResultReason _WorkflowTaskResultReason $projection.WorkflowScenarioDefinition = _WorkflowTaskResultReason.WorkflowScenarioDefinition and $projection.WorkflowTaskResultReason = _WorkflowTaskResultReason.WorkflowTaskResultReason

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IWRKFLWTSKRESULT view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Workflow Task Result view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY WorkflowInternalID swpsteplog wf_id
KEY WorkflowTaskInternalID swpsteplog wi_id
WorkflowTaskResult swpsteplog flex_return_value
WorkflowTaskResultNature swpsteplog flex_return_nature
WorkflowTaskResultReason swpsteplog flex_decision_reason
WorkflowScenarioDefinition swwwihead top_task
WorkflowTaskResultComment _WorkflowTaskResultComment WorkflowTaskResultComment
_WorkflowTaskResultReason _WorkflowTaskResultReason 
@AbapCatalog.sqlViewName: 'IWRKFLWTSKRESULT'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'Workflow Task Result'
define view I_WorkflowTaskResult
  as select from    swpsteplog as steplog
    left outer join swwwihead  as head on head.wi_id = steplog.wi_id
  association [0..1] to I_WorkflowTaskResultComment as _WorkflowTaskResultComment on  _WorkflowTaskResultComment.WorkflowTaskInternalID = steplog.wi_id
  association [0..1] to I_WorkflowTaskResultReason  as _WorkflowTaskResultReason  on  $projection.WorkflowScenarioDefinition = _WorkflowTaskResultReason.WorkflowScenarioDefinition
                                                                                  and $projection.WorkflowTaskResultReason   = _WorkflowTaskResultReason.WorkflowTaskResultReason
{
  key steplog.wf_id                                        as WorkflowInternalID,
  key steplog.wi_id                                        as WorkflowTaskInternalID,
      steplog.flex_return_value                            as WorkflowTaskResult,
      steplog.flex_return_nature                           as WorkflowTaskResultNature,
      steplog.flex_decision_reason                         as WorkflowTaskResultReason,
      head.top_task                                        as WorkflowScenarioDefinition,
      _WorkflowTaskResultComment.WorkflowTaskResultComment as WorkflowTaskResultComment,
      _WorkflowTaskResultReason
}
where
  (
       steplog.returntyp = 'RV'
    or steplog.returntyp = 'EV'
    or steplog.returntyp = 'FX'
  )
  and  steplog.flex_return_value != ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKFLOWTASKRESULTCOMMENT",
"SWPSTEPLOG",
"SWWWIHEAD"
],
"ASSOCIATED":
[
"I_WORKFLOWTASKRESULTCOMMENT",
"I_WORKFLOWTASKRESULTREASON"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More