C_PPM_MeAsSubstituteProjOVP

DDL: C_PPM_MEASSUBSTITUTEPROJOVP SQL: CPPMMEASSUBOVP Type: view CONSUMPTION
32 Fields 1 Data Sources 4 Associations

My Projects - As a Substitute (OVP)

C_PPM_MeAsSubstituteProjOVP is a Consumption CDS View that provides data about "My Projects - As a Substitute (OVP)" in SAP S/4HANA. It reads from 1 data source (I_PPM_MeAsSubstituteProjects) and exposes 32 fields with key field ProjectUUID. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PPM_MeAsSubstituteProjects I_PPM_MeAsSubstituteProjects from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_PPM_AuthznByUsrH _AuthUser _AuthUser.ReferencedObjectUUID = $projection.ProjectSummaryTaskUUIDRaw and _AuthUser.UserID = $session.user and ( _AuthUser.Activity = 'Admin' or _AuthUser.Activity = 'Write' or _AuthUser.Activity = 'Read' )
[0..*] I_PPM_AuthznBySubstitH _AuthSubst _AuthSubst.ReferencedObjectUUID = $projection.ProjectSummaryTaskUUIDRaw and _AuthSubst.UserID = $session.user and ( _AuthSubst.Activity = 'Admin' or _AuthSubst.Activity = 'Write' or _AuthSubst.Activity = 'Read' )
[0..*] I_PPM_AuthznByUserRoleH _AuthRole _AuthRole.ReferencedObjectUUID = $projection.ProjectSummaryTaskUUIDRaw and _AuthRole.UserID = $session.user and ( _AuthRole.Activity = 'Admin' or _AuthRole.Activity = 'Write' or _AuthRole.Activity = 'Read' )
[0..*] I_PPM_AuthznByUsrGrpH _AuthGroup _AuthGroup.ReferencedObjectUUID = $projection.ProjectSummaryTaskUUIDRaw and _AuthGroup.UserID = $session.user and ( _AuthGroup.Activity = 'Admin' or _AuthGroup.Activity = 'Write' or _AuthGroup.Activity = 'Read' )

Annotations (21)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CPPMMEASSUBOVP view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label My Projects - As a Substitute (OVP) view
UI.headerInfo.imageUrl ProjectImageURL view
UI.headerInfo.typeName Project view
UI.headerInfo.typeNamePlural Projects view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.label Project ID view
UI.headerInfo.description.value Project view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.label Project Name view
UI.headerInfo.title.value ProjectName view
Metadata.allowExtensions true view
Consumption.semanticObject EnterpriseProject view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID
ProjectSummaryTaskUUID
PortfolioItemUUID
PortfolioUUID
RootObjectUUID ProjectUUID Project UUID
ProjectSummaryTaskUUIDRaw ProjectSummaryTaskUUID Entity GUID
LaunchDate LaunchDate
ProjectManager ProjectManager Busn. Partner
NextMilestoneDate NextMilestoneDate
NextMilestoneName NextMilestoneName
NextMilestoneNameUserLanguage NextMilestoneNameUserLanguage Object name
NextMilestoneNameMasterLang NextMilestoneNameMasterLang
NextMilestone NextMilestone SRM Reference
CurrentPhaseEndDate CurrentPhaseEndDate
CurrentPhaseName CurrentPhaseName
CurrentPhaseNameUserLanguage CurrentPhaseNameUserLanguage Object name
CurrentPhaseNameMasterLanguage CurrentPhaseNameMasterLanguage
CurrentPhase CurrentPhase SRM Reference
Project Project Project ID
ProjectName ProjectName Project Description
ProjectNameUserLanguage ProjectNameUserLanguage
ProjectNameMasterLanguage ProjectNameMasterLanguage
ProjectTypeName ProjectTypeName
ProjectType ProjectType Project Type
ProjectImageURL ProjectImageURL
BusinessPartnerUUID BusinessPartnerUUID UUID
EPPMSettingsDefaultValue EPPMSettingsDefaultValue
_BusinessUser _BusinessUser
_AuthUser _AuthUser
_AuthSubst _AuthSubst
_AuthRole _AuthRole
_AuthGroup _AuthGroup

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_MeAsSubstituteProjOVP.
-- 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: CPPMMEASSUBOVP

CREATE VIEW C_PPM_MeAsSubstituteProjOVP AS
SELECT
  bintohex(ProjectUUID) AS ProjectUUID,
  bintohex(ProjectSummaryTaskUUID) AS ProjectSummaryTaskUUID,
  bintohex(PortfolioItemUUID) AS PortfolioItemUUID,
  bintohex(PortfolioUUID) AS PortfolioUUID,
  ProjectUUID AS RootObjectUUID,
  ProjectSummaryTaskUUID AS ProjectSummaryTaskUUIDRaw,
  LaunchDate,
  ProjectManager,
  NextMilestoneDate,
  NextMilestoneName,
  NextMilestoneNameUserLanguage,
  NextMilestoneNameMasterLang,
  NextMilestone,
  CurrentPhaseEndDate,
  CurrentPhaseName,
  CurrentPhaseNameUserLanguage,
  CurrentPhaseNameMasterLanguage,
  CurrentPhase,
  Project,
  ProjectName,
  ProjectNameUserLanguage,
  ProjectNameMasterLanguage,
  ProjectTypeName,
  ProjectType,
  ProjectImageURL,
  BusinessPartnerUUID,
  EPPMSettingsDefaultValue
FROM I_PPM_MeAsSubstituteProjects
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..*]
;

Learn More