find tables in a t-code

[Former Member]

what is the t-code for finding tables and fields in a particular t-code

[Former Member]

what is the t-code for finding tables and fields in a particular t-code

[Former Member]

Hi,

You can use the transaction ST05..Sql trace..

Steps

Go to ST05 transaction..

Switch on the trace

Execute the t-code for which you have to find tables..

Then come back to ST05..

Switch off the trace..

Press list trace to find the tables used in that transaction..

THanks,

Naren

[Former Member]

Go to SE93 and enter t-code. Take the program name and goto SE80.

Under Dictionary Structures, you can see list of tables.

Thanks,

Santosh

[Former Member]

hi Sunil,

If you are using SAP version below 4.7, you can use transaction SE49, to get the list of tables used in a Transaction (also for program, function module and dialog module).

Else,

->use ST05 to do activate SQL Trace

->execute the transaction

->Deactivate the SQL Trace

->Display Trace ; you will get a list with all the tables used with the corresponding select statements.

Hope this helps,

Sajan Joseph.

[abdul_hakim]

hi

u need to use sql trace(st05) for the same.

Cheers,

Abdul Hakim

[Former Member]

Hi Sunil,

Execute the Transaction <b>'ST05'</b>.

2. start Activate SQL trace .

3. Now execute your transactio.

4. Stop SQL Trace.

[uwe_schieferstein]

Hello Sunil

The function module you are looking for is <b>RS_PROGRAM_TABLES</b>. For example, use

- OBJECT_TYPE = 'TRAN' " transaction

- OBJECT_NAME = 'VA01' " or your transaction

and the function module will return you a very exiting list.

Regards

Uwe

[Former Member]

Hi,

Open the program in SE80 and check the Dictionary node and Fields node.

Regards

Subramanian

[Former Member]

There's really no good way to do this for complex SAP programs. Depending on any number of factors, different tables will be used. ST05 will show you which tables were used for one particular run, but not for all possible ones.

SE80 will show you all tables declared for a program, but the program may call function modules that use tables that it declares itself.

Rob