C_PPM_ProjectBriefTP

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 C_PPM_ProjectBriefTP.
-- 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: CPPMPROJBRIEF

CREATE VIEW C_PPM_ProjectBriefTP AS
SELECT
  Project.ProjectUUID AS ProjectUUID,
  ProjectSummaryTaskUUID,
  ProjectInternalID,
  WBSElementInternalID,
  IsMyProject,
  IsProjectSteeringCommitteeMbr,
  OverallProjectStatus,
  OverallProjectStsCriticality,
  Project._AreaStatus.SortField AS OverallProjectStatusSort,
  Project.StatusTrend AS StatusTrend,
  Project._AreaTrend.StatusTrendDescription AS StatusTrendDescription,
  Project._AreaTrend.Criticality AS StatusTrendCriticality,
  Project._AreaTrend.SortField AS StatusTrendSort,
  cast( Project as cats_cpr_extid preserving type) AS Project,
  ProjectName,
  ProjectStartDate,
  ProjectEndDate,
  ProcessingStatus,
  cast(ActualStartDate as dpr_tv_actual_start preserving type) AS ActualStartDate,
  cast(' ' as abap.char(2) ) AS EntProjectDataModelVersion,
  cast(ActualEndDate as dpr_tv_actual_finish preserving type) AS ActualEndDate,
  ProjectManagerUUID,
  _ProjectCostAgg.Currency AS Currency,
  _ProjectCostAgg.ActualCostUpToCurPerd AS ActualCostUpToCurPerd,
  _ProjectCostAgg.PlannedCostUpToCurPerd AS PlannedCostUpToCurPerd,
  _ProjectCostAgg.CostDvtnUpToCurrentPeriod AS CostDvtnUpToCurrentPeriod,
  _ProjectCostAgg.CostDvtnUpToCurPerdCritlty AS CostDvtnUpToCurPerdCritlty,
  _ProjectCostAgg.PlannedCost AS PlannedCost,
  _ProjectCostAgg.ActualCost AS ActualCost,
  NextEssentialMlstnName,
  NextEssentialMlstnDate,
  NextRelevantMlstnName,
  NextRelevantMlstnDate,
  _PriorityText[1:LanguageCode = $session.system_language].PriorityCodeName AS PriorityCodeName,
  EnterpriseProjectType,
  _EnterpriseProjectTypeText[1:Language = $session.system_language].ProjectTypeName AS ProjectTypeName,
  _EntProjWorkflowOverview.EntProjectObjectWorkflowStatus AS EntProjectObjectWorkflowStatus,
  _EntProjWorkflowOverview.EntProjObjWorkflowStatusText AS EntProjObjWorkflowStatusText,
  _ProjectCostAgg._Currency AS _Currency,
  CompanyCode,
  ControllingArea,
  FunctionalArea,
  Plant,
  ProjectProfileCode,
  ResponsibleCostCenter,
  ProfitCenter
FROM I_PPM_ProjectTP AS Project
LEFT OUTER JOIN C_PPM_ProjectBriefCost AS _ProjectCostLineItem ON _ProjectCostLineItem.ProjectSummaryTaskUUID = ProjectSummaryTaskUUID  -- association [0..*]
LEFT OUTER JOIN C_PPM_ProjectBriefCostHeader AS _ProjectCostAgg ON _ProjectCostAgg.ProjectUUID = ProjectUUID  -- association [0..1]
LEFT OUTER JOIN C_PPM_ProjectBriefTaskTP AS _Task ON _Task.ProjectUUID = ProjectUUID  -- association [0..*]
LEFT OUTER JOIN C_PPM_ProjectBriefStatusAreaTP AS _StatusArea ON _StatusArea.ProjectUUID = ProjectUUID  -- association [0..*]
LEFT OUTER JOIN C_PPM_ProjectBriefRoleTP AS _UnstaffedRoles ON _UnstaffedRoles.ProjectUUID = ProjectUUID  -- association [0..*]
LEFT OUTER JOIN C_PPM_ProjectBriefLinkTP AS _Link ON _Link.ProjectUUID = ProjectUUID  -- association [0..*]
LEFT OUTER JOIN C_PPM_ProjectMemberContactCard AS _Manager ON _Manager.BusinessPartnerUUID = ProjectManagerUUID  -- association [0..1]
LEFT OUTER JOIN C_PPM_ProjBriefRoleStaffingTP AS _TeamMemberRoleStaffing ON _TeamMemberRoleStaffing.ProjectUUID = ProjectUUID  -- association [0..*]
LEFT OUTER JOIN I_EntProjWorkflowOverview AS _EntProjWorkflowOverview ON _EntProjWorkflowOverview.ProjectUUID = ProjectUUID  -- association [0..1]
;