Skip to Content
Author's profile photo Masayuki Sekihara

SAP Fiori LL11 – Consultants should know about OData troubleshooting

SAP Fiori Lessons Learned 11

Consultants should know about OData troubleshooting



SAP Fiori apps are out of the solution but you face several issues because main functions are in backend ERP and each customer has different backend setup/configuration. OData is the communication channel to the backend servers via get/post/put method.


Lessons Learned:

Understanding OData and backend function are must requirements for consultants.

  • Application consultants should learn about OData technical and runtime behavior
  • Technical consultants should learn about ERP application functions
  • Both application consultants and technical consultants should work together


Consultants should know following steps.


Step 1. Identity the OData service call

1.1 Run the app

1.2 Inspect element

Right click -> Inspect element (Chrome), F12 (IE), then go to Network tab


Ignore the warning or error message in the Console tab at this point in time. Focus on OData troubleshooting.


1.3 Refresh the app or browser


1.4 Find the last called OData URI

Scroll down to the bottom of inspect element and find the OData /sap/opu/odata/sap/.. from bottom.




Step 2. Test OData in the Gateway client

2.1 Copy & Paste the OData URI

Transaction: /IWFND/GW_CLIENT. You should logon with the application user same as Fiori app logon.


2.1 Check the OData response


If http response is not 200, you may have some connection setting issue.

If tttp response is 200 but OData service does not return application data, you should go Step.5 debug section.


Step 3. Check error log

3.1 Transaction /IWFND/ERROR_LOG


Select the “Error Context”


Call Stack helps you to set external break points.


3.2 Transaction /IWFND/APPS_LOG


Reference: Troubleshooting a SAP Netweaver Gateway Service


Step 4. Find the Runtime Data Provider class

4.1 Transaction /IWFND/MAINT_SERVICE



4.2 Transaction SE24

Open the Data Provider Class. Go to Property tab.


4.3 Transaction SE80

Open the package.


Class -> Runtime Data Provider Class -> Method -> Redefinitions

The example OData URI has &expand oprion, so you should look at the method GET_EXPANDED_ENTITY.


Step 5. Set External break points and debug

5.1 Check the user

Go to Utilities -> Settings


Make sure the user is application user.


5.2 Set external break points


5.3 Debug

Test the OData URI from Gateway Client. You can now debug the code. Most of case, issue is related with ERP customizing or master data.

Each customer has different customizing setting and master data.




SAP Rapid Innovation Group – RIG

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Syambabu Allu
      Syambabu Allu

      Excellent Stuff and it's covered GW Debugging also



      Author's profile photo Hemendra Sabharwal
      Hemendra Sabharwal

      Great stuff, thanks for sharing.

      Author's profile photo Former Member
      Former Member

      Excellent stuff Masa

      Keep posting more

      Cheers 😉


      Author's profile photo Former Member
      Former Member

      Super stuff. The most useful stuff I come a cross for a long time.


      Author's profile photo Former Member
      Former Member

      very nice. very userfull suff.............t


      Author's profile photo Former Member
      Former Member

      What does it mean if the status code returns 500 when I execute my oData URI in Transaction: /IWFND/GW_CLIENT instead of 200

      Author's profile photo Masayuki Sekihara
      Masayuki Sekihara
      Blog Post Author

      500 means internal server error. List of HTTP status codes - Wikipedia, the free encyclopedia. Most of cases, system connection has not been setup or there was short dump in he backend. Please create new discussion if you need further support. Start a discussion.

      Author's profile photo Former Member
      Former Member

      Hello Masu,

      thanks a lot - great stuff. Helps me a lot for understanding.

      Regards Toni

      Author's profile photo Timothy Muchena
      Timothy Muchena


      Excellent blog

      I can see the tiles in Chrome and not in IE. I also can see the OData URI in Chrome and not in IE. Any idea of what might be the cause?

      Kind regards

      Author's profile photo Former Member
      Former Member

      thank you! very helpful doc!

      Author's profile photo Former Member
      Former Member

      Thank you. This helped me to resolve an issue.

      Author's profile photo Deborshi De Sarkar
      Deborshi De Sarkar

      Thanks you...very use full document.

      Author's profile photo Liang Hu
      Liang Hu

      Thank you! It is a great document.

      BTW, is there any list for all LL documents for Fiori?

      Author's profile photo Michael Appleby
      Michael Appleby

      SAP Fiori

      will take you to the Fiori community Overview page.  Check out the All Things SAP Fiori right in the middle.  It is where all things Fiori are organized for easy access.

      Cheers, Mike

      SAP Technology RIG

      Author's profile photo Jeremy Good
      Jeremy Good

      As Mike mentioned the more recent "SAP Fiori LL" blogs are located in the SAP Fiori space, and as you've seen with this one, the older blogs are located in the SAP for Mobile space.  There is no master list, but you will find them linked on their correlated topic pages in the All Things SAP Fiori document.  The title format is consistent, and Masa is the author, so a creative search might help you.

      Author's profile photo Yogesh Patel
      Yogesh Patel

      I really like that someone taking time to put this valuable information. This document helped me to resolve some issues.



      Author's profile photo Martin Schlegel
      Martin Schlegel

      Hello Masa, thank you for sharing. Martin 

      Author's profile photo Wendy Li
      Wendy Li

      Many Many thanks!
      it is very helpful!

      Author's profile photo Srikanth Subramanian
      Srikanth Subramanian

      Hi Masa,

      is there a link for FIORI DEMO Trail version and also to know difference between timesheet entry Version1 & Version 2.

      I am using below link and it is not working.





      Author's profile photo Masayuki Sekihara
      Masayuki Sekihara
      Blog Post Author

      Hi Srikanth, Please post is as a question.

      Author's profile photo Andre Julius
      Andre Julius

      Hi Masayuki Sekihara,


      Thanks for the sharing. In my case, it seems there is some kind of timeout. i.e: when my UI5 trigger my breakpoint in GET_ENTITYSET, after a while the debug window is gone. Another weird thing is that my debug window appears 2 times. I wonder what cause this. Can enlighten me based on your experience?


      Best Regards


      Andre Julius