Please provide a program or fm to find a table in transaction

[Former Member]

Please provide a program or fm to find a table in transaction

tell me some methods

[Former Member]

You can use WHERE-USED-LIST.

Thanks

[Former Member]

Vijay,

If you want to know the tables gets effected in a transaction,

then you can do an sql trace in ST05 and checkout that

if you want to know the table associated with the screen field , then chk if this blog helps

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

[Former Member]

Try using ST05, which lists all database tables used in the transaction.

Go to transaction ST05

Push the button "Activate Trace".

Start transaction XXX in a new GUI session.

Go back to the Performance trace session .

Push the button "Deactivate Trace".

Push the button "Display Trace".

The displayed trace will show you the list of tables used in the transaction XXX

[Former Member]

hi

good

try with tcode se49.

thanks

mrutyun^

[Former Member]

"1st

This is the Table name : D010TAB

Execute the table in se16 , give your Program name it will list all Tables used in this Program .

or else

"2nd

Function Module : GET_TABLES .

Execute this FM in SE37 , give your Program name it will list all Tables used in this Program .

"3rd

This is the Program which will give you the List of tables used in your Program .

REPORT ztesttables.


DATA line(100) TYPE c .
DATA:itab TYPE TABLE OF line,
wa_tab LIKE LINE OF itab.
PARAMETER program TYPE sy-repid.


CALL FUNCTION 'GET_TABLES'
EXPORTING
progname = program
TABLES
tables_tab = itab.
SORT itab BY line.
DELETE ADJACENT DUPLICATES FROM itab COMPARING line.

LOOP AT itab INTO wa_tab.
WRITE wa_tab-line.
ENDLOOP.

Reward points if it is usefull ...

Girish

[Former Member]

Hi Vijay,

This is easy and simple method which I am going lay down below, just follow the steps.....

First go to SE93 trasaction and enter your trasaction code there...

Secondly just display and see the program name.

Thirdly just copy that program.

Forthly Go to Trasaction SE80, Select Program and paste that program name below..

Fiftly just display the same... Then dropdown the tree of that program...then you will find option " Dict. Structures"..

Here you can find the tables which has been you for that transaction......

To go to this process there are some other ways you can reach to the tables.....

Please let me know any other help with this regards......

If it helps please reward..

cheers,

Sagun Desai......