Tip: How to Find the Correct SAP Table

The RFM Code Generator offers the possibility to create code to read data from SAP transparent tables or views, via the SAP standard RFM RFC_READ_TABLE. But when data is to be loaded from an SAP system, the question very often arises in which tables can be found in. A very good approach is to start the transaction code (TAC) and to take a look at the selection screen. In our example the TAC VA03, Display Sales Order.

image

Select the field of interest, in our example Order, and press key F1. This opens the Performance Assistant.

image

Here you have the possibility to open Technical Information.

In the upcoming dialog you can find a lot of very interesting information about the selected field. The focus of our interest is here the section Field Data. Here we can find the Table Category, the Table Name and the Field Name. In our case it is a Transparent table, with the name VBAK and the Field Name VBELN.

Now we start with the TAC SE84 the Repository Information System. You can use it to search for objects or to locate objects that match particular criteria in the SAP System. The Repository Information System is part of the ABAP Workbench.

Open the node Database Tables below the ABAP Dictionary, write VBAK into the Table Name field and open the table.

Now all technical information, about the table, are available.

In RFM Code Generator you can find the same information.

Hint: The sum of the length of all fields are in this case 1273 characters, but RFC_READ_TABLE allows a maximum of 512 characters. Here it is now necessary to select the fields you need, so that the length of 512 characters is not exceeded.

But there is a Structure

A transparent table is not always displayed in the field data, it can also be a structure.

image

Open in the Repository Information System the node Structures, write the name KUAGV and open the structure. Choose the Input Help/Check tab and look at the column Check table.

Here you can find the foreign key relationships and with this often the correct table.

Hint: However, if the programmer has not defined foreign key relationships but has specified them in his ABAP code, the corresponding ABAP code must be analyzed.

Conclusion

This procedure can be used to detect a lot of tables in an SAP system, starting from the use case in the SAP GUI for Windows. This base can then be used to create Invoke Code activities, using the RFM Code Generator, to transfer data from the SAP system into the context of the UiPath workflow.

2 Likes