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
Showing results for 
Search instead for 
Did you mean: 

How to get a list of SAP queries

Former Member
0 Kudos
4,049

Hi All -

I need to create a list of every custom SAP query we have in our system, as preparation for an upgrade. Is there a way to do this without going through each individual user group?

Your help is appreciated - thanks!

Abby

1 ACCEPTED SOLUTION

Former Member
0 Kudos
1,202

Hi Dywan

You can get all existing SAP queries for each user group from SAP table AQLTQ.

Just open the table in SE11 OR SE16. See the content of table.

Cheers

Bala

Note: Award points if helpful.

6 REPLIES 6

former_member181966
Active Contributor
0 Kudos
1,202

Go to table TRDIR -- and search <b>AQ*</b>

<u><i>Don`t forget to set max no hit = 999999 or SPace</i></u>

Hope this’ll give you idea!!

<b>P.S award the points.</b>

Good luck

Thanks

Saquib Khan

"Some are wise and some are otherwise"

former_member181962
Active Contributor
0 Kudos
1,202

Go to the table:

AQGQDOC or AQLQDOC and query it.

Regards,

Ravi

Former Member
0 Kudos
1,202

Hi

try the FM

<b>RSAQ_READ_QUERY_LISTS</b>

Former Member
0 Kudos
1,202

Hi,

Have a look at table

AQGQDOC

Regards,

Tanveer.

<b>Please mark helpful answers</b>

Former Member
0 Kudos
1,203

Hi Dywan

You can get all existing SAP queries for each user group from SAP table AQLTQ.

Just open the table in SE11 OR SE16. See the content of table.

Cheers

Bala

Note: Award points if helpful.

Former Member
0 Kudos
1,202

AQLTQ solved it. Thanks!