I_PPM_CollectedSeverityForTask

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_PPM_CollectedSeverityForTask.
-- 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: IPPMCLCTDSEV4TSK

CREATE VIEW I_PPM_CollectedSeverityForTask AS
SELECT
  link.ViolationUUID AS ViolationUUID,
  link.Severity AS Severity,
  link.ViolationType AS ViolationType,
  link.TaskUUID AS TaskUUID,
  cast(severity._Severity.CriticalityCode as abap.char( 6 )) AS CriticalityCode,
  severity._Severity.ViolationReasonCode AS ViolationReasonCode,
  case when severity._Severity._SeverityText[1:LanguageCode = $session.system_language].SeverityText is null then severity.Severity else severity._Severity._SeverityText[1:LanguageCode = $session.system_language].SeverityText end as SeverityText AS SeverityTextendasSeverityText,
  case when severity._Threshold._Text[1:LanguageCode = $session.system_language].ThresholdText is null then severity.Threshold else severity._Threshold._Text[1:LanguageCode = $session.system_language].ThresholdText end as ThresholdText AS ThresholdTextendasThresholdText,
  link.ObjectType AS ObjectType,
  task.LatestFinishDateTime AS LatestFinishDateTime,
  task.IsMirroredTask AS IsMirroredTask,
  task.IsProjectMilestone AS IsProjectMilestone,
  task.IsSummaryTask AS IsSummaryTask,
  severity.ProjectSummaryTaskUUID AS ProjectSummaryTaskUUID,
  task.ProjectUUID AS ProjectUUID,
  Projecttext.ObjectName AS ProjectName,
  case link.ObjectType when 'ITO' then checklistitem_text.ChecklistItemName when 'MTG' then roletext.ProjectRoleName else tasktext.ObjectName end as ObjectName AS ObjectNameendasObjectName,
  _GlobalSetting.EPPMSettingsDefaultValue AS EPPMSettingsDefaultValue
FROM P_PPM_AggregatedSeverity AS link
LEFT OUTER JOIN I_PPM_SeverityValue AS severity ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EnterpriseProjElmntHier AS level ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_Task AS task ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_TaskText AS tasktext ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_TaskText AS Projecttext ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_ProjectRoleText AS roletext ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_ChecklistItemText AS checklistitem_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EPPMGlobalSetting AS _GlobalSetting ON /* join condition not captured in parsed metadata */
;