I_EHSTaskFutureInstance

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_EHSTaskFutureInstance.
-- 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: IEHSTASKFUTURE

CREATE VIEW I_EHSTaskFutureInstance AS
SELECT
  EHSTaskPlannedInstance.EHSPlannedTaskUUID AS EHSPlannedTaskUUID,
  EHSTaskPlannedInstance.EHSTaskDefinitionUUID AS EHSTaskDefinitionUUID,
  EHSTaskPlannedInstance.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  EHSTaskPlannedInstance.EHSTaskStartDate AS EHSTaskStartDate,
  EHSTaskPlannedInstance.EHSTaskDueDate AS EHSTaskDueDate,
  EHSTaskPlannedInstance.EHSTaskInstceCompletionDate AS EHSTaskInstceCompletionDate,
  EHSTaskPlannedInstance.EHSTaskTimeZone AS EHSTaskTimeZone,
  EHSTaskPlannedInstance.EHSTaskOwnerBP AS EHSTaskOwnerBP,
  EHSTaskPlannedInstance.EHSTaskAssignedBP AS EHSTaskAssignedBP,
  EHSTaskPlannedInstance.EHSTaskApprovingBP AS EHSTaskApprovingBP,
  EHSTaskDefinition.EHSTaskTitle AS EHSTaskTitle,
  EHSTaskDefinition.EHSTaskWorkflowEvent AS EHSTaskDefinitionType,
  EHSTaskDefinition.EHSTaskPriority AS EHSTaskPriority,
  EHSTaskDefinition.EHSTaskDefinitionStatus AS EHSTaskDefinitionStatus,
  EHSTaskDefinition.EHSTaskDefinitionIsPaused AS EHSTaskDefinitionIsPaused,
  EHSTaskDefinition.EHSTaskRecurrenceType AS EHSTaskRecurrenceType,
  _EHSTaskDefinitionExecution.EHSTaskNextExecUTCDateTime AS EHSTaskNextExecUTCDateTime,
  EHSTaskDefinition.EHSLocationUUID AS EHSLocationUUID,
  EHSTaskDefinition._EHSTaskAdapterClass.EHSSemanticObject AS EHSTaskHostSemanticObject,
  EHSTaskDefinition.EHSTaskHostObjectInstanceUUID AS EHSTaskHostObjectInstanceUUID,
  EHSTaskDefinition.EHSTaskHostObjectInstance AS EHSTaskHostObjectInstance,
  EHSTaskDefinition.EHSTaskHostObjectAdapterClass AS EHSTaskHostObjectAdapterClass,
  _IncidentTaskRefAccRestricted.IncidentHasAccessRestriction AS IncidentHasAccessRestriction
FROM I_EHSTaskPlannedInstance AS EHSTaskPlannedInstance
INNER JOIN I_EHSTaskDefinition AS EHSTaskDefinition ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessUser AS _EHSTaskOwnerUser ON EHSTaskOwnerBP = _EHSTaskOwnerUser.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BusinessUser AS _EHSTaskAssignedUser ON EHSTaskAssignedBP = _EHSTaskAssignedUser.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_EHSTaskPriority AS _EHSTaskPriority ON EHSTaskPriority = _EHSTaskPriority.EHSTaskPriority  -- association [0..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_EHSCmplncScenAuthznFields AS _EHSCmplncScenAuthznFields ON EHSTaskHostObjectInstanceUUID = _EHSCmplncScenAuthznFields.EHSCmplncScenOrignRootUUID  -- association [0..1]
;