Skip to Content
Former Member
Former Member
February 5, 2015 Less than a 1 minute read

dpr_get_tree report

Follow RSS feed
0 Likes 29 Views 3 Comments

HI collegues.

I ve implemented report DPR_GET_TREE, that was awesome

After using have questions, could you help me.

For example, I am interested in how report could find records:

– in the table DPR_BUPA_LINK, using as object of search Project GUID

– in the table DPR_PART, using as object of search Project GUID

BR, Alexey

Assigned tags

Related Blog Posts

    Related Questions

      3 Comments
      You must be Logged on to comment or reply to a post.
      • Zhenbo Wang

        Hi Alexey,

        thanks for your comments. I am happy to known, that you like this report.

        The report retrieves the structure hierarchy at first. If you enter a project guid, all the guids of the project elements  (which you see at the structure view after expand all ) + all the roles and their staffing.  The table cgpl_hierarchy is used to get this information.

        After all the structure  elements are known, then other tables are selected using primary key or foreign key. Often using  statement ‘  …. for all entries in  lt_heirarchy. ‘

        DPR_BUPA_LINK & DPR_PART are retrieved in this way.

        P.S: do you known, if you donot enter anything, the last-used project is used.

        Kind regards,

        Zhenbo

        • Former Member Post author

          Hi Zhenbo.

          Thanks for your answer.

          I ve decided that it is CGPL_ENTITY table, where CGPL_ENTITY-OBJECT_TYPE = ‘MTG’, CGPL_ENTITY-PROJECT_GUID=GUID of Project, consist DPR_PART-GUIDS as CGPL_ENTITY-CGPL_GUID. Unfortunatelly i did not find key in the CGPL_HIERARCHY.

          BR, Alexey.