Skip to Content
Author's profile photo Andre Fischer



– 02.12.2014 –> Added link to YouTube Video


In our d-code hands-on session INT260 the particpants created a SAP Fiori-like application end-2-end. This included the creation of the required OData service from scratch, making use of a CDS view (Core Data Services) from HANA. The SAP Fiori-like application itself was a SAP UI5 application which was to be generated using the new SAP Web IDE.

Though this was a 4h hands-on session our plan is to provide a short video that shows the most important aspects for those that were not able to join or just want to have an overview what needs to be done here.

The result is a 5 minutes video that has been uploaded to our YouTube Channel:

Developing an E2E Integration Scenario with SAP Gateway, SAP HANA and SAPUI5 – YouTube.

Demo Flow

OData service development

In our demo we will create a simple OData service having just one entity set for business partners based on a CDS view that is accesible from the ABAP stack. As described in more detail in the following document New Data Modeling Features in SAP NW ABAP 7.4 SP5 “CDS entities are integrated into the ABAP Dictionary and ABAP language using the same infrastructure which exists for classical Dictionary views.”

Development Flow Picture CDS View.png

1. Data Model Defintion


The whole process starts with the creation of a Service Builder project.


Here, as a first step, we import a DDIC structure which is based on a CDS view.

2. Service Implementation


After having created an entity type and an entity set based on importing the corresponding DDIC structure the service implementation is performed by mapping the business entity (the CDS view) to the entity set.

Steps mapping CDS view.png


After having done the mapping via drag and drop the service implementation is generated without the need to write a single line of code.

Map CDS View.JPG

After having performed the service implementation the project is generated and the service is registered in the backend.

Press Generation Button.JPG

3. Service Maintenance


When the runtime artifacts have been generated (step 2) the service is also registered in the backend system and can now be published via the Service Builder in the connected Gateway Server (Hub) system.

Publish service on the hub.JPG


A first test is done using the SAP Gateway client.

test using GW CLient.JPG

Generation of a SAP Fiori like application


In our hands-on we used the predecessor of SAP Web IDE to generate a SAP Fiori like application. SAP Web IDE allows amongst others to generate a simple application with a list / detail view.

SAP Web IDE Wizard.JPG

Testing the application


The generated app is finally tested in the browser.

Test generated UI5 app.JPG

The summary is shown at the end of the vidoe(06:02)

Assigned Tags

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

      Hi Andre,

      Nice blog.



      Author's profile photo sarath chandra
      sarath chandra

      Hi Andre,

      Very nicely elaborated.Your book on odata and netweaver  is also extremely informative & helpful.Actually we are planning to develop the SAPUI5 screens using SAP netweaver gateway for some field service E2E use cases.For example there will be SAPUI5 screen like service order capture,service order update etc where we will be using odata to fetch the data from SAP CRM & then update back to SAP CRM for data through excel file or in the SAP UI5 SCREEN.The backend data in CRM is heavy.Is it suggestible to go for UI5 from performance etc point of view.Any measures to ensure high performance through gateway.Can you pls share your valuable comments .Also attaching one sample screen:

      Many Thanks



      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      Hi Sarath,

      great to hear that you like our book about SAP Gateway and OData 🙂 .

      A while a ago my colleague David Freidlin posted the following blog Gateway Performance Best Practices - How to consume Gateway from performance point of view around do's and don'ts when it comes to performance aspects around SAP Gateway.

      Depending on the scenario the delta query support might help you which I have  described here How to Implement Basic Delta Query Support in SAP NetWeaver Gateway or might want to use eTags or the new Soft State feature How to use Soft-State support for OData services .

      Since you have mentioned that you think about using Excel I would like to recommend our product SAP Gateway for Microsoft that especially offers a nice Excel integration. More details you will find in the following document FAQ - SAP Gateway for Microsoft of my colleague Holger Bruchelt.



      Author's profile photo sarath chandra
      sarath chandra

      Hi Andre,

      Thank you very much...We are  actually planning to implement an extensive SAUI5  desktop  application with more than 15 use cases on SAPUI5 with  netweaver gateway and I as the owner of this project was trying to get a hold of what is this technology all about from various sources.This book guides to understand the nuances from the basic concepts till advanced areas.Extremely delighted to get the guidance from your book!!



      Author's profile photo sarath chandra
      sarath chandra

      Hi Andre,

      In the scenario I mentioned in my earlier query, where multiple users will concurrently work on the SAPUI5 screen, there may be some update which is happening for the same  SAP CRM service request by multiple desktop users.e.g User A who works as a service partner has service request 123 to update in his desktop.From sameservice partner  organization user B also logs in and may see the same service request 123 in his desktop and starts updating.There will be a concurrency .What happens when there is a heavy list of service tickets at month end with multiple users logging in to the same screen and updating.Any advice would be of great  help.