I_EHSRiskControlTaskDefAndInst

DDL: I_EHSRISKCONTROLTASKDEFANDINST Type: view_entity COMPOSITE
41 Fields 2 Data Sources 2 Associations

Tasks at Controls

I_EHSRiskControlTaskDefAndInst is a Composite CDS View that provides data about "Tasks at Controls" in SAP S/4HANA. It reads from 2 data sources (I_EHSTaskPlannedInstance, R_EHSTaskDefinitionDraft) and exposes 41 fields with key fields EHSTaskDefinitionUUID, WorkflowTaskInternalID, EHSPlannedTaskUUID, WorkflowTaskInternalID, EHSPlannedTaskUUID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_EHSTaskPlannedInstance PlannedInstance from
R_EHSTaskDefinitionDraft R_EHSTaskDefinitionDraft union_all

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_EHSTaskDefinitionTypeText _EHSTaskDefinitionTypeText $projection.EHSTaskDefinitionType = _EHSTaskDefinitionTypeText.EHSTaskDefinitionType
[0..1] R_EHSTaskDefinitionDraft _EHSTaskDefinitionDraft $projection.EHSTaskDefinitionUUID = _EHSTaskDefinitionDraft.EHSTaskDefinitionActiveUUID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Tasks at Controls view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY EHSTaskDefinitionUUID I_EHSTaskPlannedInstance EHSTaskDefinitionUUID Task Definition
KEY WorkflowTaskInternalID WorkflowTask WorkflowTaskInternalID Work Item ID
KEY EHSPlannedTaskUUID I_EHSTaskPlannedInstance EHSPlannedTaskUUID Planned Task
EHSTaskHostObjectInstance Instance ID
EHSTaskHostObjectInstanceUUID Host Obj. UUID
EHSTaskHostObjectAdapterClass Class Name
EHSPlannedTaskID I_EHSTaskPlannedInstance EHSPlannedTaskID ID
EHSTaskTitle Title
EHSTaskDefinitionType Task Type
EHSTaskDefinitionIsPaused Is Paused
EHSTaskDefinitionStatus Status
EHSTaskDueDate I_EHSTaskPlannedInstance EHSTaskDueDate Due Date
EHSTaskStartDate I_EHSTaskPlannedInstance EHSTaskStartDate Start Date
EHSTaskInstceCompletionDate I_EHSTaskPlannedInstance EHSTaskInstceCompletionDate Completion Date
EHSTaskTimeZone I_EHSTaskPlannedInstance EHSTaskTimeZone Time Zone
WorkflowTaskStatus WorkflowTask WorkflowTaskStatus
IsDraftEntity
CreatedByUser _EHSTaskDefinitionDraft CreatedByUser User Name
HasActiveEntity _EHSTaskDefinitionDraft HasActiveEntity TRUE
DraftUUID _EHSTaskDefinitionDraft EHSTaskDefinitionUUID Task Definition
KEY WorkflowTaskInternalID Work Item ID
KEY EHSPlannedTaskUUID Planned Task
EHSTaskHostObjectInstance EHSTaskHostObjectInstance Instance ID
EHSTaskHostObjectInstanceUUID EHSTaskHostObjectInstanceUUID Host Obj. UUID
EHSTaskHostObjectAdapterClass EHSTaskHostObjectAdapterClass Class Name
EHSPlannedTaskID ID
EHSTaskTitle EHSTaskTitle Title
EHSTaskDefinitionType EHSTaskWorkflowEvent Task Type
EHSTaskDefinitionIsPaused EHSTaskDefinitionIsPaused Is Paused
EHSTaskDefinitionStatus EHSTaskDefinitionStatus Status
EHSTaskDueDate EHSTaskDueDate Due Date
EHSTaskStartDate EHSTaskStartDate Start Date
EHSTaskInstceCompletionDate Completion Date
EHSTaskTimeZone Time Zone
WorkflowTaskStatus
IsDraftEntity
CreatedByUser CreatedByUser User Name
HasActiveEntity HasActiveEntity TRUE
EHSTaskHasWorkflow
DraftUUID EHSTaskDefinitionUUID Task Definition
_EHSTaskDefinitionTypeText _EHSTaskDefinitionTypeText

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_EHSRiskControlTaskDefAndInst.
-- 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 I_EHSRiskControlTaskDefAndInst AS
SELECT
  PlannedInstance.EHSTaskDefinitionUUID AS EHSTaskDefinitionUUID,
  WorkflowTask.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  PlannedInstance.EHSPlannedTaskUUID AS EHSPlannedTaskUUID,
  PlannedInstance._EHSTaskDefinition.EHSTaskHostObjectInstance AS EHSTaskHostObjectInstance,
  PlannedInstance._EHSTaskDefinition.EHSTaskHostObjectInstanceUUID AS EHSTaskHostObjectInstanceUUID,
  PlannedInstance._EHSTaskDefinition.EHSTaskHostObjectAdapterClass AS EHSTaskHostObjectAdapterClass,
  PlannedInstance.EHSPlannedTaskID AS EHSPlannedTaskID,
  PlannedInstance._EHSTaskDefinition.EHSTaskTitle AS EHSTaskTitle,
  PlannedInstance._EHSTaskDefinition.EHSTaskWorkflowEvent AS EHSTaskDefinitionType,
  PlannedInstance._EHSTaskDefinition.EHSTaskDefinitionIsPaused AS EHSTaskDefinitionIsPaused,
  PlannedInstance._EHSTaskDefinition.EHSTaskDefinitionStatus AS EHSTaskDefinitionStatus,
  PlannedInstance.EHSTaskDueDate AS EHSTaskDueDate,
  PlannedInstance.EHSTaskStartDate AS EHSTaskStartDate,
  PlannedInstance.EHSTaskInstceCompletionDate AS EHSTaskInstceCompletionDate,
  PlannedInstance.EHSTaskTimeZone AS EHSTaskTimeZone,
  WorkflowTask.WorkflowTaskStatus AS WorkflowTaskStatus,
  cast('' as boolean) AS IsDraftEntity,
  _EHSTaskDefinitionDraft.CreatedByUser AS CreatedByUser,
  _EHSTaskDefinitionDraft.HasActiveEntity AS HasActiveEntity,
  _EHSTaskDefinitionDraft.EHSTaskDefinitionUUID AS DraftUUID,
  '' AS EHSTaskHasWorkflow
FROM I_EHSTaskPlannedInstance AS PlannedInstance
LEFT OUTER JOIN I_EHSTaskDefinitionTypeText AS _EHSTaskDefinitionTypeText ON EHSTaskDefinitionType = _EHSTaskDefinitionTypeText.EHSTaskDefinitionType  -- association [0..*]
LEFT OUTER JOIN R_EHSTaskDefinitionDraft AS _EHSTaskDefinitionDraft ON EHSTaskDefinitionUUID = _EHSTaskDefinitionDraft.EHSTaskDefinitionActiveUUID  -- association [0..1]
-- UNION ALL with additional select branch(es): R_EHSTaskDefinitionDraft
;

Learn More