CDS VIEW Project Responsible Person name on SAP Cloud

[clsalerno]

Hi everyone, 
we are trying to insert Project Responsible name on CDS to view all project managers in the report, but the element we add on CDS doesn't actually work. we joint it with the WBSElementBasicData and we opened the element as semantic element with "text", but still doesn't work. 

Does anyone know how to make it work ? 

[OwenLiu]

Added Project tag, please remove tag SAP S/4HANA Cloud Public Edition.

[SaschaZygar]

Hello,

could you please provide more information?

For example: What is the primary data source of your Custom CDS View? Do you have associations? If yes, what are the join conditions?

What is the error message or why exactly doesn't it work?

Thank you,

Sascha

[Omaar]

Hi,

could you please specify if you are requesting the responsible person (Project Manager) in Professional Services projects or Enterprise Portfolio & Project Management projects?

Kind regards,

Omar

[SaschaZygar]

Hello,

please try the following CDS Views:

I_EnterpriseProject

I_EnterpriseProjectTeamMember (Join condition: ProjectUUID)

I_EnterpriseProjectRole (Join condition: ProjectUUID)

You can get the business partner data from I_WorkforcePerson (join with BusinessPartnerUUID).

You can filter for the ProjectRoleName to get only 'Project Managers'.

Best regards,

Sascha

[FRilke]

Hi clsalerno, instead of starting with I_EnterpriseProject use I_EntProjectEntitlement and join the CDS views for team members and roles from above, otherwise you will have false duplicates created from role and team member CDS views. Kind regards Franziska