PROJECTS - ROLES - EMPLOYEE Relationship

[fabio_bellocchio]

Hi SDN,

please, I need to select a list of Projects from DPR_PROJECT database table, based on the employee that is assigned to a certain ROLE (in this case this will be a pre-defined 'X' Role) under the RESOURCES tab.

Please, what are the tables and relationship to achieve this, given the employee name, number or Business Partner number ??

ps.: there will be many entries (Projects) for a given Employee, but only one employee can be assigned to that role in each project.

Thanks for any intent of help..

Regards.

[Former Member · Accepted solution]

Hi

Use table DPR_BUPA_LINK , you will get participant guid which is nothing but project role guid.

Use FM: BAPi_BUS2177_GET_DETAIL:Pass Participant guid ,you will get Resource id and all details.

Regards,

Nitin Bhagat

[fabio_bellocchio · Accepted solution]

Hi Nitin,

problem fixed.

Thank you very much.

Regards.