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,
  EHSTaskStatus AS EHSTaskStatusValueForSorting,
  EHSTaskDueDate,
  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_EHSTaskCalendar.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,
  _EHSTaskAdapterClass.EHSSemanticObject AS EHSTaskHostSemanticObject,
  _EHSIncident.IncidentCategory AS IncidentCategory,
  _EHSIncident._IncidentCategory AS _IncidentCategory,
  _EHSIncident.IncidentStatus AS IncidentStatus,
  _CalendarDate.CalendarMonth AS EHSTaskMonth,
  _CalendarDate._CalendarMonth AS _CalendarMonth,
  _CalendarDate.CalendarYear AS EHSTaskYear,
  _CalendarDate._CalendarYear AS _CalendarYear,
  _EHSTaskAdapterClass._SemanticObjectText AS _SemanticObjectText,
  I_EHSTaskCalendar.EHSTaskHostObjectAdapterClass AS EHSTaskHostObjectAdapterClass,
  I_EHSTaskCalendar.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..*]
;