C_ActiveProjectOvrlSts

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_ActiveProjectOvrlSts.
-- 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: CACTPROJOVRLSTS

CREATE VIEW C_ActiveProjectOvrlSts AS
SELECT
  ProjectUUID,
  ProjectSummaryTaskUUID,
  ProjStatus.IsOverallStatus AS IsOverallStatus,
  _Root.ProjectName AS ProjectName,
  ProjStatus.Status AS Status,
  ProjStatus.StatusTrend AS StatusTrend,
  ProjStatus._AreaTrend.Criticality AS AreaTrendCriticality,
  _Root.OverallProjectStsCriticality AS OverallProjectStsCriticality,
  _Root.Project AS Project,
  _Responsible.BusinessPartnerFullName AS BusinessPartnerFullName,
  _Responsible.BusinessPartnerUUID AS BusinessPartnerUUID,
  _EnterpriseProject.EnterpriseProjectType AS ProjectType,
  _Responsible._BusinessUser.BusinessPartner AS BusinessPartner,
  ProjStatus._AreaStatus.SortField AS StatusAreaSortNumber,
  ProjStatus._AreaStatus AS _AreaStatus,
  ProjStatus._AreaStatusText AS _AreaStatusText,
  ProjStatus._AreaTrend AS _AreaTrend,
  ProjStatus._AreaTrendText AS _AreaTrendText,
  _EnterpriseProject.CompanyCode AS CompanyCode,
  _EnterpriseProject.ControllingArea AS ControllingArea,
  _EnterpriseProject.ProfitCenter AS ProfitCenter,
  _EnterpriseProject.ResponsibleCostCenter AS ResponsibleCostCenter,
  _EnterpriseProject.FunctionalArea AS FunctionalArea,
  _EnterpriseProject.Plant AS Plant,
  _EnterpriseProject.ProjectProfileCode AS ProjectProfileCode
LEFT OUTER JOIN I_SingleResponsibleForProj AS _Responsible ON ProjectSummaryTaskUUID = _Responsible.ReferencedObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_EnterpriseProject AS _EnterpriseProject ON ProjectUUID = _EnterpriseProject.ProjectUUID  -- association [0..1]
LEFT OUTER JOIN E_PPM_Project AS _ProjectHeaderExtension ON ProjectUUID = _ProjectHeaderExtension.ProjectUUID  -- association [1..1]
;