C_EHSTaskMonitoring

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 C_EHSTaskMonitoring.
-- 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: CEHSTASKMON

CREATE VIEW C_EHSTaskMonitoring AS
SELECT
  EHSTaskDefinitionUUID,
  WorkflowTaskInternalID,
  EHSPlannedTaskUUID,
  EHSTaskDefinitionType,
  cast( _EHSTaskDefinitionTypeText[1: Language = $session.system_language].EHSTaskDefinitionTypeName as ehfnd_task_type_descr preserving type ) AS EHSTaskDefinitionTypeName,
  EHSTaskTitle,
  cast(EHSPlannedTaskID as ehfnd_task_planned_id) AS EHSPlannedTaskID,
  EHSTaskStatusValueForSorting,
  EHSTaskStatusName,
  EHSTaskDefinitionIsPaused,
  EHSTaskDefinitionStatus,
  WorkflowTaskStatus,
  WrkflwTskCompletionUTCDateTime,
  EHSTaskHasWorkflow,
  EHSTaskDueDate,
  EHSTaskStartDate,
  _CalendarDate.CalendarMonth AS EHSTaskMonth,
  _CalendarDate._CalendarMonth._Text[ 1: Language = $session.system_language ].CalendarMonthName AS CalendarMonthName,
  _CalendarDate.CalendarYear AS EHSTaskYear,
  EHSTaskInstceCompletionDate,
  EHSTaskIsRecurrent,
  EHSTaskPriority,
  cast( EHSTaskPriorityName as ehfnd_task_def_priority_name preserving type ) AS EHSTaskPriorityName,
  EHSTaskStatusCriticality,
  EHSTaskHostSemanticObject,
  EHSTaskHostObjectInstance,
  EHSTaskHostObjectInstanceUUID,
  EHSTaskUser,
  EHSTaskUserName,
  EHSTaskInstanceProcessorBP,
  EHSTaskInstanceProcessorUser,
  EHSTaskInstanceProcessorName,
  EHSTaskOwnerUser,
  EHSTaskOwnerBP,
  EHSTaskOwnerUserName,
  _EHSTaskAssigneeUser.UserID AS EHSTaskAssignedUser,
  EHSTaskAssignedBP,
  EHSTaskAssignedUserName,
  EHSTaskAssignedLocRole,
  EHSTaskAssignedLocRoleName,
  EHSTaskApprovingBP,
  EHSTaskApprovingUserName,
  EHSTaskApproverLocRole,
  EHSTaskApproverLocRoleName,
  EHSTaskDefinitionManageAction,
  EHSTaskInstanceDisplayAction,
  EHSTaskDateForSorting,
  EHSTaskHostObjectAdapterClass,
  cast('' as text240) AS EHSTskRelatedObjectDescription,
  cast('' as text1024) AS EHSTaskRelatedObjectURL,
  EHSLocationUUID,
  EHSLocationName,
  EHSLocationID,
  EHSLocationIDAndName,
  EHSTaskTimeZone,
  IsDraftEntity,
  DraftEntityLastChangeDateTime,
  DraftIsLastChangedByMe,
  LastChangedByUserDescription,
  DraftIsProcessedByMe,
  InProcessByUserDescription,
  InProcessByUser,
  HasActiveEntity,
  DraftUUID,
  _CalendarDate._CalendarMonth AS _CalendarMonth,
  _CalendarDate._CalendarYear AS _CalendarYear,
  IncidentHasAccessRestriction
FROM C_EHSCombinedTaskDefAndInstce AS CombinedTaskDefAndInstce
LEFT OUTER JOIN I_EHSSemanticObjectText AS _SemanticObjectText ON EHSTaskHostSemanticObject = _SemanticObjectText.EHSSemanticObject  -- association [0..*]
LEFT OUTER JOIN E_EHSTaskDefinition AS _Extension ON EHSTaskDefinitionUUID = _Extension.EHSTaskDefinitionUUID  -- association [1..1]
LEFT OUTER JOIN E_EHSTaskPlannedInstance AS _ExtensionInstance ON EHSPlannedTaskUUID = _ExtensionInstance.EHSPlannedTaskUUID  -- association [1..1]
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON EHSTaskDueDate = _CalendarDate.CalendarDate  -- association [0..1]
;