How To Find The Tables For The Given Transaction?

There is a very easy way to find out all the tables related to a given transaction. Suppose you want to know the list of tables used when you create Sales Order or Purchase Order. How can we achive it? How to we track the list of all the tables use by SAP?

There is a very easy trick which will help you achieve that? It’s SQL trace. just start ST05 and and start the SQL trace and go to any transaction and do any activity and let the document get saved. Now again go to SQL trace screen and stop the SQL trace and then click on display SQL trace that’s it. It will show you the list of all the tables which have been accessed or updated.