What is I_EHSTaskDefWithDraftUnion in SAP S/4HANA?

I_EHSTaskDefWithDraftUnion is a composite CDS view in SAP S/4HANA. EHSTask Definition Union It contains 146 fields.

Which tables does I_EHSTaskDefWithDraftUnion read from?

I_EHSTaskDefWithDraftUnion reads data from: I_EHSTaskDefinition, I_EHSTaskDefinitionDraft.

What VDM layer is I_EHSTaskDefWithDraftUnion?

I_EHSTaskDefWithDraftUnion is classified as a Composite view that combines data from multiple basic views.

I_EHSTaskDefWithDraftUnion

DDL: I_EHSTASKDEFWITHDRAFTUNION SQL: IEHSTSKDEFWDRFTU Type: view COMPOSITE Package: EHFND_BO_TASK_DEFINITION

146 Fields 2 Data Sources 1 Associations

EHSTask Definition Union

I_EHSTaskDefWithDraftUnion is a Composite CDS View that provides data about "EHSTask Definition Union" in SAP S/4HANA. It reads from 2 data sources (I_EHSTaskDefinition, I_EHSTaskDefinitionDraft) and exposes 146 fields with key field EHSTaskDefinitionUUID. It has 1 association to related views. Part of development package EHFND_BO_TASK_DEFINITION.

Data Sources (2)

Source	Alias	Join Type
I_EHSTaskDefinition	I_EHSTaskDefinition	from
I_EHSTaskDefinitionDraft	I_EHSTaskDefinitionDraft	union_all

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	I_EHSTaskDefinition	_TaskDefinition	`I_EHSTaskDefinitionDraft.EHSTaskDefinitionActiveUUID = _TaskDefinition.EHSTaskDefinitionUUID`

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	IEHSTSKDEFWDRFTU	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#MANDATORY	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	EHSTask Definition Union	view
ObjectModel.compositionRoot	true	view
ObjectModel.modelCategory	#BUSINESS_OBJECT	view
ObjectModel.representativeKey	EHSTaskDefinitionUUID	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.dataClass	#MIXED	view
Search.searchable	false	view
VDM.viewType	#COMPOSITE	view

Fields (146)

