I_EHSTaskPlannedWorkflowHead

DDL: I_EHSTASKPLANNEDWORKFLOWHEAD SQL: IEHSTASKPLWFH Type: view BASIC
18 Fields 2 Data Sources

EHS Task Planned Workflow Header

I_EHSTaskPlannedWorkflowHead is a Basic CDS View that provides data about "EHS Task Planned Workflow Header" in SAP S/4HANA. It reads from 2 data sources (I_EHSTaskPlannedInstance, P_EHSWorkflowTask) and exposes 18 fields with key field EHSPlannedTaskUUID.

Data Sources (2)

SourceAliasJoin Type
I_EHSTaskPlannedInstance EHSTaskPlannedInstance from
P_EHSWorkflowTask WorkflowTask inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IEHSTASKPLWFH view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label EHS Task Planned Workflow Header view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY EHSPlannedTaskUUID I_EHSTaskPlannedInstance EHSPlannedTaskUUID Planned Task
EHSTaskDefinitionUUID I_EHSTaskPlannedInstance EHSTaskDefinitionUUID Task Definition
WorkflowTaskInternalID I_EHSTaskPlannedInstance WorkflowTaskInternalID Work Item ID
EHSTaskStartDate I_EHSTaskPlannedInstance EHSTaskStartDate Start Date
EHSTaskDueDate I_EHSTaskPlannedInstance EHSTaskDueDate Due Date
EHSTaskInstceCompletionDate I_EHSTaskPlannedInstance EHSTaskInstceCompletionDate Completion Date
EHSTaskTimeZone I_EHSTaskPlannedInstance EHSTaskTimeZone Time Zone
EHSTaskAssignedBP I_EHSTaskPlannedInstance EHSTaskAssignedBP Assignee
EHSTaskApprovingBP I_EHSTaskPlannedInstance EHSTaskApprovingBP Approver
EHSTaskOwnerBP I_EHSTaskPlannedInstance EHSTaskOwnerBP Owner
WorkflowTaskStatus P_EHSWorkflowTask WorkflowTaskStatus Status
WorkflowTaskDefinition P_EHSWorkflowTask WorkflowTaskDefinition Task
WorkflowTaskPriority P_EHSWorkflowTask WorkflowTaskPriority Priority
WrkflwTskCreationUTCDateTime P_EHSWorkflowTask WrkflwTskCreationUTCDateTime Created On
WrkflwTskCompletionUTCDateTime P_EHSWorkflowTask WrkflwTskCompletionUTCDateTime Completed
TopLevelWorkflowTask P_EHSWorkflowTask TopLevelWorkflowTask Top Level Workflow
WorkflowTaskCreatedByUser P_EHSWorkflowTask WorkflowTaskCreatedByUser Creator
WorkflowTaskName P_EHSWorkflowTask WorkflowTaskName Work item text

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 I_EHSTaskPlannedWorkflowHead.
-- 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.
-- SQL view name: IEHSTASKPLWFH

CREATE VIEW I_EHSTaskPlannedWorkflowHead AS
SELECT
  EHSTaskPlannedInstance.EHSPlannedTaskUUID AS EHSPlannedTaskUUID,
  EHSTaskPlannedInstance.EHSTaskDefinitionUUID AS EHSTaskDefinitionUUID,
  EHSTaskPlannedInstance.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  EHSTaskPlannedInstance.EHSTaskStartDate AS EHSTaskStartDate,
  EHSTaskPlannedInstance.EHSTaskDueDate AS EHSTaskDueDate,
  EHSTaskPlannedInstance.EHSTaskInstceCompletionDate AS EHSTaskInstceCompletionDate,
  EHSTaskPlannedInstance.EHSTaskTimeZone AS EHSTaskTimeZone,
  EHSTaskPlannedInstance.EHSTaskAssignedBP AS EHSTaskAssignedBP,
  EHSTaskPlannedInstance.EHSTaskApprovingBP AS EHSTaskApprovingBP,
  EHSTaskPlannedInstance.EHSTaskOwnerBP AS EHSTaskOwnerBP,
  WorkflowTask.WorkflowTaskStatus AS WorkflowTaskStatus,
  WorkflowTask.WorkflowTaskDefinition AS WorkflowTaskDefinition,
  WorkflowTask.WorkflowTaskPriority AS WorkflowTaskPriority,
  WorkflowTask.WrkflwTskCreationUTCDateTime AS WrkflwTskCreationUTCDateTime,
  WorkflowTask.WrkflwTskCompletionUTCDateTime AS WrkflwTskCompletionUTCDateTime,
  WorkflowTask.TopLevelWorkflowTask AS TopLevelWorkflowTask,
  WorkflowTask.WorkflowTaskCreatedByUser AS WorkflowTaskCreatedByUser,
  WorkflowTask.WorkflowTaskName AS WorkflowTaskName
FROM I_EHSTaskPlannedInstance AS EHSTaskPlannedInstance
INNER JOIN P_EHSWorkflowTask AS WorkflowTask ON /* join condition not captured in parsed metadata */
;

Learn More