I_EHSTaskDefinitionTP

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_EHSTaskDefinitionTP.
-- 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: IEHSTASKDEFRTTP

CREATE VIEW I_EHSTaskDefinitionTP AS
SELECT
  EHSTaskDefinitionUUID,
  CreationUTCDateTime,
  CreatedByUser,
  LastChangeUTCDateTime,
  LastChangedByUser,
  EHSTaskHostObjectInstanceUUID,
  EHSTaskHostObjectInstance,
  EHSTaskHostObjectAdapterClass,
  EHSTaskWorkflowEvent,
  EHSTaskPriority,
  EHSTaskAssignedUser,
  EHSTaskOwnerUser,
  EHSTaskApprovingUser,
  EHSTaskDefinitionStatus,
  EHSTaskTitle,
  EHSTaskDescription,
  EHSLocationUUID,
  EHSTaskStartDate,
  EHSTaskDueInValue,
  EHSTaskDueInUnit,
  EHSTaskDueDate,
  EHSTaskIsDueOnSameDay,
  EHSTaskStartBeforeValue,
  EHSTaskStartBeforeUnit,
  EHSTaskRecurrenceIsByDueDate,
  EHSTaskRecurrenceType,
  EHSTaskRecurrenceInterval,
  EHSTaskIsRecurringOnMonday,
  EHSTaskIsRecurringOnTuesday,
  EHSTaskIsRecurringOnWednesday,
  EHSTaskIsRecurringOnThursday,
  EHSTaskIsRecurringOnFriday,
  EHSTaskIsRecurringOnSaturday,
  EHSTaskIsRecurringOnSunday,
  EHSTaskRecurrenceDay,
  EHSTaskRecurrenceMonth,
  EHSTaskRecurrenceOffset,
  EHSTaskRecurrenceWeekDay,
  EHSTaskRecurrenceEndType,
  EHSTaskRecurrenceEndDate,
  EHSTaskRecurrenceFirstDueDate,
  EHSTaskDefinitionIsPaused,
  EHSTaskID,
  EHSTaskMigrationSource,
  cast( EHSTaskAssignedType as ehfnd_tdef_assignee_type_char ) AS EHSTaskAssignedType,
  EHSTaskAssignedLocRole,
  cast( EHSTaskApproverType as ehfnd_tdef_approver_type_char ) AS EHSTaskApproverType,
  EHSTaskApproverLocRole,
  _EHSTaskDefinitionType.EHSTaskDefinitionManageAction AS EHSTaskDefinitionManageAction,
  _EHSTaskDefinitionType.EHSTaskInstanceDisplayAction AS EHSTaskInstanceDisplayAction,
  _EHSTaskDefinitionType.EHSTaskIsEnabledForReferencing AS EHSTaskIsEnabledForReferencing,
  _IncidentTaskRefAccRestricted.IncidentHasAccessRestriction AS IncidentHasAccessRestriction
FROM I_EHSTaskDefinition AS EHSTaskDefinition
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_EHSTaskDefAssgmtType AS _EHSTaskAssignedType ON EHSTaskAssignedType = _EHSTaskAssignedType.EHSTaskDefAssgmtType  -- association [0..1]
LEFT OUTER JOIN I_EHSTaskDefAssgmtType AS _EHSTaskApproverType ON EHSTaskApproverType = _EHSTaskApproverType.EHSTaskDefAssgmtType  -- association [0..1]
LEFT OUTER JOIN I_EHSTaskDefExecutionTP AS _EHSTaskDefinitionExecution ON EHSTaskDefinitionUUID = _EHSTaskDefinitionExecution.EHSTaskDefinitionUUID  -- association [0..1]
LEFT OUTER JOIN I_EHSTaskDefReferenceTP AS _EHSTaskDefReference ON EHSTaskDefinitionUUID = _EHSTaskDefReference.EHSTaskDefinitionUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSTaskDefMaintenanceTP AS _EHSTaskDefMaintenance ON EHSTaskDefinitionUUID = _EHSTaskDefMaintenance.EHSTaskDefinitionUUID  -- association [0..1]
LEFT OUTER JOIN I_EHSTaskDefMgmtOfChangeTP AS _EHSTaskDefinitionMoC ON EHSTaskDefinitionUUID = _EHSTaskDefinitionMoC.EHSTaskDefinitionUUID  -- association [0..1]
LEFT OUTER JOIN I_EHSTaskPlannedInstanceTP AS _EHSTaskPlannedInstance ON EHSTaskDefinitionUUID = _EHSTaskPlannedInstance.EHSTaskDefinitionUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSLocationPersonRespRole AS _EHSTaskAssignedLocRole ON EHSTaskAssignedLocRole = _EHSTaskAssignedLocRole.EHSLocationPersonRespRole  -- association [0..1]
LEFT OUTER JOIN I_EHSLocationPersonRespRole AS _EHSTaskApproverLocRole ON EHSTaskApproverLocRole = _EHSTaskApproverLocRole.EHSLocationPersonRespRole  -- association [0..1]
LEFT OUTER JOIN I_EHSTaskDefReportInfoTP AS _EHSTaskDefReportingInfo ON EHSTaskDefinitionUUID = _EHSTaskDefReportingInfo.EHSTaskDefinitionUUID  -- association [0..1]
LEFT OUTER JOIN I_EHSTaskDefAssigneeNotifEvtTP AS _EHSTaskDefAssigneeNotifEvt ON EHSTaskDefinitionUUID = _EHSTaskDefAssigneeNotifEvt.EHSTaskDefinitionUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSTaskDefApproverNotifEvtTP AS _EHSTaskDefApproverNotifEvt ON EHSTaskDefinitionUUID = _EHSTaskDefApproverNotifEvt.EHSTaskDefinitionUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSTaskDefOwnerNotifEvtTP AS _EHSTaskDefOwnerNotifEvt ON EHSTaskDefinitionUUID = _EHSTaskDefOwnerNotifEvt.EHSTaskDefinitionUUID  -- association [0..*]
LEFT OUTER JOIN E_EHSTaskDefinition AS _Extension ON EHSTaskDefinitionUUID = _Extension.EHSTaskDefinitionUUID  -- association [1..1]
;