Key	Field	Source Table	Source Field	Description
KEY	EHSTaskDefinitionUUID	I_EHSTaskDefinition	EHSTaskDefinitionUUID	Task Definition
	IsDraftEntity
	HasActiveEntity			TRUE
	EHSTaskDefinitionActiveUUID	_EHSTaskDefinitionDraft	EHSTaskDefinitionActiveUUID	UUID
	EHSTaskHostObjectInstanceUUID	I_EHSTaskDefinition	EHSTaskHostObjectInstanceUUID	Host Obj. UUID
	EHSTaskHostObjectInstance	I_EHSTaskDefinition	EHSTaskHostObjectInstance	Instance ID
	EHSTaskHostObjectAdapterClass	I_EHSTaskDefinition	EHSTaskHostObjectAdapterClass	Class Name
	EHSTaskDefinitionType	I_EHSTaskDefinition	EHSTaskWorkflowEvent	Task Type
	EHSTaskPriority	I_EHSTaskDefinition	EHSTaskPriority	Priority
	EHSTaskAssignedUser	I_EHSTaskDefinition	EHSTaskAssignedUser	Assignee
	EHSTaskOwnerUser	I_EHSTaskDefinition	EHSTaskOwnerUser	Owner
	EHSTaskApprovingUser	I_EHSTaskDefinition	EHSTaskApprovingUser	Approver
	EHSTaskDefinitionStatus	I_EHSTaskDefinition	EHSTaskDefinitionStatus	Status
	EHSTaskTitle	I_EHSTaskDefinition	EHSTaskTitle	Title
	EHSTaskDescription	I_EHSTaskDefinition	EHSTaskDescription	Description
	EHSTaskStartDate	I_EHSTaskDefinition	EHSTaskStartDate	Start Date
	EHSTaskDueInValue	I_EHSTaskDefinition	EHSTaskDueInValue	Due In
	EHSTaskDueInUnit	I_EHSTaskDefinition	EHSTaskDueInUnit	Due In
	EHSTaskDueDate	I_EHSTaskDefinition	EHSTaskDueDate	Due Date
	EHSTaskRecurrenceType	I_EHSTaskDefinition	EHSTaskRecurrenceType	Recurrence Type
	EHSTaskIsDueOnSameDay	I_EHSTaskDefinition	EHSTaskIsDueOnSameDay	Due Same Day
	EHSTaskStartBeforeValue	I_EHSTaskDefinition	EHSTaskStartBeforeValue	Start Before
	EHSTaskStartBeforeUnit	I_EHSTaskDefinition	EHSTaskStartBeforeUnit	Start Before
	EHSTaskRecurrenceIsByDueDate	I_EHSTaskDefinition	EHSTaskRecurrenceIsByDueDate	Due Date Based
	EHSTaskRecurrenceOffset	I_EHSTaskDefinition	EHSTaskRecurrenceOffset	Recur. Offset
	EHSTaskIsRecurringOnMonday	I_EHSTaskDefinition	EHSTaskIsRecurringOnMonday	Monday
	EHSTaskIsRecurringOnTuesday	I_EHSTaskDefinition	EHSTaskIsRecurringOnTuesday	Tuesday
	EHSTaskIsRecurringOnWednesday	I_EHSTaskDefinition	EHSTaskIsRecurringOnWednesday	Wednesday
	EHSTaskIsRecurringOnThursday	I_EHSTaskDefinition	EHSTaskIsRecurringOnThursday	Thursday
	EHSTaskIsRecurringOnFriday	I_EHSTaskDefinition	EHSTaskIsRecurringOnFriday	Friday
	EHSTaskIsRecurringOnSaturday	I_EHSTaskDefinition	EHSTaskIsRecurringOnSaturday	Saturday
	EHSTaskIsRecurringOnSunday	I_EHSTaskDefinition	EHSTaskIsRecurringOnSunday	Sunday
	EHSTaskRecurrenceWeekDay	I_EHSTaskDefinition	EHSTaskRecurrenceWeekDay	Weekday
	EHSTaskRecurrenceInterval	I_EHSTaskDefinition	EHSTaskRecurrenceInterval	Recurrence
	EHSTaskRecurrenceEndType	I_EHSTaskDefinition	EHSTaskRecurrenceEndType	Recur. End Type
	EHSTaskRecurrenceEndDate	I_EHSTaskDefinition	EHSTaskRecurrenceEndDate	Recur. End Date
	EHSTaskRecurrenceFirstDueDate	I_EHSTaskDefinition	EHSTaskRecurrenceFirstDueDate	First Due Date
	EHSTaskRecurrenceDay	I_EHSTaskDefinition	EHSTaskRecurrenceDay	Day of Month
	EHSTaskRecurrenceMonth	I_EHSTaskDefinition	EHSTaskRecurrenceMonth	Month of Year
	EHSTaskOwnerBP	I_EHSTaskDefinition	EHSTaskOwnerUser	Owner
	EHSTaskApprovingBP	I_EHSTaskDefinition	EHSTaskApprovingUser	Approver
	EHSTaskAssignedBP	I_EHSTaskDefinition	EHSTaskAssignedUser	Assignee
	EHSTaskAssignedLocRole	I_EHSTaskDefinition	EHSTaskAssignedLocRole	Assignee Location Role
	EHSTaskApproverLocRole	I_EHSTaskDefinition	EHSTaskApproverLocRole	Approver Location Role
	EHSTaskDefinitionIsPaused	I_EHSTaskDefinition	EHSTaskDefinitionIsPaused	Is Paused
	EHSLocationUUID	I_EHSTaskDefinition	EHSLocationUUID	NodeID
	EHSTaskID	I_EHSTaskDefinition	EHSTaskID	ID
	EHSTaskMigrationSource	I_EHSTaskDefinition	EHSTaskMigrationSource	Migr. Source
	EHSTaskAssignedType	I_EHSTaskDefinition	EHSTaskAssignedType	Assignment Type of Assignee
	_CmplncRqmtAuthznFields	I_EHSTaskDefinition	_CmplncRqmtAuthznFields
	_EHSCmplncScenAuthznFields	I_EHSTaskDefinition	_EHSCmplncScenAuthznFields
	_EHSCtrlImplmtnAuthznFields	I_EHSTaskDefinition	_EHSCtrlImplmtnAuthznFields
	_EHSRskAssessmentAuthznFields	I_EHSTaskDefinition	_EHSRskAssessmentAuthznFields
	_EHSRskAssmt2RskCtrlAuthznFld	I_EHSTaskDefinition	_EHSRskAssmt2RskCtrlAuthznFld
	_EHSTaskAdapterClass	I_EHSTaskDefinition	_EHSTaskAdapterClass
	_EHSTaskApprovingUser	I_EHSTaskDefinition	_EHSTaskApprovingUser
	_EHSTaskAssignedUser	I_EHSTaskDefinition	_EHSTaskAssignedUser
	_EHSTaskDefinitionExecution	I_EHSTaskDefinition	_EHSTaskDefinitionExecution
	_EHSTaskDefinitionMaintenance	I_EHSTaskDefinition	_EHSTaskDefinitionMaintenance
	_EHSTaskDefinitionMoC	I_EHSTaskDefinition	_EHSTaskDefinitionMoC
	_EHSTaskDefinitionReference	I_EHSTaskDefinition	_EHSTaskDefinitionReference
	_EHSTaskDefinitionType	I_EHSTaskDefinition	_EHSTaskDefinitionType
	_EHSTaskDueInUnit	I_EHSTaskDefinition	_EHSTaskDueInUnit
	_EHSTaskOwnerUser	I_EHSTaskDefinition	_EHSTaskOwnerUser
	_EHSTaskPlannedInstance	I_EHSTaskDefinition	_EHSTaskPlannedInstance
	_EHSTaskPriority	I_EHSTaskDefinition	_EHSTaskPriority
	_EHSTaskStartBeforeUnit	I_EHSTaskDefinition	_EHSTaskStartBeforeUnit
	_IncidentAuthorizationFields	I_EHSTaskDefinition	_IncidentAuthorizationFields
	_IncidentTaskRefAccRestricted	I_EHSTaskDefinition	_IncidentTaskRefAccRestricted
	_EHSTaskRecurrenceType	I_EHSTaskDefinition	_EHSTaskRecurrenceType
	_EHSTaskRecurrenceOffset	I_EHSTaskDefinition	_EHSTaskRecurrenceOffset
	_EHSTaskRecurrenceWeekDay	I_EHSTaskDefinition	_EHSTaskRecurrenceWeekDay
	_EHSTaskRecurrenceMonth	I_EHSTaskDefinition	_EHSTaskRecurrenceMonth
	IsDraftEntity
	HasActiveEntity		HasActiveEntity	TRUE
	EHSTaskDefinitionActiveUUID		EHSTaskDefinitionActiveUUID	UUID
	EHSTaskHostObjectInstanceUUID		EHSTaskHostObjectInstanceUUID	Host Obj. UUID
	EHSTaskHostObjectInstance		EHSTaskHostObjectInstance	Instance ID
	EHSTaskHostObjectAdapterClass		EHSTaskHostObjectAdapterClass	Class Name
	EHSTaskDefinitionType		EHSTaskWorkflowEvent	Task Type
	EHSTaskPriority		EHSTaskPriority	Priority
	EHSTaskAssignedUser		EHSTaskAssignedUser	Assignee
	EHSTaskOwnerUser		EHSTaskOwnerUser	Owner
	EHSTaskApprovingUser		EHSTaskApprovingUser	Approver
	EHSTaskDefinitionStatus			Status
	EHSTaskTitle		EHSTaskTitle	Title
	EHSTaskDescription		EHSTaskDescription	Description
	EHSTaskStartDate		EHSTaskStartDate	Start Date
	EHSTaskDueInValue		EHSTaskDueInValue	Due In
	EHSTaskDueInUnit		EHSTaskDueInUnit	Due In
	EHSTaskDueDate		EHSTaskDueDate	Due Date
	EHSTaskRecurrenceType		EHSTaskRecurrenceType	Recurrence Type
	EHSTaskIsDueOnSameDay		EHSTaskIsDueOnSameDay	Due Same Day
	EHSTaskStartBeforeValue		EHSTaskStartBeforeValue	Start Before
	EHSTaskStartBeforeUnit		EHSTaskStartBeforeUnit	Start Before
	EHSTaskRecurrenceIsByDueDate		EHSTaskRecurrenceIsByDueDate	Due Date Based
	EHSTaskRecurrenceOffset		EHSTaskRecurrenceOffset	Recur. Offset
	EHSTaskIsRecurringOnMonday		EHSTaskIsRecurringOnMonday	Monday
	EHSTaskIsRecurringOnTuesday		EHSTaskIsRecurringOnTuesday	Tuesday
	EHSTaskIsRecurringOnWednesday		EHSTaskIsRecurringOnWednesday	Wednesday
	EHSTaskIsRecurringOnThursday		EHSTaskIsRecurringOnThursday	Thursday
	EHSTaskIsRecurringOnFriday		EHSTaskIsRecurringOnFriday	Friday
	EHSTaskIsRecurringOnSaturday		EHSTaskIsRecurringOnSaturday	Saturday
	EHSTaskIsRecurringOnSunday		EHSTaskIsRecurringOnSunday	Sunday
	EHSTaskRecurrenceWeekDay		EHSTaskRecurrenceWeekDay	Weekday
	EHSTaskRecurrenceInterval		EHSTaskRecurrenceInterval	Recurrence
	EHSTaskRecurrenceEndType		EHSTaskRecurrenceEndType	Recur. End Type
	EHSTaskRecurrenceEndDate		EHSTaskRecurrenceEndDate	Recur. End Date
	EHSTaskRecurrenceFirstDueDate		EHSTaskRecurrenceFirstDueDate	First Due Date
	EHSTaskRecurrenceDay		EHSTaskRecurrenceDay	Day of Month
	EHSTaskRecurrenceMonth		EHSTaskRecurrenceMonth	Month of Year
	EHSTaskOwnerBP		EHSTaskOwnerUser	Owner
	EHSTaskApprovingBP		EHSTaskApprovingUser	Approver
	EHSTaskAssignedBP		EHSTaskAssignedUser	Assignee
	EHSTaskAssignedLocRole		EHSTaskAssignedLocRole	Assignee Location Role
	EHSTaskApproverLocRole		EHSTaskApproverLocRole	Approver Location Role
	EHSTaskDefinitionIsPaused		EHSTaskDefinitionIsPaused	Is Paused
	EHSLocationUUID		EHSLocationUUID	NodeID
	EHSTaskID		EHSTaskID	ID
	EHSTaskMigrationSource		EHSTaskMigrationSource	Migr. Source
	EHSTaskAssignedType		EHSTaskAssignedType	Assignment Type of Assignee
	_CmplncRqmtAuthznFields		_CmplncRqmtAuthznFields
	_EHSCmplncScenAuthznFields		_EHSCmplncScenAuthznFields
	_EHSCtrlImplmtnAuthznFields		_EHSCtrlImplmtnAuthznFields
	_EHSRskAssessmentAuthznFields		_EHSRskAssessmentAuthznFields
	_EHSRskAssmt2RskCtrlAuthznFld		_EHSRskAssmt2RskCtrlAuthznFld
	_EHSTaskAdapterClass		_EHSTaskAdapterClass
	_EHSTaskApprovingUser		_EHSTaskApprovingUser
	_EHSTaskAssignedUser		_EHSTaskAssignedUser
	_EHSTaskDefinitionExecution		_EHSTaskDefinitionExecution
	_EHSTaskDefinitionMaintenance		_EHSTaskDefinitionMaintenance
	_EHSTaskDefinitionMoC		_EHSTaskDefinitionMoC
	_EHSTaskDefinitionReference		_EHSTaskDefinitionReference
	_EHSTaskDefinitionType		_EHSTaskDefinitionType
	_EHSTaskDueInUnit		_EHSTaskDueInUnit
	_EHSTaskOwnerUser		_EHSTaskOwnerUser
	_EHSTaskPlannedInstance		_EHSTaskPlannedInstance
	_EHSTaskPriority		_EHSTaskPriority
	_EHSTaskStartBeforeUnit		_EHSTaskStartBeforeUnit
	_IncidentAuthorizationFields		_IncidentAuthorizationFields
	_IncidentTaskRefAccRestricted		_IncidentTaskRefAccRestricted
	_EHSTaskRecurrenceType		_EHSTaskRecurrenceType
	_EHSTaskRecurrenceOffset		_EHSTaskRecurrenceOffset
	_EHSTaskRecurrenceWeekDay		_EHSTaskRecurrenceWeekDay
	_EHSTaskRecurrenceMonth		_EHSTaskRecurrenceMonth
	_EHSTaskRecurrenceEndType		_EHSTaskRecurrenceEndType

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_EHSTaskDefWithDraftUnion.
-- 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: IEHSTSKDEFWDRFTU

