Find Table Fields When All Else Fails

  • by John Jordan, ERP Corp
  • February 15, 2008
Learn a failsafe method for finding table and field names using Runtime Analysis with transaction SE30. The method is particularly useful when you need to view or download information directly in SAP tables. First determine the table and field names with Runtime Analysis, and then view them with the Data Browser with transaction SE16N.
Key Concept

Finding where data is stored for custom reports is not always possible via methods that locate the table from data displayed on the screen. Some data is accessed from tables during program execution, and only assembled and displayed on the screen temporarily. Runtime Analysis with transaction SE30 can locate tables and specific data accessed during a program’s execution. When the table and field names are determined, you can view and download the data via the Data Browser with transaction SE16N.

When other techniques do not work, you can use my method to determine a transparent table name when you need to access information directly in SAP tables. In a previous article I explained how to find a table name by drilling down on the Data Element field in the Technical Help dialog box and by using the Where Used functionality to determine the table name. However, when you use that method, the system sometimes displays a message that “no table could be found.”

In many cases, users then refer to someone from the Basis team for assistance. However, my technique allows you to determine the table name within several minutes with no assistance. I recommend using the other techniques first because they are simple, quick, and work well in most cases. The method I’ll describe works well in the few instances in which the other methods don’t deliver results. Several readers contacted me to ask for assistance in those few cases, so I researched the topic and found out what programmers do to discover the table names storing data.

Runtime Analysis, an application in the ABAP Workbench, allows you to determine which tables a given transaction accesses when it runs. If you analyze a transaction while it accesses the data that you need to find, then you can determine the table name. To find a table name using Runtime Analysis, which works in both R/3 and SAP ERP Central Component (ECC) systems, follow these simple steps:

John Jordan

John Jordan is a freelance consultant specializing in product costing and assisting companies gain transparency of production costs resulting in increased efficiency and profitability. John has authored bestselling SAP PRESS books Product Cost Controlling with SAP and Production Variance Analysis in SAP Controlling.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.