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: 

Tables in a Query

swaroop_g2
Explorer

‎08-26-2009 6:58 PM

0 Kudos

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

3 REPLIES 3

Former Member

‎08-26-2009 7:01 PM

0 Kudos

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

from there you can see what tables are used.

swaroop_g2
Explorer
In response to Former Member

‎08-26-2009 9:20 PM

0 Kudos

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

Former Member
In response to Former Member

‎10-30-2009 11:59 AM

0 Kudos

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