I_IncidentTaskCube

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_IncidentTaskCube.
-- 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: IEHSCALIT

CREATE VIEW I_IncidentTaskCube AS
SELECT
  WorkflowTaskInternalID,
  EHSTaskDefinitionUUID,
  EHSTaskHostObjectInstance,
  EHSTaskHostObjectInstanceUUID,
  cast( EHSTaskStatusValueForSorting as ehfnd_task_calendar_status preserving type ) AS EHSTaskStatusValueForSorting,
  EHSTaskDefinitionType,
  EHSTaskDueDate,
  EHSTaskStartDate,
  EHSPlannedTaskID,
  EHSTaskTitle,
  EHSTaskAssignedBP,
  EHSTaskAssignedUserName,
  EHSLocationUUID,
  bintohex(EHSLocationUUID) AS EHSLocationUUIDHex,
  case when _EHSLocation[RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._EHSLocationRevisionName[1: Language = $session.system_language].EHSLocationName is null then bintohex( I_EHSCombinedTaskDefAndInstce.EHSLocationUUID ) else _EHSLocation[RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._EHSLocationRevisionName[1: Language = $session.system_language].EHSLocationName end as EHSLocationName AS EHSLocationNameendasEHSLocationName,
  cast( 1 as ehfnd_integer ) AS EHSNumberOfTasks,
  EHSTaskHostSemanticObject,
  _EHSIncident.IncidentCategory AS IncidentCategory,
  _EHSIncident._IncidentCategory AS _IncidentCategory,
  _EHSIncident.IncidentStatus AS IncidentStatus,
  _EHSIncident._IncidentStatus AS _IncidentStatus,
  _EHSIncident.IncidentID AS IncidentID,
  EHSLearningUUID,
  _LearningDescr.EHSLearningDescriptionText AS EHSLearningDescriptionText,
  _CalendarDate.CalendarMonth AS EHSTaskMonth,
  _CalendarDate._CalendarMonth AS _CalendarMonth,
  _CalendarDate.CalendarYear AS EHSTaskYear,
  _CalendarDate._CalendarYear AS _CalendarYear,
  I_EHSCombinedTaskDefAndInstce.EHSTaskHostObjectAdapterClass AS EHSTaskHostObjectAdapterClass,
  I_EHSCombinedTaskDefAndInstce.EHSTaskOwnerBP AS EHSTaskOwnerBP,
  IncidentHasAccessRestriction
LEFT OUTER JOIN I_EHSLocation AS _EHSLocation ON EHSLocationUUID = _EHSLocation.EHSLocationUUID  -- association [0..*]
LEFT OUTER JOIN I_IncidentCombAuthFields AS _EHSIncident ON EHSTaskHostObjectInstanceUUID = _EHSIncident.EHSTaskHostObjectInstanceUUID  -- association [1..1]
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON EHSTaskDueDate = _CalendarDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_IncidentCategoryText AS _IncidentCategoryText ON IncidentCategory = _IncidentCategoryText.IncidentCategory  -- association [0..*]
LEFT OUTER JOIN I_EHSTaskDefinitionTypeText AS _TaskDefinitionTypeText ON EHSTaskDefinitionType = _TaskDefinitionTypeText.EHSTaskDefinitionType  -- association [0..*]
LEFT OUTER JOIN I_EHSLearning AS _LearningDescr ON EHSLearningUUID = _LearningDescr.EHSLearningUUID  -- association [0..1]
;