I_EHSTaskDefinitionDraft

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_EHSTaskDefinitionDraft.
-- 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: IEHSTSKDEFRTDRFT

CREATE VIEW I_EHSTaskDefinitionDraft AS
SELECT
  EHSTaskDefinitionRootDraft.ehstaskdefinitionuuid AS EHSTaskDefinitionUUID,
  cast( EHSTaskDefinitionRootDraft.creationutcdatetime as ehfnd_bo_crea_date_time preserving type ) AS CreationUTCDateTime,
  cast( EHSTaskDefinitionRootDraft.createdbyuser as ehfnd_bo_crea_uname preserving type ) AS CreatedByUser,
  cast( EHSTaskDefinitionRootDraft.lastchangeutcdatetime as ehfnd_bo_lchg_date_time preserving type ) AS LastChangeUTCDateTime,
  cast( EHSTaskDefinitionRootDraft.lastchangedbyuser as ehfnd_bo_lchg_uname preserving type ) AS LastChangedByUser,
  EHSTaskDefinitionRootDraft.ehstaskhostobjectinstanceuuid AS EHSTaskHostObjectInstanceUUID,
  EHSTaskDefinitionRootDraft.ehstaskhostobjectinstance AS EHSTaskHostObjectInstance,
  EHSTaskDefinitionRootDraft.ehstaskhostobjectadapterclass AS EHSTaskHostObjectAdapterClass,
  EHSTaskDefinitionRootDraft.ehstaskworkflowevent AS EHSTaskWorkflowEvent,
  EHSTaskDefinitionRootDraft.ehstaskpriority AS EHSTaskPriority,
  EHSTaskDefinitionRootDraft.ehstaskassigneduser AS EHSTaskAssignedUser,
  EHSTaskDefinitionRootDraft.ehstaskowneruser AS EHSTaskOwnerUser,
  EHSTaskDefinitionRootDraft.ehstaskapprovinguser AS EHSTaskApprovingUser,
  EHSTaskDefinitionRootDraft.ehstaskdefinitionstatus AS EHSTaskDefinitionStatus,
  EHSTaskDefinitionRootDraft.ehstasktitle AS EHSTaskTitle,
  EHSTaskDefinitionRootDraft.ehstaskdescription AS EHSTaskDescription,
  EHSTaskDefinitionRootDraft.ehstaskstartdate AS EHSTaskStartDate,
  EHSTaskDefinitionRootDraft.ehstaskdueinvalue AS EHSTaskDueInValue,
  EHSTaskDefinitionRootDraft.ehstaskdueinunit AS EHSTaskDueInUnit,
  EHSTaskDefinitionRootDraft.ehstaskduedate AS EHSTaskDueDate,
  EHSTaskDefinitionRootDraft.ehstaskisdueonsameday AS EHSTaskIsDueOnSameDay,
  EHSTaskDefinitionRootDraft.ehstaskstartbeforevalue AS EHSTaskStartBeforeValue,
  EHSTaskDefinitionRootDraft.ehstaskstartbeforeunit AS EHSTaskStartBeforeUnit,
  EHSTaskDefinitionRootDraft.ehstaskrecurrenceisbyduedate AS EHSTaskRecurrenceIsByDueDate,
  EHSTaskDefinitionRootDraft.ehstaskrecurrencetype AS EHSTaskRecurrenceType,
  EHSTaskDefinitionRootDraft.ehstaskrecurrenceinterval AS EHSTaskRecurrenceInterval,
  EHSTaskDefinitionRootDraft.ehstaskisrecurringonmonday AS EHSTaskIsRecurringOnMonday,
  EHSTaskDefinitionRootDraft.ehstaskisrecurringontuesday AS EHSTaskIsRecurringOnTuesday,
  EHSTaskDefinitionRootDraft.ehstaskisrecurringonwednesday AS EHSTaskIsRecurringOnWednesday,
  EHSTaskDefinitionRootDraft.ehstaskisrecurringonthursday AS EHSTaskIsRecurringOnThursday,
  EHSTaskDefinitionRootDraft.ehstaskisrecurringonfriday AS EHSTaskIsRecurringOnFriday,
  EHSTaskDefinitionRootDraft.ehstaskisrecurringonsaturday AS EHSTaskIsRecurringOnSaturday,
  EHSTaskDefinitionRootDraft.ehstaskisrecurringonsunday AS EHSTaskIsRecurringOnSunday,
  EHSTaskDefinitionRootDraft.ehstaskrecurrenceday AS EHSTaskRecurrenceDay,
  EHSTaskDefinitionRootDraft.ehstaskrecurrencemonth AS EHSTaskRecurrenceMonth,
  EHSTaskDefinitionRootDraft.ehstaskrecurrenceoffset AS EHSTaskRecurrenceOffset,
  EHSTaskDefinitionRootDraft.ehstaskrecurrenceweekday AS EHSTaskRecurrenceWeekDay,
  EHSTaskDefinitionRootDraft.ehstaskrecurrenceendtype AS EHSTaskRecurrenceEndType,
  EHSTaskDefinitionRootDraft.ehstaskrecurrenceenddate AS EHSTaskRecurrenceEndDate,
  EHSTaskDefinitionRootDraft.ehstaskrecurrencefirstduedate AS EHSTaskRecurrenceFirstDueDate,
  EHSTaskDefinitionRootDraft.ehstaskdefinitionispaused AS EHSTaskDefinitionIsPaused,
  EHSTaskDefinitionRootDraft.ehslocationuuid AS EHSLocationUUID,
  EHSTaskDefinitionRootDraft.ehstaskid AS EHSTaskID,
  EHSTaskDefinitionRootDraft.ehstaskmigrationsource AS EHSTaskMigrationSource,
  EHSTaskDefinitionRootDraft.ehstaskassignedtype AS EHSTaskAssignedType,
  EHSTaskDefinitionRootDraft.ehstaskassignedlocrole AS EHSTaskAssignedLocRole,
  EHSTaskDefinitionRootDraft.ehstaskapprovertype AS EHSTaskApproverType,
  EHSTaskDefinitionRootDraft.ehstaskapproverlocrole AS EHSTaskApproverLocRole,
  EHSTaskDefinitionRootDraft.activeuuid AS EHSTaskDefinitionActiveUUID,
  EHSTaskDefinitionRootDraft.hasactiveentity AS HasActiveEntity,
  _DraftAdministrativeData.LastChangeDateTime AS DraftEntityLastChangeDateTime,
  _DraftAdministrativeData.DraftIsLastChangedByMe AS DraftIsLastChangedByMe,
  _DraftAdministrativeData.LastChangedByUserDescription AS LastChangedByUserDescription,
  _DraftAdministrativeData.DraftIsProcessedByMe AS DraftIsProcessedByMe,
  _DraftAdministrativeData.InProcessByUser AS InProcessByUser,
  _DraftAdministrativeData.InProcessByUserDescription AS InProcessByUserDescription,
  cast ( '' as bu_partner ) AS EHSTaskUser,
  _EHSTaskAdapterClass.EHSSemanticObject AS EHSTaskHostSemanticObject,
  _IncidentTaskRefAccRestricted.IncidentHasAccessRestriction AS IncidentHasAccessRestriction
