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.

If you like this post, you may as well like these too:

1. ABAP Programs: Using internal tables as snapshots of database tables REPORT ZSOURCE1103.* Work area for a database tableTABLES CUSTOMERS.* Internal tableDATA ALL_CUSTOMERS LIKE CUSTOMERS OCCURS 100 WITH HEADER LINE.* Filling the internal table with all entries of the database...
2. Source Code: Working with database tables and internal tables REPORT ZSOURCE0103. * Declaration of a work area for a Dictionary tableTABLES CUSTOMERS. * Internal table used as snapshot of the database tableDATA ALL_CUSTOMERS LIKE CUSTOMERS OCCURS 100 WITH...
3. SAP Tips: Change Database tables directly SAP being a very robust system has some flaws.. maybe they kept it intentionally so that we can play with it. Anyways, As far as i know there are...
4. Transaction variant A Transaction Variant is a set of screen variants that is used to predefine the screen behavior and defaults. Fields, Sub screens and full screens that may not be...
5. Transaction FAQs Transaction Frequently Asked Questions (FAQs) 1. What is a transaction? - A transaction is dialog program that change data objects in a consistant way. 2. What are the requirements...