Response to tip "Find data underlying a transaction"
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
An easy way often overlooked: as structures are often used to display lists of items, there is often a detail screen available by double clicking on the line. The detail screen frequently gives a direct table reference (using F1 tech info) to some of the fields on the detail screen, which in turn often indicate where to find the field you were initially trying to identify.
Another possible and easy way. If you have the field name or data element name from Help tech.info.:1. Using SE80, select 'dictionary objects' under 'single object' and select 'edit'. 2. Select 'data element' and enter the data element name from the technical info screen. Click on the eye-glasses (F7). This will display information about the field. 3. Click on the 'where-used-list' (Ctrl, shift, F3) and, in the drop down box, select table fields.
The resulting screen is a list of all the tables where the field occurs. While this does not identify which table the data was obtained from, it is usually not difficult to guess which one was actually used, and may well give a useful indication about which other tables contain related data (which is often what I'm looking for as an auditor).
Yet another way is to inspect the program code. The program name is identified in F1 tech info. Again using SE80, selecting Object List -- Program, and entering the program name, then selecting the 'display' button. Expanding the 'dictionary structures' will list (among other things) all the tables used in the program. Of course, this can be combined with the method above to narrow down the possible sources.