I_WORKFLOWTASKRESULT

CDS View

Workflow Task Result

I_WORKFLOWTASKRESULT is a CDS View in S/4HANA. Workflow Task Result. It contains 1 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 1 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ADM_WORKFLOWSTATUSDETAILS view left_outer COMPOSITE Workflow Task
I_WorkflowStatusDetails view left_outer COMPOSITE Workflow Task
P_DwnPaytReqWrkflwFnshStatus view_entity from COMPOSITE VSDPR Document Status of Workflow

Fields (1)

KeyField CDS FieldsUsed in Views
WorkflowTaskResult WorkflowTaskResult 2 
@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