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: 

How to find all the table used in a report

Former Member
0 Kudos

Hi Expert ,

Is there is any program to find out all the tables which are used in a perticular report .

Thanks in advance

Tarak

10 REPLIES 10

viquar_iqbal
Active Contributor
0 Kudos

Hi

try using SQL trace .

Thanks & Regards,

Viquar Iqbal

Former Member
0 Kudos

WHy you need program.

You can simply search for the TABLES statement in the report.

Also search FROM statement. It will display all the queries showing the different tables.

For Module Program You have to check for TOP Include to access al the tables.

Regds,

Anil

former_member555112
Active Contributor
0 Kudos

Hi,

Go to SE38.

Type in the program and from the menu select Utilities->Environmental Analysis.

From here you can find out all the data dictionary objects used in the report.

Regards,

Ankur Parab

Former Member
0 Kudos

Hi Tarak ,

There is a tab which tell Display Object List (cntrlshiftF5) when you enter into the program code using se38 there you can find the tree in which everything you have used is shown.

Regards,

Midhun Abraham

Former Member
0 Kudos

Hi Tarak,

Go to t-code SE38

IN your program find for key SELECT .

you will get all the tables used in your program.

Regards,

Vijay

shaik_sajid
Active Contributor
0 Kudos

open the report in se80 and in the left side u can see dictionary tables used.

regards

Sajid

GauthamV
Active Contributor
0 Kudos

Plz SEARCH in SCN before posting.

Use this FM.

GET_TABLES

Former Member
0 Kudos

Hi,

To see the table names used in program,

1) Go to SE38

2) Enter the name of the program and ckick on display button

3) Click on "Display Object List" (CtrlShiftF5)

4) From the tree displayed, expand "Dict. Structures" link to view all data base objects used.

Hope this will help you.

Regards,

Deepa Kulkarni

matt
Active Contributor
0 Kudos

Well, so far Viquar Iqbal has given the only really correct answer - use SQL trace. The reason the others are incomplete, is because they don't consider that a report might call a function module or a class method that accesses a table. In fact, for many applications this is exactly what happens - db accesses are abstracted away from the main program.

The other alternative to SQL trace is to use Run Time Analysis. The advantage of SQL trace is that it shows the tables hit in order.

matt

Former Member
0 Kudos

But SQL trace can also miss something c'ause the program maybe can work with different tables depending on the parameters....

I think it's better to check all this if you want to be completely sure.