Join DPR_TASK and DPR_PROJECT

[Former Member]

Dear Experts,

I need to know how to get a link between the tables DPR_TASK and DPR_PROJECT. If I have a Project ID or a Project GUID, I want to know which data in DPR_TASK belongs to that project. I tried to find the association, but I was not able...These GUIDS make me crazy...

I tried to get the join over the table CGPL_TASK, but I think that not for every entry of DPR_TASK exists an entry in CGPL_TASK.

Where is the link? Or does anybody know a bapi to get all tasks out of a project?

Thanks a lot!

Best regards,

Ingmar

[Former Member]

Hi Ingmar,

Two options there:

For a join link, you can use table CGPL_HERARCHY.

In an ABAP report, you can use BAPI: 'BAPI_BUS2172_GET_TREE'. It retrieves the entire project structure including phases, tasks, checklists...

BR

Matthias