I_PPM_MostCriticalProject

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_MostCriticalProject.
-- 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: IPPMMOSTCRITPRO

CREATE VIEW I_PPM_MostCriticalProject AS
SELECT
  Project.ProjectUUID AS ProjectUUID,
  Project.ProjectSummaryTaskUUID AS ProjectSummaryTaskUUID,
  Item.PortfolioItemUUID AS PortfolioItemUUID,
  Item.PortfolioUUID AS PortfolioUUID,
  Project.ProjectProcessingStatus AS ProjectProcessingStatus,
  NameUserLanguage.ObjectName AS ProjectNameUserLanguage,
  ProjectName AS ProjectNameMasterLanguage,
  Project,
  ProjectType,
  MilestEssentTask.LatestFinishDate AS LaunchDate,
  Severity.CriticalityCode AS CriticalityCode,
  Severity.Severity AS Severity,
  Severity._SeverityText AS _SeverityText,
  _GlobalSetting.EPPMSettingsDefaultValue AS EPPMSettingsDefaultValue,
  Project._AuthUser AS _AuthUser,
  Project._AuthSubst AS _AuthSubst,
  Project._AuthRole AS _AuthRole,
  Project._AuthGroup AS _AuthGroup
FROM I_PPM_ProjectSummaryTask AS Project
LEFT OUTER JOIN I_PPM_ItemInfo AS Item ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_ProjectMilestEssent AS milestEssent ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_Task AS MilestEssentTask ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_ObjectSeverity AS Severity ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_Text AS NameUserLanguage ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_IsMyProject AS IsMyProject ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_IsMyProjectAsSubstitute AS IsMyProjectAsSubstitute ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EPPMGlobalSetting AS _GlobalSetting ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_ProjectPhaseCurrent AS _ProjectPhaseCurrent ON ProjectUUID = _ProjectPhaseCurrent.ProjectUUID  -- association [0..1]
;