P_PPM_ProjectList

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 P_PPM_ProjectList.
-- 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: PPPMPROJECTLIST

CREATE VIEW P_PPM_ProjectList AS
SELECT
  Project.ProjectUUID AS ProjectUUID,
  Project.ProjectSummaryTaskUUID AS ProjectSummaryTaskUUID,
  Project.ProjectCategory AS ProjectCategory,
  Project.ProjectLastChangedByUser AS ProjectLastChangedByUser,
  Project.ProjectLastChangedDateTime AS ProjectLastChangedDateTime,
  Project.ProjectReasonCode AS ProjectReasonCode,
  Project.ProjectName AS ProjectName,
  Project.MasterLanguage AS MasterLanguage,
  Project.IsSummaryTaskEnabled AS IsSummaryTaskEnabled,
  Project.ProjectLocation AS ProjectLocation,
  Project.PlanVersion AS PlanVersion,
  Project.OrganizationalUnitObjectType AS OrganizationalUnitObjectType,
  Project.OrganizationalUnit AS OrganizationalUnit,
  Project.ProjectEarliestOrLatest AS ProjectEarliestOrLatest,
  Project.EarliestStartDateTime AS EarliestStartDateTime,
  Project.ActualStartDateTime AS ActualStartDateTime,
  Project.LatestStartDateTime AS LatestStartDateTime,
  Project.EarliestFinishDateTime AS EarliestFinishDateTime,
  Project.ActualFinishDateTime AS ActualFinishDateTime,
  Project.LatestFinishDateTime AS LatestFinishDateTime,
  Project.StartConstraintDateTime AS StartConstraintDateTime,
  Project.FinishConstraintDateTime AS FinishConstraintDateTime,
  Project.ProjectElementDuration AS ProjectElementDuration,
  Project.DurationUnit AS DurationUnit,
  Project.ProjectType AS ProjectType,
  Project.Project AS Project,
  Project.ReleaseDateTime AS ReleaseDateTime,
  Project.ProjectInternalID AS ProjectInternalID,
  Project.WBSElementInternalID AS WBSElementInternalID,
  Project.ProjectProcessingStatus AS ProjectProcessingStatus,
  Project.PriorityCode AS PriorityCode,
  Project.ProjectVersionNumber AS ProjectVersionNumber,
  Project.CreatedByUser AS CreatedByUser,
  Project.CreationDateTime AS CreationDateTime,
  User.BusinessPartnerUUID AS MyBusinessPartnerUUID,
  case when IsMyProject.IsMyProject is null then ' ' else IsMyProject.IsMyProject end as IsMyProject AS IsMyProjectendasIsMyProject,
  case when IsMyProjectAsSubstitute.IsMyProject is null then ' ' else IsMyProjectAsSubstitute.IsMyProject end as IsMyProjectAsSubstitute AS IsMyProjectendasIsMyProjectAsSubstitute,
  NameUserLanguage.ObjectName AS ProjectNameUserLanguage,
  ProjectName AS ProjectNameMasterLanguage,
  ProTypeName.ProjectTypeName AS ProjectTypeName,
  ProTypeName.ProjectTypeName AS ProjectTypeNameUserLanguage,
  TypeNameMasterLanguage.ProjectTypeName AS ProjectTypeNameMasterLanguage
FROM I_PPM_ProjectSummaryTask AS Project
INNER JOIN I_PPM_User AS User ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_Text AS NameUserLanguage ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_ProTypeText AS ProTypeName ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_ProTypeText AS TypeNameMasterLanguage ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_IsMyProject AS IsMyProject ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_IsMyProjectAsSubstitute AS IsMyProjectAsSubstitute ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_ProjectResponsible AS _ProjectManager ON ( ( _ProjectManager.ProjectUUID = ProjectUUID ) AND ( _ProjectManager.BusinessPartnerUUID = MyBusinessPartnerUUID ) )  -- association [0..1]
LEFT OUTER JOIN I_PPM_Substitute AS _Substitute ON ( ( _Substitute.ReferencedObjectUUID = ProjectSummaryTaskUUID ) AND ( _Substitute.SubstituteUser = $session.user ) )  -- association [0..1]
LEFT OUTER JOIN I_PPM_AuthznByUsrH AS _AuthUser ON _AuthUser.ReferencedObjectUUID = ProjectSummaryTaskUUID AND _AuthUser.UserID = $session.user AND ( _AuthUser.Activity = 'Admin' OR _AuthUser.Activity = 'Write' OR _AuthUser.Activity = 'Read' )  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznBySubstitH AS _AuthSubst ON _AuthSubst.ReferencedObjectUUID = ProjectSummaryTaskUUID AND _AuthSubst.UserID = $session.user AND ( _AuthSubst.Activity = 'Admin' OR _AuthSubst.Activity = 'Write' OR _AuthSubst.Activity = 'Read' )  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznByUserRoleH AS _AuthRole ON _AuthRole.ReferencedObjectUUID = ProjectSummaryTaskUUID AND _AuthRole.UserID = $session.user AND ( _AuthRole.Activity = 'Admin' OR _AuthRole.Activity = 'Write' OR _AuthRole.Activity = 'Read' )  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznByUsrGrpH AS _AuthGroup ON _AuthGroup.ReferencedObjectUUID = ProjectSummaryTaskUUID AND _AuthGroup.UserID = $session.user AND ( _AuthGroup.Activity = 'Admin' OR _AuthGroup.Activity = 'Write' OR _AuthGroup.Activity = 'Read' )  -- association [0..*]
;