cancel
Showing results for 
Search instead for 
Did you mean: 

Task and Projects to person responsible maintenance

rhuben007
Explorer
0 Kudos


Hi Experts,

Problem:

I can't find the table or view where SAP PPM maintains the relationship between tasks or projects to person responsible. I already browse from different tables(DPR_PROJECT, DPR_TASK,RPM_FES_MANGER_A) and tried to trace it but I can't.

Objective:

To simplify, I want to build a reports/view that have the following columns:

1st:

Project ID

Project Name

Project Category

Project Type

Person Responsible

2nd:

Task ID

Task Name

Person Responsible

I already found CGPL_TEXT where SAP PPM maintains the information I need like the project and task name. I also found RPM_FES_MANGER_A where the names of person responsible is being maintained along with its RESOURCE_GUID. I just need the table that at least shows the ff. fields.

PROJECT_GUID

RESOURCE_GUID

Thanks a lot,

James

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member201206
Active Contributor
0 Kudos

Hi James,

once you have the entity guid (like project guid or task guid), get the responsible (field PARTICIPANT_GUID) via table DPR_ENTITY_LINK (field RESPONSIBLE = X).

Then get the BUPA_GUID from table DPR_BUPA_LINK.

Using BUPA_GUID, you can then get mor details about the BP.

After certain hotpackage, there is a report dpr_get_tree, which you can retrieve all the relevant database tables of a PPM project. If it is missing, just implement the note 1848890.

Kind regards,

Zhenbo