Skip to Content

Task and Projects to person responsible maintenance


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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 08, 2015 at 04:06 PM

    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


    Add comment
    10|10000 characters needed characters exceeded