on 01-06-2015 7:41 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
7 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.