table name of a tcode

[Former Member]

how to find out the table name of a tcode

for example rz03 the values it displays is selected from a particular table how to find this table name for rz03

similarly for any tcode how to find the table name that is queried to display the output

[Former Member]

for rz03 the program name is SAPMSSY0

the output of rz03 has 4 field names with few rows of data

from se38 when i viewed the source code for this program there are 2 select statements when i viewed these 2 tables from se16 the field names do not match with the 4 field names of the output from rz03

using the field names is there another way to find out the data inside these field names by executing an sql query or through a tcode

[Former Member]

With an SQL trace with ST05, it takes 30 seconds to find out that operation modes are stored in table BTCOMSET.

Regards,

Olivier

[Former Member]

Hello,

Just give a try like below...

1. Execute RZ03 and find the program name from the right-bottom corner of the screen.

2. Take a look at source code of that program from SE38. You should be able to find the table name.

Hope it helps.

Thanks,

Siva Kumar

[Former Member]

Hi,

Most of the time there is not a single table involved for a transaction but many of them.

If you want to know which tables you can use an SQL trace from transaction ST05.

You can also display the abap source code and try to find out.

Regards,

Olivier