I_EHSTaskDefinition

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_EHSTaskDefinition.
-- 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: IEHSTASKDEFROOT

CREATE VIEW I_EHSTaskDefinition AS
SELECT
  EHSTaskDefinitionRoot.ehstaskdefinitionuuid AS EHSTaskDefinitionUUID,
  EHSTaskDefinitionRoot.creationutcdatetime AS CreationUTCDateTime,
  EHSTaskDefinitionRoot.createdbyuser AS CreatedByUser,
  EHSTaskDefinitionRoot.lastchangeutcdatetime AS LastChangeUTCDateTime,
  EHSTaskDefinitionRoot.lastchangedbyuser AS LastChangedByUser,
  EHSTaskDefinitionRoot.ehstaskhostobjectinstanceuuid AS EHSTaskHostObjectInstanceUUID,
  EHSTaskDefinitionRoot.ehstaskhostobjectinstance AS EHSTaskHostObjectInstance,
  EHSTaskDefinitionRoot.ehstaskhostobjectadapterclass AS EHSTaskHostObjectAdapterClass,
  EHSTaskDefinitionRoot.ehstaskworkflowevent AS EHSTaskWorkflowEvent,
  EHSTaskDefinitionRoot.ehstaskpriority AS EHSTaskPriority,
  EHSTaskDefinitionRoot.ehstaskassigneduser AS EHSTaskAssignedUser,
  EHSTaskDefinitionRoot.ehstaskowneruser AS EHSTaskOwnerUser,
  EHSTaskDefinitionRoot.ehstaskapprovinguser AS EHSTaskApprovingUser,
  EHSTaskDefinitionRoot.ehstaskdefinitionstatus AS EHSTaskDefinitionStatus,
  EHSTaskDefinitionRoot.ehstasktitle AS EHSTaskTitle,
  EHSTaskDefinitionRoot.ehstaskdescription AS EHSTaskDescription,
  EHSTaskDefinitionRoot.ehstaskstartdate AS EHSTaskStartDate,
  EHSTaskDefinitionRoot.ehstaskdueinvalue AS EHSTaskDueInValue,
  EHSTaskDefinitionRoot.ehstaskdueinunit AS EHSTaskDueInUnit,
  EHSTaskDefinitionRoot.ehstaskduedate AS EHSTaskDueDate,
  EHSTaskDefinitionRoot.ehstaskisdueonsameday AS EHSTaskIsDueOnSameDay,
  EHSTaskDefinitionRoot.ehstaskstartbeforevalue AS EHSTaskStartBeforeValue,
  EHSTaskDefinitionRoot.ehstaskstartbeforeunit AS EHSTaskStartBeforeUnit,
  EHSTaskDefinitionRoot.ehstaskrecurrenceisbyduedate AS EHSTaskRecurrenceIsByDueDate,
  EHSTaskDefinitionRoot.ehstaskrecurrencetype AS EHSTaskRecurrenceType,
  EHSTaskDefinitionRoot.ehstaskrecurrenceinterval AS EHSTaskRecurrenceInterval,
  EHSTaskDefinitionRoot.ehstaskisrecurringonmonday AS EHSTaskIsRecurringOnMonday,
  EHSTaskDefinitionRoot.ehstaskisrecurringontuesday AS EHSTaskIsRecurringOnTuesday,
  EHSTaskDefinitionRoot.ehstaskisrecurringonwednesday AS EHSTaskIsRecurringOnWednesday,
  EHSTaskDefinitionRoot.ehstaskisrecurringonthursday AS EHSTaskIsRecurringOnThursday,
  EHSTaskDefinitionRoot.ehstaskisrecurringonfriday AS EHSTaskIsRecurringOnFriday,
  EHSTaskDefinitionRoot.ehstaskisrecurringonsaturday AS EHSTaskIsRecurringOnSaturday,
  EHSTaskDefinitionRoot.ehstaskisrecurringonsunday AS EHSTaskIsRecurringOnSunday,
  EHSTaskDefinitionRoot.ehstaskrecurrenceday AS EHSTaskRecurrenceDay,
  EHSTaskDefinitionRoot.ehstaskrecurrencemonth AS EHSTaskRecurrenceMonth,
  EHSTaskDefinitionRoot.ehstaskrecurrenceoffset AS EHSTaskRecurrenceOffset,
  EHSTaskDefinitionRoot.ehstaskrecurrenceweekday AS EHSTaskRecurrenceWeekDay,
  EHSTaskDefinitionRoot.ehstaskrecurrenceendtype AS EHSTaskRecurrenceEndType,
  EHSTaskDefinitionRoot.ehstaskrecurrenceenddate AS EHSTaskRecurrenceEndDate,
  EHSTaskDefinitionRoot.ehstaskrecurrencefirstduedate AS EHSTaskRecurrenceFirstDueDate,
  EHSTaskDefinitionRoot.ehstaskdefinitionispaused AS EHSTaskDefinitionIsPaused,
  EHSTaskDefinitionRoot.ehslocationuuid AS EHSLocationUUID,
  EHSTaskDefinitionRoot.ehstaskid AS EHSTaskID,
  EHSTaskDefinitionRoot.ehstaskmigrationsource AS EHSTaskMigrationSource,
  EHSTaskDefinitionRoot.ehstaskassignedtype AS EHSTaskAssignedType,
  EHSTaskDefinitionRoot.ehstaskassignedlocrole AS EHSTaskAssignedLocRole,
  EHSTaskDefinitionRoot.ehstaskapprovertype AS EHSTaskApproverType,
  EHSTaskDefinitionRoot.ehstaskapproverlocrole AS EHSTaskApproverLocRole
