C_EntProjectBriefHeaderTP

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_EntProjectBriefHeaderTP.
-- 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 C_EntProjectBriefHeaderTP AS
SELECT
  ProjectUUID,
  ProjectSummaryTaskUUID,
  ProjectInternalID,
  WBSElementInternalID,
  PROJECT.Project AS Project,
  ProjectDescription,
  _StatusAreaData[ IsOverallStatus = 'X' ].StatusAreaStatus AS OverallProjectStatus,
  _StatusAreaData[ IsOverallStatus = 'X' ].StatusTrend AS StatusTrend,
  _StatusAreaData[ IsOverallStatus = 'X' ]._StatusAreaStatus.Criticality AS OverallProjectStsCriticality,
  _StatusAreaData[ IsOverallStatus = 'X' ]._StatusAreaTrend.Criticality AS StatusTrendCriticality,
  _StatusAreaData[ IsOverallStatus = 'X' ]._StatusAreaCode.SortField AS OverallProjectStatusSort,
  _StatusAreaData[ IsOverallStatus = 'X' ]._StatusAreaTrend.SortField AS StatusTrendSort,
  _StatusAreaData[ IsOverallStatus = 'X' ]._StatusAreaStatus.StatusDescription AS StatusDescription,
  _StatusAreaData[ IsOverallStatus = 'X' ]._StatusAreaTrend.StatusTrendDescription AS StatusTrendDescription,
  _NextRlvtMilestone.NextRelevantMlstnDate AS NextRelevantMlstnDate,
  _NextRlvtMilestone.NextRelevantMlstnName AS NextRelevantMlstnName,
  _NextEsnlMilestone.NextEssentialMlstnDate AS NextEssentialMlstnDate,
  _NextEsnlMilestone.NextEssentialMlstnName AS NextEssentialMlstnName,
  ProjectStartDate,
  ProjectEndDate,
  ActualStartDate,
  ActualEndDate,
  ProcessingStatus,
  PriorityCode,
  EnterpriseProjectType,
  _EntProjWorkflowOverview.EntProjectObjectWorkflowStatus AS EntProjectObjectWorkflowStatus,
  _EntProjWorkflowOverview.EntProjObjWorkflowStatusText AS EntProjObjWorkflowStatusText,
  _ControllingArea.ControllingAreaCurrency AS GlobalCurrency,
  _EntProjRoleStaffing[1:ProjectRoleType = 'YP_RL_0001'].BusinessPartnerUUID AS BusinessPartnerUUID,
  _EntProjRoleStaffing[1:ProjectRoleType = 'YP_RL_0001']._BusinessPartner.PersonFullName AS PersonFullName,
  virtual IsMyProject : abap_boolean AS virtualIsMyProjectabap_boolean,
  virtual ActualCost : abap.curr( 25, 2 ) AS curr252,
  virtual CostDvtnUpToCurPerdCritlty : abap.char( 1 ) AS char1,
  ProjectCategory,
  EntProjectIsConfidential,
  EnterpriseProjectServiceOrg,
  ProjectProfileCode,
  CompanyCode,
  Plant,
  FunctionalArea,
  ResponsibleCostCenter,
  ProfitCenter,
  ControllingArea
FROM I_EnterpriseProjectTP_2
LEFT OUTER JOIN C_EnterpriseProjectBriefCost AS _ProjectCostLineItem ON _ProjectCostLineItem.ProjectInternalID = ProjectInternalID  -- association [0..*]
LEFT OUTER JOIN C_PPM_ProjectMemberContactCard AS _Manager ON _Manager.BusinessPartnerUUID = businesspartneruuid  -- association [0..1]
;