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 Data to see the details. This works as long as you are looking at the transparent Table. If the information is populated from a structure, then this will not help you because the structure may be populated from a number of sources including some includes, and may also contain some calculated fields. If the include is in fact a table, then chances are your data comes from that table. Check to see if there is a logical database in the business area you are looking at. Looking at the structure of the logical database often reveals the tables used to drive that business area. Also check to see if the field name you are looking for is in any of the tables. Logical databases can also be useful in determining how tables are linked together.

You may also use other methods (listed below) to zero-in on the field. You can perform any of these, in isolation or in combination, until you find what you are looking for:

• Debugging (/H)
• SQL Trace (ST05)
• Run-time Analysis (SE30)

Start the transaction in Debug mode. Set a watch-point for the structure-field you are interested in. When the debugger breaks, look at the lines just above the break-point. This will show where the field was populated. This may be a structure, in which case you will restart the process using that structure as a watch-point. Turn SQL Trace on, and run your transaction. Switch the trace off, and examine the log. This will detail the tables hit, and the order in which they were hit. Not all tables hit will be displayed; for example, configuration tables tend not to show up, as they are buffered. The Runtime Analysis(SE30) will show all tables accessed by the transaction.

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

1. 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...
2. 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...
3. 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...
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. Characteristics and Value Fields In the operating concern two things are basically defined Characteristics Value Fields Characteristics are nothing but those aspects on which we want to break down the profit logically such as...
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. Add Fields to SAP Table An Append Structure or a customizing include can be used to add fields to the Table. Append structures are created by adding fields to the end of a table while...
8. SAP System Fields SAP System Fields AlphabeticalSAP System Fields Categorised ~ end of post ~ ———————ABAPer, mail: abap.community@gmail.com http://www.erpdb.info...
9. 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...
10. ABAP Programs: Copying fields REPORT ZSOURCE0701. * move fieldsDATA: NAME(25), COUNTER TYPE I.DATA: SOURCE LIKE NAME, TARGET LIKE SOURCE.MOVE: ‘Edison’ TO NAME, 17 TO COUNTER.MOVE SOURCE TO TARGET.* Using the compute command (keyword can...
11. ABAP Programs: Using system fields REPORT ZSOURCE0409. WRITE: / ‘Current date’, SY-DATUM, / ‘Current table index’, SY-TABIX, / ‘Loop counter’, SY-INDEX, / ‘System return code’, SY-SUBRC.———————ABAPer, mail: abap.community@gmail.com http://www.erpdb.info...
12. ABAP Programs: Setting the layout position of fields REPORT ZSOURCE0804. DATA: POS TYPE I, LEN TYPE I. WRITE AT 5 ‘position 5′.POS = 20.WRITE AT POS ‘position 20′.POSITION 40.WRITE ‘position 40′. POS = 10. LEN = 20.NEW-LINE.WRITE AT...
13. ABAP Programs: Converting date fields * Using the built-in calendarDATA: RECEIVING_DATE TYPE D, LAST_ADMISSIBLE_DATE TYPE D. RECEIVING_DATE = ’19980223′.LAST_ADMISSIBLE_DATE = RECEIVING_DATE + 10.WRITE / LAST_ADMISSIBLE_DATE. RECEIVING_DATE = ’19980305′.LAST_ADMISSIBLE_DATE = RECEIVING_DATE + 10.WRITE / LAST_ADMISSIBLE_DATE. RECEIVING_DATE...
14. ABAP Programs: Converting number fields * Using numeric texts and packed numbersDATA: NO_EMPLOYEES(4) TYPE N, NO_ROOMS TYPE P, EMPLOYEES_PER_ROOM TYPE P DECIMALS 2.EMPLOYEES_PER_ROOM = NO_EMPLOYEES / NO_ROOMS. * Rounding with integers and packed numbersDATA: INCOME...
15. 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*...