Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How to download the SAP Menu with folder structure

former_member997951
Discoverer

‎06-13-2017 11:44 AM

0 Kudos

HI

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

1 REPLY 1

jurjen_heeck
Active Contributor

‎06-13-2017 6:06 PM

0 Kudos

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,

Jurjen