topic data tables in Application Development and Automation Discussions

data tables

Former Member — Fri, 01 Dec 2006 16:30:28 GMT

Hello friends,

When I execute any transaction,

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

Shejal.

Re: data tables

Former Member — Fri, 01 Dec 2006 16:31:20 GMT

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

Re: data tables

Former Member — Fri, 01 Dec 2006 16:31:58 GMT

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

Re: data tables

Former Member — Fri, 01 Dec 2006 16:38:35 GMT

Thanks Guys,

will try out.

Shejal.

Re: data tables

Former Member — Fri, 01 Dec 2006 16:40:23 GMT

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