I_WorkflowMyDecisionStatus

DDL: I_WORKFLOWMYDECISIONSTATUS SQL: IFICURRDECISTS Type: view COMPOSITE

Current User Decision Status

I_WorkflowMyDecisionStatus is a Composite CDS View that provides data about "Current User Decision Status" in SAP S/4HANA. It reads from 2 data sources (I_WorkflowTask, P_MySinglePresentDialogItem) and exposes 4 fields with key field WorkItem.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_WorkflowTask _head inner
P_MySinglePresentDialogItem _myPresentDialog from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IFICURRDECISTS view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey WorkItem view
VDM.viewType #COMPOSITE view
EndUserText.label Current User Decision Status view
AbapCatalog.dbHints.hint USE_HEX_PLAN view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY WorkItem P_MySinglePresentDialogItem WorkItem
Workflow P_MySinglePresentDialogItem Workflow
TaskProcessingStatus I_WorkflowTask WorkflowTaskStatus
WorkflowTaskDefinition I_WorkflowTask WorkflowTaskDefinition 
@AbapCatalog.sqlViewName: 'IFICURRDECISTS'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.representativeKey: 'WorkItem'
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Current User Decision Status'
@AbapCatalog.dbHints.hint: 'USE_HEX_PLAN'
define view I_WorkflowMyDecisionStatus

  as select from P_MySinglePresentDialogItem as _myPresentDialog
    inner join   I_WorkflowTask              as _head on _myPresentDialog.WorkItem = _head.WorkflowTaskInternalID

{
  key _myPresentDialog.WorkItem,

      _myPresentDialog.Workflow,
      _head.WorkflowTaskStatus     as TaskProcessingStatus,
      _head.WorkflowTaskDefinition as WorkflowTaskDefinition
}

/*
  as select from I_WorkflowTask as _head

{
  key _head.WorkflowTaskInternalID as WorkItem,

      _head.TopLevelWorkflowTask as Workflow,
      _head.WorkflowTaskStatus     as TaskProcessingStatus,
      _head.WorkflowTaskDefinition as WorkflowTaskDefinition
}
*/

Learn More