DEVELOP AN E2E INTEGRATION SCENARIO WITH SAP GATEWAY, SAP HANA AND SAPUI5
Updates
– 02.12.2014 –> Added link to YouTube Video
Introduction
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.”
1. Data Model Defintion
00:17
The whole process starts with the creation of a Service Builder project.
00:37
Here, as a first step, we import a DDIC structure which is based on a CDS view.
2. Service Implementation
01:17
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.
02:01
After having done the mapping via drag and drop the service implementation is generated without the need to write a single line of code.
After having performed the service implementation the project is generated and the service is registered in the backend.
3. Service Maintenance
02:20
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.
02:41
A first test is done using the SAP Gateway client.
Generation of a SAP Fiori like application
03:24
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.
Testing the application
05:35
The generated app is finally tested in the browser.
The summary is shown at the end of the vidoe(06:02)
Hi Andre,
Nice blog.
Regards,
Imran.
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
Sarath
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.
Regards,
Andre
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!!
Regards
Sarath
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.
Thanks
Sarath