Skip to Content

How to download the SAP Menu with folder structure


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

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Posted on 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,


    Add comment
    10|10000 characters needed characters exceeded