Community
Application Development and Automation 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: 
Read only

Tables in a Query

swaroop_g2
Explorer

‎2009 Aug 26 6:58 PM

2,182

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
Read only

Former Member

‎2009 Aug 26 7:01 PM

0 Likes
1,628

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

from there you can see what tables are used.

Read only

swaroop_g2
Explorer
In response to Former Member

‎2009 Aug 26 9:20 PM

0 Likes
1,628

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

Read only

Former Member
In response to Former Member

‎2009 Oct 30 11:59 AM

0 Likes
1,628

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