Skip to Content
0

Relationship between Project and Phase tables

Feb 10, 2017 at 11:20 PM

89

avatar image

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

regards

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Francesco Pezzoli
Feb 13, 2017 at 11:45 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Miguel Izaguirre
Feb 16, 2017 at 04:53 PM
0

Thanks so much

Share
10 |10000 characters needed characters left characters exceeded