P_PPM_Project

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_Project.
-- 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.

CREATE VIEW P_PPM_Project AS
SELECT
  Project.ProjectUUID AS ProjectUUID,
  Project.ProjectSummaryTaskUUID AS ProjectSummaryTaskUUID,
  Project.Project AS Project,
  Project.ProjectName AS ProjectName,
  Project.ProjectInternalID AS ProjectInternalID,
  Project.WBSElementInternalID AS WBSElementInternalID,
  Project.ProjectProcessingStatus AS ProcessingStatus,
  Project.ProjectTemplateUUID AS ProjectTemplateUUID,
  Project.ProjectCategory AS ProjectCategory,
  PS_Project.ProjectObject AS StatusObject,
  PS_Project.EntProjectSettlementType AS EntProjectSettlementType,
  PS_RootWBS.EntProjectSettlementElement AS EntProjectSettlementElement,
  PS_RootWBS.ResultAnalysisInternalID AS ResultAnalysisInternalID,
  PS_Project.Location AS Location,
  PS_Project.ProjectCurrency AS ProjectCurrency,
  PS_Project.TaxJurisdiction AS TaxJurisdiction,
  PS_Project.ProjectProfileCode AS ProjectProfileCode,
  PS_RootWBS.ResponsibleCostCenter AS ResponsibleCostCenter,
  PS_RootWBS.ProfitCenter AS ProfitCenter,
  PS_RootWBS.CompanyCode AS CompanyCode,
  PS_RootWBS.ControllingArea AS ControllingArea,
  PS_RootWBS.FunctionalArea AS FunctionalArea,
  PS_RootWBS.Plant AS Plant,
  PS_RootWBS.FactoryCalendar AS FactoryCalendar,
  PS_RootWBS.CostingSheet AS CostingSheet,
  PS_RootWBS.CostCenter AS CostCenter,
  PS_RootWBS.WBSElementIsBillingElement AS IsBillingRelevant,
  PS_RootWBS.WBSIsStatisticalWBSElement AS IsStatistical,
  PS_RootWBS.InvestmentProfile AS InvestmentProfile,
  PS_RootWBS.FunctionalLocation AS FunctionalLocation,
  OverallStatusArea.StatusAreaUUID AS OverallStatusAreaUUID,
  OverallStatusArea.Status AS OverallProjectStatus,
  OverallStatusArea.Criticality AS OverallProjectStsCriticality,
  OverallStatusArea.StatusTrend AS StatusTrend,
  Project.ProjectLastChangedByUser AS LastChangedByUser,
  Project.ProjectLastChangedDateTime AS LastChangeDateTime,
  Project.CreatedByUser AS CreatedByUser,
  Project.CreationDateTime AS CreationDateTime,
  Project.MasterLanguage AS MasterLanguage,
  Project.ProjectType AS ProjectType,
  Project.ProjectVersionNumber AS ProjectVersionNumber,
  Project.PriorityCode AS PriorityCode,
  Project.EntProjIsMultiSlsOrdItmsEnbld AS EntProjIsMultiSlsOrdItmsEnbld,
  PS_RootWBS.ProjectType AS EnterpriseProjectType,
  case when IsMyProject.IsMyProject is null then ' ' else IsMyProject.IsMyProject end as IsMyProject AS IsMyProjectendasIsMyProject,
  case when IsMyProjectAsSubstitute.IsMyProject is null then ' ' else IsMyProjectAsSubstitute.IsMyProject end as IsMyProjectAsSubstitute AS IsMyProjectendasIsMyProjectAsSubstitute,
  Responsible.BusinessPartnerUUID AS ProjectManagerUUID,
  Project.LatestStartDate AS ProjectStartDate,
  Project.LatestFinishDate AS ProjectEndDate,
  Project.ProjectElementDuration AS ProjectElementDuration,
  Project.ActualStartDate AS ActualStartDate,
  Project.ActualFinishDate AS ActualEndDate,
  MlstnEssential.TaskUUID AS NextEssentialMlstnUUID,
  MlstnRelevant.TaskUUID AS NextRelevantMlstnUUID,
  PS_Project.AvailabilityControlProfile AS AvailabilityControlProfile,
  PS_Project.AvailabilityControlIsActive AS AvailabilityControlIsActive,
  PS_Project.EntProjHasProjectStockEnabled AS EntProjHasProjectStockEnabled,
  Project._CreatedByUser AS _CreatedByUser,
  Project._ProjectLastChangedByUser AS _ProjectLastChangedByUser,
  Project._AuthUser AS _AuthUser,
  Project._AuthSubst AS _AuthSubst,
  Project._AuthRole AS _AuthRole,
  Project._AuthGroup AS _AuthGroup,
  Project._I_Project AS _I_Project,
  Project._ProjObjRoot AS _ProjObjRoot
