Relationship between Project and Phase tables

[former_member263679]

Hi everyone, I would like to know which is the table or field to find the relationship between Project, phases and tasks

regards

[former_member263679]

Thanks so much

[francesco_pezzoli]

Hello Miguel,

The project hierarchy information is contained in table CGPL_HIERARCHY. In addition to this there are some other fields in other tables which contain some basic hierarchy information redundantly.

The exact nature of the information in CGPL_HIERARCHY depends on which object you are looking at and what the project structure is. E.g. take the example of a task which is assigned to a phase and which has sibling tasks and subtasks:

The entry in table CGPL_HIERARCHY for the task GUID contains the following information:

• CGPL_HIERARCHY-UP contains the phase GUID
• CGPL_HIERARCHY-PROJECT-GUID also contains the phase (not project!) GUID
• CGPL_HIERARCHY-LEFT_NODE and CGPL_HIERARCHY-RIGHT_NODE contain the GUIDs of the immediate sibling tasks
• CGPL_HIERARCHY-DOWN contains the GUID of one of the subtasks

If you look at table CGPL_HIERARCHY for the phase GUID you will find:

• CGPL_HIERARCHY-UP contains the project header GUID
• CGPL_HIERARCHY-DOWN contains the GUID of one of the assigned tasks

If you now look at the subtask which is assigned to the aforementioned task below the phase, the entry in table CGPL_HIERARCHY for this task GUID contains the following information:

• CGPL_HIERARCHY-UP contains the superior task GUID
• CGPL_HIERARCHY-PROJECT-GUID contains the phase GUID

If you want to familiarize yourself with this data I would recommend that you use standard program DPR_GUID_ANALYZE in SE38. Select with e.g. the task GUID. Look at the entries in table CGPL_HIERARCHY which reference this task and use the forward-navigation functionality (by clicking on any GUID) to then look at the same information for the related objects.

Regards

Francesco