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.

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

1. Find the Fields or Tables accessed for a Transaction A common way to find the technical data underlying a transaction is to place your cursor in the field, press the key F1, and then click on the button Technical...
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 HEADER...
3. 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 tableSELECT...
4. Transaction Code to Access Other Transaction Code with Values Many times in SAP, you may come across situations where in the users wants to have a separate transaction codes for some of the tables which can be easily maintained...
5. How to find OK Codes Goto menu bar in that System –> Status click Gui Status Expand all the nodes inside u will get all Function Code/ ok code for icons inside the in GUI...
6. Find User Exits Well, I know we have already talked about finding user exits in the program and also we have a program to find out the user exits in a given Program/Transaction....
7. Find Out Who Transported The Transport Request Look at Table TPLOG (go there using the Transaction Code SE16) and input the transport name in the CMDSTRING field with *. Example: *UZDK939001*...
8. FIND: ABAP Keyword a Day FIND:  Searches for patterns. FIND <p> IN [SECTION OFFSET <off> LENGTH <len> OF] <text> [IGNORING CASE| RESPECTING CASE] [IN BYTE MODE|IN CHARACTER MODE] [MATCH OFFSET <0>] [MATCH LENGTH <l>]. The...