Tables updates correspond to a transaction run or document posted.

[former_member195427]

Hi Experts,

                For any transaction run or a document posted, we found the entry in one or more tables. So , is there any way to check how many tables are getting updated with each entry or a transaction post.

Please suggest..

Thanks & Regards

Ankur

[Former Member · Accepted solution]

I think it is bit difficult to track how many tables get updated when you post a transaction.

However one method for checkming the same is to see how many times UPDATE statement is appearing in the program code for that concerned transaction.

Regards,

Mahendra

[former_member195427]

Hi All,

        The way is t-code ST05. Path is as follows:

In few words

1. In ST05 activate SQL trace

2. Perform all required actions

3. In ST05 deactivate and view trace

You get all sql statements performed on database level for activated period of trace. For more information search for ST05 on help.sap.com

Closing the thread.

Regards

Ankur

[Former Member]

Hi Ankur,

Check with your Basis guys, they can enable trace for a transaction and you will come to know which tables are hit. Why you want this info

Regards

Shrikant

[former_member195427]

Hi Shrikant,

                Not to serve any specific purpose . Just a random query..

Regards

Ankur

[Former Member]

I think it is bit difficult to track how many tables get updated when you post a transaction.

However one method for checkming the same is to see how many times UPDATE statement is appearing in the program code for that concerned transaction.

Regards,

Mahendra