cancel
Showing results for 
Search instead for 
Did you mean: 

Link between DPR_PROJECT and DPR_TASK

Former Member
0 Kudos

Hi all,

Is there anyway we could link dpr_project and dpr_task. I want to address a business objects reporting need which lists all the tasks grouped under individual projects. I would ideally want to report off directly from the tables from a performance standpoint. The system is configured in such a way that some of the projects/task attributes are stored in cgpl_project, however i am not able to figure out any direct relationship between project and task tables. Look forward to your inputs on this.

Thanks

Vinayak

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Vinayak,

In terms of database, you can go through CGPL_HIERARCHY table:

- from the task GUID ==> field "project_guid" stands for the phase GUID (I admit this naming is quite strange).

- then from the phase GUID ==> field "project_guid" stands for the project GUID.

BR

Matthias

Former Member
0 Kudos

Hi Matthias,

I have a similar requirement. I got the CGPL Tasks from Project using CGPl_HIERARCHY. But the problem is I need some task attributes in DPR_TASK and I found no relation between CGPL_TASK and DPR_TASK.

Appreciate your help.

Regards,

Sri

Former Member
0 Kudos

Hi Sri,

The link between CGPL_TASK & DPR_TASK is done through the field: GUID.

BR

Matthias

Former Member
0 Kudos

Hi Matthias,

Here is what I observed.

1) Every task in DPR_TASK doesnt have a corresponding task in CGPL_TASK.

2) CGPL_HIERARCHY doesnt have tasks from all Projects.

Is there a condition for a task to be stored in CGPL_HIERARCHY?

Thanks,

Vasu