FROM ehfndw_tdef_root AS EHSTaskDefinitionRootDraft
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_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_EHSRskAssmt2RskCtrlAuthznFld AS _EHSRskAssmt2RskCtrlAuthznFld ON EHSTaskHostObjectInstanceUUID = _EHSRskAssmt2RskCtrlAuthznFld.EHSRiskControlUUID  -- 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]
LEFT OUTER JOIN I_DraftAdministrativeData AS _DraftAdministrativeData ON EHSTaskDefinitionUUID = _DraftAdministrativeData.DraftUUID AND _DraftAdministrativeData.DraftEntityType = 'I_EHSTASKDEFINITIONTP'  -- association [0..1]
LEFT OUTER JOIN I_BusinessUserBasic AS _BusinessPartner ON EHSTaskUser = _BusinessPartner.UserID  -- association [0..1]
LEFT OUTER JOIN I_EHSLocationPersonRespRoleT AS _EHSTaskAssigneeRoleT ON EHSTaskAssignedLocRole = _EHSTaskAssigneeRoleT.EHSLocationPersonRespRole  -- association [0..*]
LEFT OUTER JOIN I_EHSLocationPersonRespRoleT AS _EHSTaskApproverRoleT ON EHSTaskApproverLocRole = _EHSTaskApproverRoleT.EHSLocationPersonRespRole  -- association [0..*]
;