Skip to Content
Author's profile photo Former Member

dpr_get_tree report

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

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Zhenbo Wang
      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

      Author's profile photo Former Member
      Former Member
      Blog 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.

      Author's profile photo Zhenbo Wang
      Zhenbo Wang

      Hi Alexey,

      if you use the cgpl_entity, it would be O.K too.

      Kind regards,

      Zhenbo