C_EntProjWrkPckgProjectStatus

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_EntProjWrkPckgProjectStatus.
-- 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: CENTPREPRJWPSTAT

CREATE VIEW C_EntProjWrkPckgProjectStatus AS
SELECT
  TaskUUID,
  ProcessingStatus,
  _StatText.ProcessingStatusText AS ProcessingStatusText,
  cast(concat('PR', WBSElementInternalID) as j_objnr) AS WBSElementInternalID,
  cast('' as text1000) AS SystemStatus,
  Task._AuthUser AS _AuthUser,
  Task._AuthSubst AS _AuthSubst,
  Task._AuthRole AS _AuthRole,
  Task._AuthGroup AS _AuthGroup,
  Task.ControllingArea AS ControllingArea,
  Task.ProfitCenter AS ProfitCenter,
  Task.CompanyCode AS CompanyCode,
  Task.FunctionalArea AS FunctionalArea,
  Task.Plant AS Plant,
  Task.ResponsibleCostCenter AS ResponsibleCostCenter,
  _Root.EnterpriseProjectType AS EnterpriseProjectType,
  _Root.ProjectProfileCode AS ProjectProfileCode
FROM I_PPM_ProjectTask AS Task
LEFT OUTER JOIN I_PPM_ProcessingStatusText AS _StatText ON ProcessingStatus = _StatText.ProcessingStatus  -- association [1..1]
;