I_PPM_LastUsedProject

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_LastUsedProject.
-- 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: IPPMLASTUSEDPRO

CREATE VIEW I_PPM_LastUsedProject AS
SELECT
  Project.ProjectUUID AS ProjectUUID,
  Project.ProjectSummaryTaskUUID AS ProjectSummaryTaskUUID,
  LastUsed.OrdinalNumber AS OrdinalNumber,
  Item.PortfolioItemUUID AS PortfolioItemUUID,
  Item.PortfolioUUID AS PortfolioUUID,
  Project.ProjectProcessingStatus AS ProjectProcessingStatus,
  ProjectNameUserLanguage,
  ProjectNameMasterLanguage,
  Project,
  ProjectType,
  ProjectTypeName,
  PhaseCurrentTask.LatestFinishDate AS CurrentPhaseEndDate,
  PhaseCurrentTextUserLang.ObjectName AS CurrentPhaseNameUserLanguage,
  PhaseCurrentTask.TaskName AS CurrentPhaseNameMasterLanguage,
  MilestEssentTask.LatestFinishDate AS LaunchDate,
  milestRelNextTextUserLang.ObjectName AS NextMilestoneNameUserLanguage,
  MilestRelNextTask.TaskName AS NextMilestoneNameMasterLang,
  MilestRelNextTask.LatestFinishDate AS NextMilestoneDate,
  projectImage.ProjectImageURL AS ProjectImageURL,
  _GlobalSetting.EPPMSettingsDefaultValue AS EPPMSettingsDefaultValue,
  Project._AuthUser AS _AuthUser,
  Project._AuthSubst AS _AuthSubst,
  Project._AuthRole AS _AuthRole,
  Project._AuthGroup AS _AuthGroup
FROM P_PPM_ProjectList AS Project
INNER JOIN P_PPM_ProjectsFromPers AS LastUsed ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_ItemInfo AS Item ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_ProjectMilestRelNext AS milestRelNext ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_Task AS MilestRelNextTask 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_Text AS milestRelNextTextUserLang ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_PPM_ProjectImage AS projectImage ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_ProjectPhaseCurrent AS PhaseCurrent ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_Task AS PhaseCurrentTask ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_Text AS PhaseCurrentTextUserLang ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EPPMGlobalSetting AS _GlobalSetting ON /* join condition not captured in parsed metadata */
;