P_EHSWorkflowStep

DDL: P_EHSWORKFLOWSTEP Type: view COMPOSITE

P_EHSWorkflowStep is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_EHSTaskInstanceToDefinition, I_WorkflowTask) and exposes 25 fields with key field WorkflowTaskInternalID.

2 data source(s) 25 fields

Data Sources (2)

SourceAliasJoin Type
P_EHSTaskInstanceToDefinition _EHSTaskInstanceToDefinition inner
I_WorkflowTask _Step from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PEHSWFLSTP view
AbapCatalog.buffering.status #SWITCHED_OFF view
AbapCatalog.buffering.type #NONE view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID I_WorkflowTask WorkflowTaskInternalID
EHSTaskAdapterClass
EHSTaskDefinitionType
EHSTaskHostObjectInstance P_EHSTaskInstanceToDefinition EHSTaskHostObjectInstance
EHSTaskOwnerUser
EHSWorkflowHeaderStatus
WorkflowTaskType I_WorkflowTask WorkflowTaskType
WorkflowTaskPriority I_WorkflowTask WorkflowTaskPriority
WorkflowTaskStatus I_WorkflowTask WorkflowTaskStatus
WrkflwTskCreationUTCDateTime I_WorkflowTask WrkflwTskCreationUTCDateTime
WrkflwTskCompletionUTCDateTime I_WorkflowTask WrkflwTskCompletionUTCDateTime
WorkflowTaskCreatedByUser I_WorkflowTask WorkflowTaskCreatedByUser
WorkflowTaskCurrentUser I_WorkflowTask WorkflowTaskCurrentUser
WorkflowTaskDefinition I_WorkflowTask WorkflowTaskDefinition
WorkflowTaskDefinitionObjType I_WorkflowTask WorkflowTaskDefinitionObjType
WorkflowTaskDefinitionObject I_WorkflowTask WorkflowTaskDefinitionObject
TopLevelWorkflowTask I_WorkflowTask TopLevelWorkflowTask
_TaskTitle I_WorkflowTask _TaskTitle
_TaskType I_WorkflowTask _TaskType
_TaskPriority I_WorkflowTask _TaskPriority
_TaskStatus I_WorkflowTask _TaskStatus
_TaskApplicationObject I_WorkflowTask _TaskApplicationObject
_TaskApplicationLeadingObject I_WorkflowTask _TaskApplicationLeadingObject
_TaskStartEvent I_WorkflowTask _TaskStartEvent
_TaskDefinition I_WorkflowTask _TaskDefinition 
@AbapCatalog: {
  sqlViewName: 'PEHSWFLSTP',
  buffering.status: #SWITCHED_OFF,
  buffering.type: #NONE,
  preserveKey:true
}
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_EHSWorkflowStep
  as select from I_WorkflowTask                         as _Step                            // Workflow Step

    inner join P_EHSTaskInstanceToDefinition            as _EHSTaskInstanceToDefinition     // EHS only Workflow header with definition info

                                                        on _EHSTaskInstanceToDefinition.WorkflowTaskInternalID = _Step.TopLevelWorkflowTask
{
  key _Step.WorkflowTaskInternalID,
//    Start Event and Leading Object Information

      _EHSTaskInstanceToDefinition._EHSTaskDefinition.EHSTaskHostObjectAdapterClass as EHSTaskAdapterClass,
      _EHSTaskInstanceToDefinition._EHSTaskDefinition.EHSTaskWorkflowEvent as EHSTaskDefinitionType,
      _EHSTaskInstanceToDefinition.EHSTaskHostObjectInstance,
      _EHSTaskInstanceToDefinition._WorkflowTask.WorkflowTaskCreatedByUser as EHSTaskOwnerUser,
      _EHSTaskInstanceToDefinition._WorkflowTask.WorkflowTaskStatus as EHSWorkflowHeaderStatus,
      
//    Step Information

      _Step.WorkflowTaskType,
      _Step.WorkflowTaskPriority,
      _Step.WorkflowTaskStatus,
      _Step.WrkflwTskCreationUTCDateTime,
      _Step.WrkflwTskCompletionUTCDateTime,
      _Step.WorkflowTaskCreatedByUser,
      _Step.WorkflowTaskCurrentUser,
      _Step.WorkflowTaskDefinition,
      _Step.WorkflowTaskDefinitionObjType,
      _Step.WorkflowTaskDefinitionObject,
      _Step.TopLevelWorkflowTask,
      
//    Pass associations along  

      _Step._TaskTitle,
      _Step._TaskType,
      _Step._TaskPriority,
      _Step._TaskStatus,
      _Step._TaskApplicationObject,
      _Step._TaskApplicationLeadingObject,
      _Step._TaskStartEvent,      
      _Step._TaskDefinition
}
where _Step.WorkflowTaskType != 'F'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EHSTASKDEFINITION",
"I_WORKFLOWTASK",
"P_EHSTASKINSTANCETODEFINITION"
],
"ASSOCIATED":
[
"I_WORKFLOWTASKAPPLOBJECT",
"I_WORKFLOWTASKDEFINITION",
"I_WORKFLOWTASKLEADINGAPPLOBJ",
"I_WORKFLOWTASKPRIORITY",
"I_WORKFLOWTASKSTARTEVENT",
"I_WORKFLOWTASKSTATUS",
"I_WORKFLOWTASKTITLE",
"I_WORKFLOWTASKTYPE"
],
"BASE":
[
"I_WORKFLOWTASK"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More