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: 

Tables used in a SAP Query

Former Member
0 Kudos
1,031

Hi,

Can anyone tell me in which table the tables used in a query will store?

In general we create a Query by joining tables and I want to know in which table we can find all the tables used in that query?

Help me in this regard...

Thanks

Srini.

4 REPLIES 4

Former Member
0 Kudos
175

Hi,

The query will generate a program with the select statements and with joins..

Those information will not be stored in tables..

Thanks

Naren

gopi_narendra
Active Contributor
0 Kudos
175

Table Name : DD02L contains all the tables

Goto Transaction code SE11 --> give the table name as DD02L

Regards

Gopi

Former Member
0 Kudos
175

Srinivas,

After you execute the SQ01 goto SE38,that query program name will come automatically.press display button(F7).There check the "Tables :" key word there you will find .

Don't forget to mreward if useful.....

0 Kudos
175

Hi Murali,

let me clear my requirement....

Suppose I created a query with name 'TEST' and I used the tables 'EKPO and EKKO' in that query...

Now I want to create report in which the query name is the input field ..and if I input the query name as 'TEST'...the output should show the table names as 'EKPO and EKKO'...

Thanks

Srini