Shulou(Shulou.com)06/01 Report--

What this article shares with you is about how to find the underlying database table corresponding to a field on SAP Fiori UI. The editor thinks it is very practical, so I share it with you. I hope you can get something after reading this article.

In the era of Fiori, many methods are no longer applicable.

The editor introduces a method to find out the ABAP background database storage table corresponding to a field on Fiori UI. Although it may not be universal enough, it did solve a problem that Jerry encountered in its actual work at that time.

This is a standard Fiori application for SAP S/4HANA: Product Master

What I need is to find out which table the field "Number of Goods Receipt" is stored in the background.

Here are the detailed steps of Jerry's own exploration.

(1) We know that SAP UI5 is also a front-end framework based on MVC, which supports two-way binding. In the Chrome developer tool, find the name of the model field bound to this UI field:

NmbrOfGROrGISlipsToPrintQty

(2) find the OData service on which the Product Master Fiori application is based, enter its metadata url in the browser to view the result, and find that the subordinate data type of the field NmbrOfGROrGISlipsToPrintQty is:

C_ProductstorageType

(3) Log in to ABAP Development Tool and use the menu "Open ABAP Development Object":

Take the data type C_ProductstorageType found in step 2, and according to the naming convention, query the value C_Productstorage before Type as the keyword:

C_PRODUCTSTORAGE, at the top of the list of results, is a CDS view.

This view reads data from I_ProductStroageWD

I_ProductStorageWD reads again from I_Productstorage:

Finally, I_Productstorage reads the data from the database table MARA.

In the source code of this view, search according to the field name NmbrOfGROrGISlipsToPrintQty found in step 2, and immediately find the field in the corresponding database table MARA as wesch:

Then open MARA in SE16 to confirm that the 23.671 field seen on Fiori UI is indeed stored in MARA.WESCH, and the task is complete.

The above is how to find the underlying database table corresponding to a field on SAP Fiori UI. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.