project ID and project name field linking to person allocated

[gautam_totekar]

HI

I need tables fr project ID and project name.. I got these names CGPL_TEXT and DPR_PROJECT..

My problem is I am using But000 and DPR_BUPA_LINK tables to get the names of people who are hard and soft allcoated to projects. I am unable to link thye project ID and Project name fields with Person allocated to this project. Is theer any such table or relation??

please help.

[Former Member · Accepted solution]

Hi!

You have to check the project role as well.

The BP is staffed to a role, the role is belonging to a project.

In table DPR_BUPA_LINK, you can get the role from the BP.

In table CGPL_HIERARCHY, you can find the project from the role.

BR

Matthias

[Former Member]

Anyway, I will recommend you to check the classes implemented for cProjects. I think you can use them to retrieve information much more easily...

[Former Member]

I fully agree with this comment. Standard classes/methods are very usefull and intuitive.

Matthias