Skip to Content
avatar image
Former Member

Relationship between Project and Phase tables

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

regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 13, 2017 at 11:45 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 16, 2017 at 04:53 PM

    Thanks so much

    Add comment
    10|10000 characters needed characters exceeded