Retrieve responsible resources for a role in cProjects

[Former Member]

Hey all,

I would like to display a list of assigned/unassigned resources corresponding to a role for tasks grouped under individual projects. I am not sure how I can find a relationship between the roles and resources using the tables. It would be really helpful if you could give some pointers on how I can approach this issue.

Thanks

Vin

[former_member201206]

Hi

Please check, if the report DPR_GET_ALL_PROJECT_ROLES available in your system or not, it is delivered by a hotpackage.

Otherwise, you can use the selections direct of the tables, briefly it should be like following.

dpr_project : get the guid of the project

cgpl_hierarchy. using project = guid, object_type = MTG, you get all roles of the project.

dpr_part : details about the roles.

dpr_bupa_link: assigned business part guid.

KInd regards,

Zhenbo

[Former Member]

Hi Vin,

Have you tried "evaluations" for Project Roles and Proj. Role Staffing, layout 0_PROJ_RES_PART1.

It displays Project wise Roles & role wise staffing.

Regards

Sejo