How to find all the table used in a report

[Former Member]

Hi Expert ,

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

Thanks in advance

Tarak

[viquar_iqbal]

Hi

try using SQL trace .

Thanks & Regards,

Viquar Iqbal

[Former Member]

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]

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]

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]

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]

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

regards

Sajid

[GauthamV]

Plz SEARCH in SCN before posting.

Use this FM.

GET_TABLES

[Former Member]

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]

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]

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.