how to find data base tables for a particular trancation code

[Former Member]

Dear All,

Is there any T.code for finding data base tables used in a particular transaction code(Eg.: MM01).

Regards,

Satyapalli

[Former Member]

Hi,

Here is the blog which explains you very clearly with the screen shots

/people/community.user/blog/2006/12/29/useful-tips-to-find-out-the-table-for-screen-field

Regards

Sudheer

[Former Member]

Thanks for your response

At one shot i want to find all tables used in particular T.code with out going to program. Any T.code is there for this.

Regards,

Satyapalli

[Former Member]

Enter the transaction. From menu System->Status find out the program name. Double click it. You will find the names of tables in some top includes or double click the program and put tables in the find icon.you will get all the tables used in the transaction.

Regards,

Mallick

[Former Member]

Thanks for your response

At one shot i want to find all tables used in particular T.code with out going to program. Any T.code is there for this.

Regards,

Satyapalli

[Former Member]

hi,

Activate the SQL trance (Transaction code ST05) then run the transaction code, then come back to ST05 then deactivate then analyze the trance, then you will find the tables

• Reward the ponints then close the thread

Regards

Sudheer

[uwe_schieferstein]

Hello Satya

There is a very useful function module available for your requirement:

<b>RS_PROGRAM_TABLES</b>

Call this function module using:

OBJECT_TYPE  = 'TRAN'       " transaction
OBJECT_NAME = 'VA01'
" PROGRAM  -> not required
MONITOR_ACTIVATE = 'X'

The function module will list you all DB tables touched by the transaction and shows whether they are read or updated (unfortunately, on ECC 5.0 this seems to be no longer the case. All tables are displayed as READ).

Regards

Uwe