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.
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.
Proceed as follows:
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.PA30
and save the data.EXEC*
in the Operation field and take the Trace List.We used a small trick to find out the data source of a screen field. In order to avoid searching through a lot of table names by using display of data, we only focused on the relevant field and used a change operation. Since we changed a record, the corresponding field must be updated in the database. Also the operation name must begin with EXEC. So, we generated a list and searched for only EXEC operations. From this, we found out the name of the table PA0002 shown in the list. When we look at this closely, we see that the value we entered in the first name field was passed for update in the field VORNA.
3.144.105.2