Table for Resource Assigned to Project in PPM

[Former Member]

Hi guys,

Can you please suggest standard tables where PPM data save & table where i can find resource assigned to one project.

[Brendan_Ward · Accepted solution]

Hello Gaurav,

Please check this thread for the details:

http://scn.sap.com/thread/3480645

Best Regards,

Brendan

[Former Member]

Hi Zhenbo / Brendan,

Sorry for such a delayed response from my end.

I have tried to find resource through your logic dpr_get_tree but i need to submit logic in BW development where these method will not work. From table connectivity or from data-sources it may be achieved.

Could you please mention tables in sequence i should execute to reach at Business Partner. Post that as mentioned in the link given by Brendan, I may find resource first name / last name.

I have GUID of a Item. Please suggest me how should i proceed now.

Regards

Gaurav Ahuja

[former_member201206]

Run the report dpr_get_tree with your project ID,

Then double click of the DPR_BUPA_LINK,  the column ' Business Partner GUID' contains all the guid of resouces of this project.

Kind regards,

Zhenbo

[Former Member]

Hi Zhenbo,

I should execute with report dpr_get_tree with Project Definition ( project id ) ?? Is my understanding correct here ?

[Former Member]

Actually I am very new in PPM, I mainly support PS projects. Could you please guide me standard table details of PPM like GUID, Object link etc ? or specify main tables where i cant find the basic data of PPM & way to extract that data..

[former_member201206]

Yes, that is correct.

After the run the report, you get all the database tables in cProject  listed.