data tables

[Former Member]

Hello friends,

When I execute any transaction,

for example VA01, how can I find out all the tables that have been updated.

Shejal.

[Former Member]

Use Transaction ST05

It will activate the SQL Trace

Steps

1. Goto ST05 -> Activate Trace

2. Run the Transaction VA03

3. Goto ST05 -> Deactivate Trace

Display Trace list.

You will get the list of all tables updated and the values also

Message was edited by:

Dominic Pappaly

[Former Member]

Hi,

GO to ST05...Switch the SQL trace..

Execute the transaction...

VA01..

Save the order..

Switch off the SQL trace..

List the SQL trace..

You will see the tables used in VA01..

THanks,

Naren

[Former Member]

Thanks Guys,

will try out.

Shejal.

[Former Member]

A couple of things:

ST05 will only show you the tables that were actually updated when you executed the transaction. Depending on you input to the transaction different tables may be updated.

When you look at the results of ST05, most of the results will be from SELECTs. You can narrow your search by doing a find (CTL-F) on 'insert', 'delete' and 'update'.

Rob