C_EnterpriseProjectPlanTP

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_EnterpriseProjectPlanTP.
-- 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: CENTPREPRJPLAN

CREATE VIEW C_EnterpriseProjectPlanTP AS
SELECT
  ProjectUUID,
  ProjectSummaryTaskUUID,
  ProjectInternalID,
  Project,
  ProjectName,
  ProcessingStatus,
  ProjectStartDate AS EarliestStartDate,
  ProjectEndDate AS LatestFinishDate,
  cast('' as /s4ppm/tv_proc_status_text ) AS ProcessingStatusText,
  ProjectProfileCode,
  _ProjectProfileVH.ProjectProfileCodeText AS ProjectProfileCodeText,
  WBSElementInternalID,
  cast(' ' as abap.char(2) ) AS EntProjectDataModelVersion,
  ProjectManagerUUID,
  ProfitCenter,
  ControllingArea,
  cast('' as ad_namtext ) AS PersonFullName,
  _EntProjWorkflowOverview.EntProjectObjectWorkflowStatus AS EntProjectObjectWorkflowStatus,
  _EntProjWorkflowOverview.EntProjObjWorkflowStatusText AS EntProjObjWorkflowStatusText,
  _ProjObjRoot.WBSElementObject AS WBSElementObject,
  CompanyCode,
  EnterpriseProjectType,
  FunctionalArea,
  Plant,
  ResponsibleCostCenter
FROM I_PPM_ProjectTP
LEFT OUTER JOIN C_PPM_ProjectMemberContactCard AS _Manager ON _Manager.BusinessPartnerUUID = ProjectManagerUUID  -- association [0..1]
LEFT OUTER JOIN C_EnterpriseProjElementPlanTP AS _Task ON _Task.ProjectUUID = ProjectUUID  -- association [0..*]
LEFT OUTER JOIN C_EnterpriseProjectVH AS _ProjectVH ON _ProjectVH.Project = Project  -- association [0..1]
LEFT OUTER JOIN C_PPM_ProjectProfileVH AS _ProjectProfileVH ON _ProjectProfileVH.ProjectProfileCode = ProjectProfileCode  -- association [0..1]
LEFT OUTER JOIN I_EntProjWorkflowOverview AS _EntProjWorkflowOverview ON _EntProjWorkflowOverview.ProjectUUID = ProjectUUID  -- association [0..1]
;