Quickly finding the data source of a screen field

In this recipe, we will see a quick method that will enable us to find the database table and field in which the data of a particular SAP screen field is stored. We will use the SQL trace and the EXEC operation for this purpose.

Getting ready

We will use PA30 and its Infotype 0002 in this example transaction. We assume that we are not sure which table name and field stores the first name of an employee.

How to do it...

Proceed as follows:

  1. Call transaction PA30. Enter an employee number in the field provided. Also enter 0002 (personal data)in the Infotype field, and then click on the Change button.
  2. Once you are in the Change Screen, change the First Name of the employee in the relevant field. Do not press ...

Get SAP ABAP Advanced Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.