topic Re: find tables in a t-code in Application Development and Automation Discussions

find tables in a t-code

Former Member — Mon, 22 Jan 2007 18:01:52 GMT

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

Re: find tables in a t-code

Former Member — Mon, 22 Jan 2007 18:03:38 GMT

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

Re: find tables in a t-code

Former Member — Mon, 22 Jan 2007 18:10:50 GMT

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

Re: find tables in a t-code

Former Member — Mon, 22 Jan 2007 18:36:46 GMT

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.

Re: find tables in a t-code

abdul_hakim — Mon, 22 Jan 2007 18:56:33 GMT

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

Cheers,

Abdul Hakim

Re: find tables in a t-code

Former Member — Mon, 22 Jan 2007 19:42:42 GMT

Hi Sunil,

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

2. start Activate SQL trace .

3. Now execute your transactio.

4. Stop SQL Trace.

Re: find tables in a t-code

uwe_schieferstein — Mon, 22 Jan 2007 20:32:01 GMT

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

Re: find tables in a t-code

Former Member — Mon, 22 Jan 2007 20:33:19 GMT

Hi,

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

Regards

Subramanian

Re: find tables in a t-code

Former Member — Mon, 22 Jan 2007 20:37:15 GMT

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