Skip to Content

How to download the SAP Menu with folder structure

Jun 13, 2017 at 10:44 AM


avatar image
Former Member


I am trying to download 400 transactions in ECC showing the folder they are in such as Material Management>Purchasing>Display Purchase Order. This is to then create generic stream-based display roles but I am struggling somewhat :-)

I've tried the TTREE* tables, TADIR etc for application component (no use), SE43 / S000, SAP1, GRC GRACFUNCACT, SU21 (creepy download format that doesn't convert easily to excel - only to CSV and tried parsing but still a mess). Since I have 400 transactions I am trying to avoid the one by one SEARCH_SAP_MENU option :-).

Can anybody assist please?

Best wishes

David Berry

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

1 Answer

Jurjen Heeck Jun 13, 2017 at 05:06 PM

Hi David,

If you create a role with as much of the menu as possible (no need or a profile) and save it you'll find the structure in just two tables: AGR_HIER and AGR_HIERT. Maybe that'll make it easier to sort out. From AGR_HIER you can recreate the folder tree with fields OBJECT_ID, PARENT_ID and MENU_LEVEL.

Hope this helps,


10 |10000 characters needed characters left characters exceeded