topic Table to find SAP QUERY and its Generated Program in Application Development and Automation Discussions

Table to find SAP QUERY and its Generated Program

Former Member — Wed, 18 Nov 2009 14:29:43 GMT

Hi,

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

Re: Table to find SAP QUERY and its Generated Program

Former Member — Wed, 18 Nov 2009 14:51:20 GMT

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.

Re: Table to find SAP QUERY and its Generated Program

SuhaSaha — Wed, 18 Nov 2009 15:09:08 GMT

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

Re: Table to find SAP QUERY and its Generated Program

Former Member — Wed, 18 Nov 2009 16:39:20 GMT

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.