P_PPM_Prstcm_ProjData

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 P_PPM_Prstcm_ProjData.
-- 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: PPPMPRSTCMPRD

CREATE VIEW P_PPM_Prstcm_ProjData AS
SELECT
  _ProjectSummary.ProjectUUID AS ProjectUUID,
  _ProjectSummary.ProjectInternalID AS ProjectInternalID,
  _ProjectSummary.Project AS Project,
  _ProjectSummary.ProjectSummaryTaskUUID AS ProjectSummaryTaskUUID,
  _ProjectSummary.ProjectProcessingStatus AS ProcessingStatus,
  _ProjectSummary.PriorityCode AS PriorityCode,
  _OverallStatusArea.Status AS Status,
  PS_RootWBS.ProjectType AS ProjectType,
  _MlstnEssential.TaskUUID AS NextEssentialMlstnUUID,
  cast(1 as abap.int1) AS StatusCount,
  _Responsible._BusinessUser.PersonFullName AS BusinessPartnerFullName,
  _Responsible.BusinessPartnerUUID AS ProjectManagerUUID,
  IsPrjSteerMbr.IsInRoleCategory AS IsProjectSteeringCommitteeMbr,
  _Project.ControllingArea AS ControllingArea,
  _Project.ProfitCenter AS ProfitCenter,
  PS_RootWBS.ProfitCenter AS WBSElementProfitCenter,
  _Responsible._BusinessUser AS _BusinessUser,
  _ProjectSummary._AuthUser AS _AuthUser,
  _ProjectSummary._AuthSubst AS _AuthSubst,
  _ProjectSummary._AuthRole AS _AuthRole,
  _ProjectSummary._AuthGroup AS _AuthGroup
FROM I_PPM_ProjectSummaryTask AS _ProjectSummary
LEFT OUTER JOIN I_ProjectBasicData AS _Project ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WBSElementBasicData AS PS_RootWBS ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_ProjectMilestEssent AS _MlstnEssential ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_ProjectMilestRelNext AS _MlstnRelevant ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_ProjectStatusArea AS _OverallStatusArea ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_SingleResponsibleForProj AS _Responsible ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_TeamMemberIsInRole ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_Task AS _NextEssentialMlstn ON _NextEssentialMlstn.TaskUUID = _MlstnEssential.TaskUUID  -- association [0..1]
;