FROM I_PPM_ProjectSummaryTask AS Project
LEFT OUTER JOIN I_ProjectBasicData AS PS_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_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_PPM_TeamMemberIsInRole ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_SingleResponsibleForProj AS Responsible ON Responsible.ProjectSummaryTaskUUID = Project.ProjectSummaryTaskUUID  -- association [0..1]
LEFT OUTER JOIN I_PPM_Task AS _ProjectTask ON _ProjectTask.ProjectUUID = ProjectUUID  -- association [0..*]
LEFT OUTER JOIN I_PPM_ProjectProcgStatusVH AS _ProcessingStatus ON _ProcessingStatus.ProcessingStatus = ProcessingStatus  -- association [0..1]
LEFT OUTER JOIN I_PPM_ProcessingStatusText AS _ProcessingStatusText ON _ProcessingStatusText.ProcessingStatus = ProcessingStatus  -- association [0..*]
LEFT OUTER JOIN I_PPM_ProjectType AS _ProjectType ON _ProjectType.ProjectType = ProjectType  -- association [0..1]
LEFT OUTER JOIN I_PPM_ProTypeText AS _ProTypeName ON _ProTypeName.ProjectType = ProjectType  -- association [0..*]
LEFT OUTER JOIN I_PPM_Task AS _NextEssentialMlstn ON _NextEssentialMlstn.TaskUUID = NextEssentialMlstnUUID AND _NextEssentialMlstn.ProjectUUID = ProjectUUID  -- association [0..1]
LEFT OUTER JOIN I_PPM_Task AS _NextRelevantMlstn ON _NextRelevantMlstn.TaskUUID = NextRelevantMlstnUUID AND _NextRelevantMlstn.ProjectUUID = ProjectUUID  -- association [0..1]
LEFT OUTER JOIN I_BusinessUser AS _ProjectManager ON _ProjectManager.BusinessPartnerUUID = ProjectManagerUUID  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectStatusBasic AS _StatusObjectData ON _StatusObjectData.StatusObject = StatusObject  -- association [0..*]
LEFT OUTER JOIN I_PPM_StatusAreaStatus AS _AreaStatus ON _AreaStatus.Status = OverallProjectStatus  -- association [0..1]
LEFT OUTER JOIN I_PPM_StatusAreaStatusText AS _AreaStatusText ON _AreaStatusText.Status = OverallProjectStatus  -- association [0..*]
LEFT OUTER JOIN I_PPM_StatusAreaTrend AS _AreaTrend ON _AreaTrend.StatusTrend = StatusTrend  -- association [0..1]
LEFT OUTER JOIN I_PPM_StatusAreaTrendText AS _AreaTrendText ON _AreaTrendText.StatusTrend = StatusTrend  -- association [0..*]
LEFT OUTER JOIN I_PPM_ProjectResponsible AS _ProjectResponsible ON _ProjectResponsible.ProjectUUID = ProjectUUID  -- association [0..*]
LEFT OUTER JOIN I_PPM_Substitute AS _Substitute ON _Substitute.ReferencedObjectUUID = ProjectSummaryTaskUUID  -- association [0..1]
LEFT OUTER JOIN I_PPM_TaskText AS _ProjectName ON _ProjectName.TaskUUID = ProjectSummaryTaskUUID  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON _ControllingArea.ControllingArea = ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON _CompanyCode.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON _CostCenter.CostCenter = CostCenter AND _CostCenter.ControllingArea = ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON _Plant.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN I_ProjectProfileCode AS _ProjectProfileCode ON _ProjectProfileCode.ProjectProfileCode = ProjectProfileCode  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON _FunctionalArea.FunctionalArea = FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON _ProfitCenter.ProfitCenter = ProfitCenter AND _ProfitCenter.ControllingArea = ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_Projecttype AS _EnterpriseProjectType ON _EnterpriseProjectType.ProjectType = EnterpriseProjectType  -- association [0..1]
LEFT OUTER JOIN I_Projecttypetext AS _EnterpriseProjectTypeText ON _EnterpriseProjectTypeText.ProjectType = EnterpriseProjectType  -- association [0..*]
;