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
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
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.
Hi Alexey,
if you use the cgpl_entity, it would be O.K too.
Kind regards,
Zhenbo