3437683 - How to retrieve the Project Manager/Responsible person from Enterprise Projects

How to retrieve the Project Manager/Responsible person from Enterprise Projects

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 

SAP S/4HANA Cloud Public Edition

This can be achieved by creating two Custom CDS Views.

First create CDS View A using the following CDS views. In this example CDS View A is called "YY1_BW_EPPM_ProjectManager":

I_EntProjectEntitlement

I_EnterpriseProjectRole

I_EnterpriseProjectTeamMember

Use I_EntProjectEntitlement as the Primary Datasource and then Associated Data sources I_EnterpriseProjectRole &

I_EnterpriseProjectTeamMember. You can also use Associated Datasource I_EnterpriseProject if you want to see the Project ID.

Below are screenshots from an internal system showing the Data sources and the respective Joins:

I_EnterpriseProject Join:

I_EnterpriseProjectRole Join:

I_EnterpriseProjectTeamMember Join:

If you are only interested in Project Manager Role, you can filter on _I_EnterpriseProjectRole.ProjectRoleCategory = PM as shown below:

To be able see the name of the team member you need to create a second Custom CDS View. In this Custom CDS View, YY1_BW_EPPM_ProjectManager must be defined as the Primary Datasource and I_BusinessUserBasic as Associated Datasource:

I_BusinessUserBasic join:

Then expose the relevant fields, for example:

Community Thread : https://answers.sap.com/questions/13460500/project-manager-field-projects.html 

Project Manager, Responsible Person, CDS view, EPPM Project, Project Control, Fetch, SAP S/4Hana Cloud. , KBA , PPM-SCL-STR , Project Structure (Public Cloud) , How To