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: 

Table to find SAP QUERY and its Generated Program

Former Member
0 Kudos

Hi,

Can yo please suggest the table where SAP Query and its generated program are stored . Thanks

Ry

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Switch on the trace ST05 on the screen of SQ01 . give name of query and press enter.

Switch of the trace and search for database tables.Some analysis will be required to get the table.

Now, do where use list of thiese tables and find the program.

3 REPLIES 3

Former Member
0 Kudos

the table would be TRDIR (header). you find the name of the generated code of the query in SQ01---> Query ---> More functions ---> Display Report Name.

SuhaSaha
Advisor
Advisor
0 Kudos

Hello,

Most of the FMs related to ABAP Query can be found in the function group AQGF. (check in SE37 with RSAQ*)

Please check the available FMs & check which one fits the bill.

Also i found 2 tables which might interest you: AQLDB & AQGDB.

BR,

Suhas

Former Member
0 Kudos

Switch on the trace ST05 on the screen of SQ01 . give name of query and press enter.

Switch of the trace and search for database tables.Some analysis will be required to get the table.

Now, do where use list of thiese tables and find the program.