Link between DPR_PROJECT and DPR_TASK

[Former Member]

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

[Former Member]

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]

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]

Hi Sri,

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

BR

Matthias

[Former Member]

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