I_PPM_ProjectManager

DDL: I_PPM_PROJECTMANAGER SQL: IPPMPROJMNG Type: view COMPOSITE

Enterprise Project Manager

I_PPM_ProjectManager is a Composite CDS View that provides data about "Enterprise Project Manager" in SAP S/4HANA. It reads from 3 data sources (I_EntProjectEntitlement, I_EnterpriseProjectTeamMember, I_EnterpriseProjectRole) and exposes 4 fields with key field TeamMemberUUID.

3 data source(s) 4 fields

Data Sources (3)

SourceAliasJoin Type
I_EntProjectEntitlement Entitlement inner
I_EnterpriseProjectTeamMember ProjectMember from
I_EnterpriseProjectRole ProjectRole inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPPMPROJMNG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Enterprise Project Manager view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY TeamMemberUUID I_EnterpriseProjectTeamMember TeamMemberUUID
ProjectUUID I_EnterpriseProjectTeamMember ProjectUUID
ProjectManagerUUID I_EnterpriseProjectTeamMember BusinessPartnerUUID
_Project _Project 
@AbapCatalog.sqlViewName: 'IPPMPROJMNG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Enterprise Project Manager'

@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@ObjectModel: {

    usageType: {
      dataClass:       #MIXED,
      serviceQuality:  #C,
      sizeCategory:    #L
    }
}

define view I_PPM_ProjectManager as select from I_EnterpriseProjectTeamMember as ProjectMember
inner join I_EntProjectEntitlement                                        as Entitlement              
            on    Entitlement.ProjectUUID     = ProjectMember.ProjectUUID
             and  Entitlement.TeamMemberUUID  = ProjectMember.TeamMemberUUID

inner join I_EnterpriseProjectRole                                        as ProjectRole              
            on    ProjectRole.ProjectRoleUUID     = Entitlement.ProjectRoleUUID 
             and  ProjectRole.ProjectRoleCategory = 'PM'
{ 
  key ProjectMember.TeamMemberUUID      as TeamMemberUUID, 
      ProjectMember.ProjectUUID         as ProjectUUID,
      ProjectMember.BusinessPartnerUUID as ProjectManagerUUID,
//      ProjectRole.ProjectRoleUUID       as ProjectRoleUUID,

      _Project 
} 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ENTERPRISEPROJECTROLE",
"I_ENTERPRISEPROJECTTEAMMEMBER",
"I_ENTPROJECTENTITLEMENT"
],
"ASSOCIATED":
[
"I_ENTERPRISEPROJECT"
],
"BASE":
[
"I_ENTERPRISEPROJECTTEAMMEMBER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More