CREATE VIEW I_EHSTaskDefWithDraftUnion AS
SELECT
  I_EHSTaskDefinition.EHSTaskDefinitionUUID AS EHSTaskDefinitionUUID,
  cast('' as ehfnd_task_is_draft_entity) AS IsDraftEntity,
  '' AS HasActiveEntity,
  _EHSTaskDefinitionDraft.EHSTaskDefinitionActiveUUID AS EHSTaskDefinitionActiveUUID,
  I_EHSTaskDefinition.EHSTaskHostObjectInstanceUUID AS EHSTaskHostObjectInstanceUUID,
  I_EHSTaskDefinition.EHSTaskHostObjectInstance AS EHSTaskHostObjectInstance,
  I_EHSTaskDefinition.EHSTaskHostObjectAdapterClass AS EHSTaskHostObjectAdapterClass,
  I_EHSTaskDefinition.EHSTaskWorkflowEvent AS EHSTaskDefinitionType,
  I_EHSTaskDefinition.EHSTaskPriority AS EHSTaskPriority,
  I_EHSTaskDefinition.EHSTaskAssignedUser AS EHSTaskAssignedUser,
  I_EHSTaskDefinition.EHSTaskOwnerUser AS EHSTaskOwnerUser,
  I_EHSTaskDefinition.EHSTaskApprovingUser AS EHSTaskApprovingUser,
  I_EHSTaskDefinition.EHSTaskDefinitionStatus AS EHSTaskDefinitionStatus,
  I_EHSTaskDefinition.EHSTaskTitle AS EHSTaskTitle,
  I_EHSTaskDefinition.EHSTaskDescription AS EHSTaskDescription,
  I_EHSTaskDefinition.EHSTaskStartDate AS EHSTaskStartDate,
  I_EHSTaskDefinition.EHSTaskDueInValue AS EHSTaskDueInValue,
  I_EHSTaskDefinition.EHSTaskDueInUnit AS EHSTaskDueInUnit,
  I_EHSTaskDefinition.EHSTaskDueDate AS EHSTaskDueDate,
  I_EHSTaskDefinition.EHSTaskRecurrenceType AS EHSTaskRecurrenceType,
  I_EHSTaskDefinition.EHSTaskIsDueOnSameDay AS EHSTaskIsDueOnSameDay,
  I_EHSTaskDefinition.EHSTaskStartBeforeValue AS EHSTaskStartBeforeValue,
  I_EHSTaskDefinition.EHSTaskStartBeforeUnit AS EHSTaskStartBeforeUnit,
  I_EHSTaskDefinition.EHSTaskRecurrenceIsByDueDate AS EHSTaskRecurrenceIsByDueDate,
  I_EHSTaskDefinition.EHSTaskRecurrenceOffset AS EHSTaskRecurrenceOffset,
  I_EHSTaskDefinition.EHSTaskIsRecurringOnMonday AS EHSTaskIsRecurringOnMonday,
  I_EHSTaskDefinition.EHSTaskIsRecurringOnTuesday AS EHSTaskIsRecurringOnTuesday,
  I_EHSTaskDefinition.EHSTaskIsRecurringOnWednesday AS EHSTaskIsRecurringOnWednesday,
  I_EHSTaskDefinition.EHSTaskIsRecurringOnThursday AS EHSTaskIsRecurringOnThursday,
  I_EHSTaskDefinition.EHSTaskIsRecurringOnFriday AS EHSTaskIsRecurringOnFriday,
  I_EHSTaskDefinition.EHSTaskIsRecurringOnSaturday AS EHSTaskIsRecurringOnSaturday,
  I_EHSTaskDefinition.EHSTaskIsRecurringOnSunday AS EHSTaskIsRecurringOnSunday,
  I_EHSTaskDefinition.EHSTaskRecurrenceWeekDay AS EHSTaskRecurrenceWeekDay,
  I_EHSTaskDefinition.EHSTaskRecurrenceInterval AS EHSTaskRecurrenceInterval,
  I_EHSTaskDefinition.EHSTaskRecurrenceEndType AS EHSTaskRecurrenceEndType,
  I_EHSTaskDefinition.EHSTaskRecurrenceEndDate AS EHSTaskRecurrenceEndDate,
  I_EHSTaskDefinition.EHSTaskRecurrenceFirstDueDate AS EHSTaskRecurrenceFirstDueDate,
  I_EHSTaskDefinition.EHSTaskRecurrenceDay AS EHSTaskRecurrenceDay,
  I_EHSTaskDefinition.EHSTaskRecurrenceMonth AS EHSTaskRecurrenceMonth,
  I_EHSTaskDefinition.EHSTaskOwnerUser AS EHSTaskOwnerBP,
  I_EHSTaskDefinition.EHSTaskApprovingUser AS EHSTaskApprovingBP,
  I_EHSTaskDefinition.EHSTaskAssignedUser AS EHSTaskAssignedBP,
  I_EHSTaskDefinition.EHSTaskAssignedLocRole AS EHSTaskAssignedLocRole,
  I_EHSTaskDefinition.EHSTaskApproverLocRole AS EHSTaskApproverLocRole,
  I_EHSTaskDefinition.EHSTaskDefinitionIsPaused AS EHSTaskDefinitionIsPaused,
  I_EHSTaskDefinition.EHSLocationUUID AS EHSLocationUUID,
  I_EHSTaskDefinition.EHSTaskID AS EHSTaskID,
  I_EHSTaskDefinition.EHSTaskMigrationSource AS EHSTaskMigrationSource,
  I_EHSTaskDefinition.EHSTaskAssignedType AS EHSTaskAssignedType,
  I_EHSTaskDefinition._CmplncRqmtAuthznFields AS _CmplncRqmtAuthznFields,
  I_EHSTaskDefinition._EHSCmplncScenAuthznFields AS _EHSCmplncScenAuthznFields,
  I_EHSTaskDefinition._EHSCtrlImplmtnAuthznFields AS _EHSCtrlImplmtnAuthznFields,
  I_EHSTaskDefinition._EHSRskAssessmentAuthznFields AS _EHSRskAssessmentAuthznFields,
  I_EHSTaskDefinition._EHSRskAssmt2RskCtrlAuthznFld AS _EHSRskAssmt2RskCtrlAuthznFld,
  I_EHSTaskDefinition._EHSTaskAdapterClass AS _EHSTaskAdapterClass,
  I_EHSTaskDefinition._EHSTaskApprovingUser AS _EHSTaskApprovingUser,
  I_EHSTaskDefinition._EHSTaskAssignedUser AS _EHSTaskAssignedUser,
  I_EHSTaskDefinition._EHSTaskDefinitionExecution AS _EHSTaskDefinitionExecution,
  I_EHSTaskDefinition._EHSTaskDefinitionMaintenance AS _EHSTaskDefinitionMaintenance,
  I_EHSTaskDefinition._EHSTaskDefinitionMoC AS _EHSTaskDefinitionMoC,
  I_EHSTaskDefinition._EHSTaskDefinitionReference AS _EHSTaskDefinitionReference,
  I_EHSTaskDefinition._EHSTaskDefinitionType AS _EHSTaskDefinitionType,
  I_EHSTaskDefinition._EHSTaskDueInUnit AS _EHSTaskDueInUnit,
  I_EHSTaskDefinition._EHSTaskOwnerUser AS _EHSTaskOwnerUser,
  I_EHSTaskDefinition._EHSTaskPlannedInstance AS _EHSTaskPlannedInstance,
  I_EHSTaskDefinition._EHSTaskPriority AS _EHSTaskPriority,
  I_EHSTaskDefinition._EHSTaskStartBeforeUnit AS _EHSTaskStartBeforeUnit,
  I_EHSTaskDefinition._IncidentAuthorizationFields AS _IncidentAuthorizationFields,
  I_EHSTaskDefinition._IncidentTaskRefAccRestricted AS _IncidentTaskRefAccRestricted,
  I_EHSTaskDefinition._EHSTaskRecurrenceType AS _EHSTaskRecurrenceType,
  I_EHSTaskDefinition._EHSTaskRecurrenceOffset AS _EHSTaskRecurrenceOffset,
  I_EHSTaskDefinition._EHSTaskRecurrenceWeekDay AS _EHSTaskRecurrenceWeekDay,
  I_EHSTaskDefinition._EHSTaskRecurrenceMonth AS _EHSTaskRecurrenceMonth
FROM I_EHSTaskDefinition
LEFT OUTER JOIN I_EHSTaskDefinition AS _TaskDefinition ON I_EHSTaskDefinitionDraft.EHSTaskDefinitionActiveUUID = _TaskDefinition.EHSTaskDefinitionUUID  -- association [0..1]
-- UNION ALL with additional select branch(es): I_EHSTaskDefinitionDraft
;

Depth:

I_EHSTaskDefWithDraftUnion view

I_EHSTaskDefinition view
I_EHSTaskDefinitionDraft view

C_EHSTaskDefinitionWithDraft view