C_PPM_MyActiveProjects

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_PPM_MyActiveProjects.
-- 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: CPPMMYACTIVE

CREATE VIEW C_PPM_MyActiveProjects AS
SELECT
  bintohex(ProjectUUID) AS ProjectUUID,
  bintohex(ProjectSummaryTaskUUID) AS ProjectSummaryTaskUUID,
  ProjectSummaryTaskUUID AS ProjectSummaryTaskUUIDRaw,
  bintohex(PortfolioItemUUID) AS PortfolioItemUUID,
  bintohex(PortfolioUUID) AS PortfolioUUID,
  ProjectUUID AS RootObjectUUID,
  ProjectName,
  ProjectNameUserLanguage,
  ProjectNameMasterLanguage,
  Project,
  ProjectTypeName,
  ProjectType,
  CurrentPhaseName,
  CurrentPhaseNameUserLanguage,
  CurrentPhaseNameMasterLanguage,
  CurrentPhase,
  CurrentPhaseEndDate,
  LaunchDate,
  NextMilestoneName,
  NextMilestoneNameUserLanguage,
  NextMilestoneNameMasterLang,
  NextMilestone,
  NextMilestoneDate,
  EPPMSettingsDefaultValue
FROM I_PPM_MyActiveProjects AS Project
LEFT OUTER JOIN I_PPM_AuthznByUsrH AS _AuthUser ON _AuthUser.ReferencedObjectUUID = ProjectSummaryTaskUUIDRaw 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 = ProjectSummaryTaskUUIDRaw 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 = ProjectSummaryTaskUUIDRaw 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 = ProjectSummaryTaskUUIDRaw AND _AuthGroup.UserID = $session.user AND ( _AuthGroup.Activity = 'Admin' OR _AuthGroup.Activity = 'Write' OR _AuthGroup.Activity = 'Read' )  -- association [0..*]
LEFT OUTER JOIN E_PPM_Project AS _Extension ON _Extension.ProjectUUID = Project.ProjectUUID  -- association [1..1]
;