I_EHSTask

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_EHSTask.
-- 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: IEHSTASK

CREATE VIEW I_EHSTask AS
SELECT
  _WorkflowTask.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  _WorkflowTask.WorkflowTaskType AS WorkflowTaskType,
  _WorkflowTask.WorkflowTaskPriority AS WorkflowTaskPriority,
  _WorkflowTask.WorkflowTaskStatus AS WorkflowTaskStatus,
  _WorkflowTask.WrkflwTskCreationUTCDateTime AS WrkflwTskCreationUTCDateTime,
  _WorkflowTask.WrkflwTskCompletionUTCDateTime AS WrkflwTskCompletionUTCDateTime,
  _WorkflowTask.WorkflowTaskCreatedByUser AS WorkflowTaskCreatedByUser,
  _WorkflowTask.WorkflowTaskCurrentUser AS WorkflowTaskCurrentUser,
  _WorkflowTask.WorkflowTaskDefinition AS WorkflowTaskDefinition,
  _WorkflowTask.WorkflowTaskDefinitionObjType AS WorkflowTaskDefinitionObjType,
  _WorkflowTask.WorkflowTaskDefinitionObject AS WorkflowTaskDefinitionObject,
  _WorkflowTask.TopLevelWorkflowTask AS TopLevelWorkflowTask,
  _WorkflowTask._TaskTitle[ 1:Language = $session.system_language ].WorkflowTaskName AS WorkflowTaskName,
  _WorkflowTask._TaskTitle AS _TaskTitle,
  _WorkflowTask._TaskType AS _TaskType,
  _WorkflowTask._TaskPriority AS _TaskPriority,
  _WorkflowTask._TaskStatus AS _TaskStatus,
  _WorkflowTask._TaskApplicationObject AS _TaskApplicationObject,
  _WorkflowTask._TaskApplicationLeadingObject AS _TaskApplicationLeadingObject,
  _WorkflowTask._TaskStartEvent AS _TaskStartEvent,
  _WorkflowTask._TaskDefinition AS _TaskDefinition,
  _DefGuid.EHSTaskInstanceStepNodeID AS EHSTaskInstanceStepNodeID,
  _InstanceToDefinition.EHSTaskHostObjectAdapterClass AS EHSTaskHostObjectAdapterClass,
  _InstanceToDefinition.EHSTaskHostObjectInstance AS EHSTaskHostObjectInstance,
  _InstanceToDefinition.EHSTaskHostObjectInstanceUUID AS EHSTaskHostObjectInstanceUUID,
  _InstanceToDefinition.EHSTaskDefinitionUUID AS EHSTaskDefinitionUUID,
  _InstanceToDefinition._EHSTaskDefinition AS _EHSTaskDefinition,
  _EHSTaskDueDate.EHSTaskDueDate AS EHSTaskDueDate,
  _EHSTaskInstance.EHSTaskInstanceProcessorUser AS EHSTaskCurrentProcessorUser,
  _EHSTaskInstance.EHSTaskAssignedLocRole AS EHSTaskAssignedLocRole,
  _EHSTaskInstance.EHSTaskApproverLocRole AS EHSTaskApproverLocRole,
  _IncidentTaskRefAccRestricted.IncidentHasAccessRestriction AS IncidentHasAccessRestriction
FROM I_WorkflowTask AS _WorkflowTask
INNER JOIN P_EHSTaskInstanceToDefinition AS _InstanceToDefinition ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_EHSTaskInstanceDefGUID AS _DefGuid ON _DefGuid.WorkflowTaskInternalID = _WorkflowTask.WorkflowTaskInternalID  -- association [1..1]
LEFT OUTER JOIN I_EHSTaskInstance AS _EHSTaskInstance ON TopLevelWorkflowTask = _EHSTaskInstance.WorkflowTaskInternalID  -- association [1..1]
LEFT OUTER JOIN I_EHSTaskInstanceStep AS _EHSTaskInstanceStep ON TopLevelWorkflowTask = _EHSTaskInstanceStep.WorkflowTaskInternalID AND WorkflowTaskDefinition = _EHSTaskInstanceStep.WorkflowTaskDefinition  -- association [1..1]
LEFT OUTER JOIN I_EHSTaskDueDate AS _EHSTaskDueDate ON WorkflowTaskInternalID = _EHSTaskDueDate.WorkflowTaskInternalID  -- association [0..1]
LEFT OUTER JOIN I_EHSTaskAdapterClass AS _EHSTaskAdapterClass ON EHSTaskHostObjectAdapterClass = _EHSTaskAdapterClass.EHSTaskAdapterClass  -- association [1..1]
LEFT OUTER JOIN I_IncidentAuthorizationFields 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_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]
;