P_EHSWorkflowStep

DDL: P_EHSWORKFLOWSTEP Type: view COMPOSITE
25 Fields 2 Data Sources

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.

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 Work Item ID
EHSTaskAdapterClass
EHSTaskDefinitionType
EHSTaskHostObjectInstance P_EHSTaskInstanceToDefinition EHSTaskHostObjectInstance Instance ID
EHSTaskOwnerUser
EHSWorkflowHeaderStatus
WorkflowTaskType I_WorkflowTask WorkflowTaskType Type
WorkflowTaskPriority I_WorkflowTask WorkflowTaskPriority Priority
WorkflowTaskStatus I_WorkflowTask WorkflowTaskStatus Status
WrkflwTskCreationUTCDateTime I_WorkflowTask WrkflwTskCreationUTCDateTime Created On
WrkflwTskCompletionUTCDateTime I_WorkflowTask WrkflwTskCompletionUTCDateTime Completed
WorkflowTaskCreatedByUser I_WorkflowTask WorkflowTaskCreatedByUser Creator
WorkflowTaskCurrentUser I_WorkflowTask WorkflowTaskCurrentUser Agent
WorkflowTaskDefinition I_WorkflowTask WorkflowTaskDefinition Task
WorkflowTaskDefinitionObjType I_WorkflowTask WorkflowTaskDefinitionObjType
WorkflowTaskDefinitionObject I_WorkflowTask WorkflowTaskDefinitionObject
TopLevelWorkflowTask I_WorkflowTask TopLevelWorkflowTask Top Level Workflow
_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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_EHSWorkflowStep.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_EHSWorkflowStep AS
SELECT
  _Step.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  _EHSTaskInstanceToDefinition._EHSTaskDefinition.EHSTaskHostObjectAdapterClass AS EHSTaskAdapterClass,
  _EHSTaskInstanceToDefinition._EHSTaskDefinition.EHSTaskWorkflowEvent AS EHSTaskDefinitionType,
  _EHSTaskInstanceToDefinition.EHSTaskHostObjectInstance AS EHSTaskHostObjectInstance,
  _EHSTaskInstanceToDefinition._WorkflowTask.WorkflowTaskCreatedByUser AS EHSTaskOwnerUser,
  _EHSTaskInstanceToDefinition._WorkflowTask.WorkflowTaskStatus AS EHSWorkflowHeaderStatus,
  _Step.WorkflowTaskType AS WorkflowTaskType,
  _Step.WorkflowTaskPriority AS WorkflowTaskPriority,
  _Step.WorkflowTaskStatus AS WorkflowTaskStatus,
  _Step.WrkflwTskCreationUTCDateTime AS WrkflwTskCreationUTCDateTime,
  _Step.WrkflwTskCompletionUTCDateTime AS WrkflwTskCompletionUTCDateTime,
  _Step.WorkflowTaskCreatedByUser AS WorkflowTaskCreatedByUser,
  _Step.WorkflowTaskCurrentUser AS WorkflowTaskCurrentUser,
  _Step.WorkflowTaskDefinition AS WorkflowTaskDefinition,
  _Step.WorkflowTaskDefinitionObjType AS WorkflowTaskDefinitionObjType,
  _Step.WorkflowTaskDefinitionObject AS WorkflowTaskDefinitionObject,
  _Step.TopLevelWorkflowTask AS TopLevelWorkflowTask,
  _Step._TaskTitle AS _TaskTitle,
  _Step._TaskType AS _TaskType,
  _Step._TaskPriority AS _TaskPriority,
  _Step._TaskStatus AS _TaskStatus,
  _Step._TaskApplicationObject AS _TaskApplicationObject,
  _Step._TaskApplicationLeadingObject AS _TaskApplicationLeadingObject,
  _Step._TaskStartEvent AS _TaskStartEvent,
  _Step._TaskDefinition AS _TaskDefinition
FROM I_WorkflowTask AS _Step
INNER JOIN P_EHSTaskInstanceToDefinition AS _EHSTaskInstanceToDefinition ON /* join condition not captured in parsed metadata */
;

Learn More