Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

how to find data base tables for a particular trancation code

Former Member
0 Kudos
137

Dear All,

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

Regards,

Satyapalli

6 REPLIES 6

Former Member
0 Kudos
77

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

0 Kudos
77

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
0 Kudos
77

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

0 Kudos
77

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
0 Kudos
77

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
Active Contributor
0 Kudos
77

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