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: 

data tables

Former Member
0 Kudos

Hello friends,

When I execute any transaction,

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

Shejal.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

4 REPLIES 4

Former Member
0 Kudos

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

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

0 Kudos

Thanks Guys,

will try out.

Shejal.

Former Member
0 Kudos

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