Skip to Content
Author's profile photo John Patterson

Simple Mobile SAPUI5 Example Using ODataModel and BlueCrystal

Over the last couple of weeks various developers have contacted me asking me if i knew of a simple mobile SAPUI5 example which used both the ODataModel and the BlueCrystal theme. I have built one and thought i would share it with everyone.

The app uses the Northwind OData Service and showcases some of the sap.m and features like the sap.m.App, sap.m.Shell and, all up approximately 100 lines of code.


You can find the source on github


I have created a copy of the sample application that uses Declaritive HTML, similar amount of code, should be handy for those starting to develop with the HTML View, a couple of the expression took some trial and error

Also this morning the Northwind OData Service was down so I was working off the Mock Northwind OData Service provided in the SAPUI5 SDK.

Both versions have been updated to allow data to be read from the fake service.

This also means the application can be tested online without SOP issues code

Assigned Tags

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

      Nice one JSP. Looking forward to trying this out tomorrow.

      Author's profile photo John Patterson
      John Patterson
      Blog Post Author

      Cheers mate, let me know if you have any issues

      Author's profile photo DJ Adams
      DJ Adams


      Loved this. A great, self-contained example of aggregation bindings, paths and context with OData. Here are the things that I liked in particular:

      - the path and formatter properties for the StandardTile's number property and the use of the productCount to, well, count the products

      - the example of how (and where - in the binding) to include an OData parameter

      - the use of getContexts().length to count the (already fetched, via $expand) Products for the given Category

      One question - is there any reason you wrapped the App in a Shell before placing in the DOM?



      Author's profile photo John Patterson
      John Patterson
      Blog Post Author


      Thanks a lot for the feedback. "self-contained" is a good description of what i was going for. The target audience for this application is developers who haven't had the time to investigate SAPUI5 but are familiar jQuery and JQM, hopefully presenting this way gives them a familiar perspective.

      One of the things i like about SAPUI5 is the variety of ways you can solve the same problem. I went through many iterations of rendering the tiles from the model data, the example i ended up with uses a tile template with a binding aggregation, I think this way is very effective and probably the easiest to represent in a HTML View.

      The other thing i really like about SAPUI5 is method chaining, in the case of the Product Count the chaining may have over simplified what is going on.

      var aBindings = this.getModel().bindList("Categories(n)/Products");

      var aContexts = aBindings.getContexts();

      var productCount = aContexts.length;

      return productCount;


      return this.getModel().bindList(sPath).getContexts().length;

      A really useful resource for understanding bindings is the ODataModel qUnit Test.

      Why did i wrap the App in a I use a variety of widescreen monitors with different resolutions, by default the Shell restricts the rendering width of the application when run on a desktop to 1024px (I think) and therefore I get some consistency and you can predict what it will look like on other peoples desktops.



      Author's profile photo DJ Adams
      DJ Adams

      Thanks jsp

      That's a good tip on the qunit for ODataModel. What the SAPUI5 team puts out as an SDK is pretty impressive - the runtime itself, plus the great docu, and the unit tests and demos/examples.



      Author's profile photo John Patterson
      John Patterson
      Blog Post Author

      Definitely, the SDK has a lot of great content.

      Author's profile photo Murali Shanmugham
      Murali Shanmugham

      Good one John

      Author's profile photo John Patterson
      John Patterson
      Blog Post Author


      Author's profile photo Former Member
      Former Member

      Hello John,

      I am able to view the output using the Fake service, as soon as i comment the two lines as mentioned in the code, i get no output.

      Error Details in Chrome Dev Tools

      Network tab

      1. Request URL:$metadata
      2. Request Method:OPTIONS
      3. Status Code:501 Not Implemented

      Console Tab

      1. OPTIONS$metadata 501 (Not Implemented)

      XMLHttpRequest cannot load$metadata. Request header field x-csrf-token is not allowed by Access-Control-Allow-Headers.

      I am having same issue in all my SAP UI5 examples when trying to access the northwind odata services. Can you please let me know what am i missing.

      Code :


      Arun Sambargi

      Author's profile photo John Patterson
      John Patterson
      Blog Post Author

      Hi Arun

      I believe the Northwind OData services had some firewall issues which have now been resolved.

      I am able to run you code with no issues.



      Author's profile photo Deepak Malviya
      Deepak Malviya

      Hi John,

      Hope you are doing well.

      I went through this example of yours and i am also getting the same error as mentioned above by Arun.

      Even i am not getting this using those two lines for fake service.

      Can you please assist on this.