topic Re: Tables in a Query in Application Development and Automation Discussions

Tables in a Query

swaroop_g2 — Wed, 26 Aug 2009 17:58:11 GMT

Hi experts,

can you please let me know how to find out the tables used in a Queries (SQ01, SQVI)...any table or standard report to find it out or Function module? any help is appreciated.

Ganesh

Re: Tables in a Query

Former Member — Wed, 26 Aug 2009 18:01:42 GMT

in sq03. check the infoset of the query...

from there you can see what tables are used.

Re: Tables in a Query

swaroop_g2 — Wed, 26 Aug 2009 20:20:50 GMT

I believe you are refering to SQ02 for infoset and not SQ03.

we have lot of Query names, it will be cumbersome to go into SQ02 for each to identify it, so we are looking for a report or FM or table to identify the tables used in those queries with Query name alone

Hope this clarifies the situation

Re: Tables in a Query

Former Member — Fri, 30 Oct 2009 11:59:40 GMT

Hi Catchganu ,

You can use the following table to get base table used in Infoset.

AQGSCAT (For Gloabl Area Infoset)

AQLSCAT (For Local Area Infoset)

Note: You can find out table name by entering Infoset name , not by Query name.

Hope , these tables will help you

Regards,

Dinesh

Edited by: Dinesh Tiwari on Oct 30, 2009 1:00 PM