Problem solve Get help with specific problems with your technologies, process and projects.

More on- Finding underlying data in a transaction

More on how to find underlying data in a transaction.

Response to tip "Find data underlying a transaction"

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.


This was last published in June 2001

Dig Deeper on SAP Basis administration and NetWeaver administration

PRO+

Content

Find more PRO+ content and other member only offers, here.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close