Fiori App - Technical Details

1. Identify the OData Service

• Open the Fiori app.
• Press F12 to open your browser's developer tools.
• Go to the "Network" tab.
• Reload the app.
• Look for a request with a name ending in "_SRV". This is the OData service that feeds data to the app. Copy the service name.

2. Analyze the OData Service

• Go to transaction /nSEGW in your SAP system. (This is the SAP Gateway Service Builder)
• Paste the OData service name (without the "_SRV" ending) and press Enter.
• Navigate to "Data Model" > "Data Source References" > "Exposures via SADL". This confirms that the Fiori app is based on CDS views, which is common for modern Fiori apps.
• Go to "Entity Types". Here, you'll see a list of entities that represent the data structures used in the app.
• Select an entity and explore its properties.
• Click on a property to see its details, including the underlying data source. This will often lead you to a CDS view.
• From the CDS view, you can trace back to the underlying database tables.

3. (Alternative) Use the SAP GUI

• If you know a transaction code that performs similar functions to the Fiori app, you can use the SAP GUI to identify the tables:
  • Run the transaction in the SAP GUI.
  • Use transaction ST05 to activate SQL trace.
  • Execute the relevant actions in the transaction.
  • Deactivate the SQL trace.
  • Display the trace list. This will show you the database tables that were accessed.

Important Notes:

• Recent Fiori apps are often based on CDS views. These views can abstract the underlying database tables, making it slightly more complex to trace the data lineage.
• Some Fiori apps might use complex logic or multiple services. This can make it more challenging to pinpoint the exact tables involved.
• For write operations, pay close attention to the HTTP methods used in the network trace (POST, PUT, DELETE). These indicate data modification requests.
• If you have access to the app's source code, you can examine the code to see how it interacts with the OData service and underlying data.

By following these steps, you can gain a good understanding of the tables a Fiori app reads from and writes to. This knowledge can be valuable for debugging, troubleshooting, and understanding the data flow within your SAP system.