FROM ehfndd_tdef_root AS EHSTaskDefinitionRoot
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_BusinessUserBasic AS _EHSTaskOwnerUser ON EHSTaskOwnerUser = _EHSTaskOwnerUser.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessUserBasic AS _EHSTaskAssignedUser ON EHSTaskAssignedUser = _EHSTaskAssignedUser.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessUserBasic AS _EHSTaskApprovingUser ON EHSTaskApprovingUser = _EHSTaskApprovingUser.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_EHSTaskDefExecution AS _EHSTaskDefinitionExecution ON EHSTaskDefinitionUUID = _EHSTaskDefinitionExecution.EHSTaskDefinitionUUID  -- association [0..1]
LEFT OUTER JOIN I_EHSTaskDefReference AS _EHSTaskDefinitionReference ON EHSTaskDefinitionUUID = _EHSTaskDefinitionReference.EHSTaskDefinitionUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSTaskDefMaintenanceNotif AS _EHSTaskDefinitionMaintenance ON EHSTaskDefinitionUUID = _EHSTaskDefinitionMaintenance.EHSTaskDefinitionUUID  -- association [0..1]
LEFT OUTER JOIN I_EHSTaskDefMgmtOfChange AS _EHSTaskDefinitionMoC ON EHSTaskDefinitionUUID = _EHSTaskDefinitionMoC.EHSTaskDefinitionUUID  -- association [0..1]
LEFT OUTER JOIN I_EHSTaskPlannedInstance AS _EHSTaskPlannedInstance ON EHSTaskDefinitionUUID = _EHSTaskPlannedInstance.EHSTaskDefinitionUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSTaskPriority AS _EHSTaskPriority ON EHSTaskPriority = _EHSTaskPriority.EHSTaskPriority  -- association [0..1]
LEFT OUTER JOIN I_EHSTaskDefinitionStatus AS _EHSTaskDefinitionStatus ON EHSTaskDefinitionStatus = _EHSTaskDefinitionStatus.EHSTaskDefinitionStatus  -- association [0..1]
LEFT OUTER JOIN I_EHSTaskDueInUnit AS _EHSTaskDueInUnit ON EHSTaskDueInUnit = _EHSTaskDueInUnit.EHSTaskDueInUnit  -- association [0..1]
LEFT OUTER JOIN I_EHSTaskStartBeforeUnit AS _EHSTaskStartBeforeUnit ON EHSTaskStartBeforeUnit = _EHSTaskStartBeforeUnit.EHSTaskStartBeforeUnit  -- association [0..1]
LEFT OUTER JOIN I_EHSTaskRecurrenceType AS _EHSTaskRecurrenceType ON EHSTaskRecurrenceType = _EHSTaskRecurrenceType.EHSTaskRecurrenceType  -- association [0..1]
LEFT OUTER JOIN I_EHSTaskRecurrenceOffset AS _EHSTaskRecurrenceOffset ON EHSTaskRecurrenceOffset = _EHSTaskRecurrenceOffset.EHSTaskRecurrenceOffset  -- association [0..1]
LEFT OUTER JOIN I_EHSTaskRecurrenceWeekDay AS _EHSTaskRecurrenceWeekDay ON EHSTaskRecurrenceWeekDay = _EHSTaskRecurrenceWeekDay.EHSTaskRecurrenceWeekDay  -- association [0..1]
LEFT OUTER JOIN I_EHSTaskRecurrenceMonth AS _EHSTaskRecurrenceMonth ON EHSTaskRecurrenceMonth = _EHSTaskRecurrenceMonth.EHSTaskRecurrenceMonth  -- association [0..1]
LEFT OUTER JOIN I_EHSTaskRecurrenceEndType AS _EHSTaskRecurrenceEndType ON EHSTaskRecurrenceEndType = _EHSTaskRecurrenceEndType.EHSTaskRecurrenceEndType  -- association [0..1]
LEFT OUTER JOIN I_EHSTaskDefinitionType AS _EHSTaskDefinitionType ON EHSTaskHostObjectAdapterClass = _EHSTaskDefinitionType.EHSTaskAdapterClass AND EHSTaskWorkflowEvent = _EHSTaskDefinitionType.EHSTaskDefinitionType  -- association [1..1]
LEFT OUTER JOIN I_EHSTaskAdapterClass AS _EHSTaskAdapterClass ON EHSTaskHostObjectAdapterClass = _EHSTaskAdapterClass.EHSTaskAdapterClass  -- association [1..1]
LEFT OUTER JOIN I_IncidentCombAuthFields AS _IncidentAuthorizationFields ON EHSTaskHostObjectInstanceUUID = _IncidentAuthorizationFields.EHSTaskHostObjectInstanceUUID  -- association [0..1]
LEFT OUTER JOIN I_IncidentTaskRefAccRestricted AS _IncidentTaskRefAccRestricted ON EHSTaskDefinitionUUID = _IncidentTaskRefAccRestricted.EHSTaskDefinitionUUID AND EHSTaskHostObjectInstanceUUID = _IncidentTaskRefAccRestricted.IncidentUUID  -- association [0..1]
LEFT OUTER JOIN I_IncidentInvstgnAuthznFields AS _IncidentInvstgnAuthznFields ON EHSTaskHostObjectInstanceUUID = _IncidentInvstgnAuthznFields.EHSTaskHostObjectInstanceUUID  -- association [0..1]
LEFT OUTER JOIN I_EHSCtrlImplmtnAuthznFields AS _EHSCtrlImplmtnAuthznFields ON EHSTaskHostObjectInstanceUUID = _EHSCtrlImplmtnAuthznFields.EHSControlInstanceUUID  -- association [0..1]
LEFT OUTER JOIN I_EHSRskAssessmentAuthznFields AS _EHSRskAssessmentAuthznFields ON EHSTaskHostObjectInstanceUUID = _EHSRskAssessmentAuthznFields.EHSRiskAssessmentUUID  -- association [0..1]
LEFT OUTER JOIN I_EHSCmplncScenAuthznFields AS _EHSCmplncScenAuthznFields ON EHSTaskHostObjectInstanceUUID = _EHSCmplncScenAuthznFields.EHSCmplncScenOrignRootUUID  -- association [0..1]
LEFT OUTER JOIN I_CmplncRqmtAuthznFields AS _CmplncRqmtAuthznFields ON EHSTaskHostObjectInstanceUUID = _CmplncRqmtAuthznFields.CmplRqUUID  -- association [0..1]
;