Write Data from UI5 to ABAP DB using writable oDATA Service

[Former Member]

Dear SapGuru's

Greetings!

Is it possible to create a oData Service which writes/insert records into ABAP database table in ABAP system & calling that writable oData Service from SAP UI5 ?

Thanks,

Regards,

Rumeshbabu S

[midhun_vp · Accepted solution]

You can perform CRUD (create read update delete) operations on any DB using a Odata service. In the case of SAP you can use a NW gateway to expose the Odata services to internet. That can be consumed in SAPUI5 application. These documents can give you some idea on it,

Midhun VP

[Former Member · Accepted solution]

Thanks Midhun.

The document   How-to Guide: Building SAPUI5 Applications on SAP NetWeaver AS ABAP 7.31 Consuming Gateway OData Ser...

represent how to get data from backend using oData Service.

But my requirement is write(create) data to backend using oData Service.

Regards,

Rumeshbabu S

[midhun_vp · Accepted solution]

If you are looking for a sample code to do operations including create you can check this blog, http://scn.sap.com/community/developer-center/front-end/blog/2014/01/13/building-a-crud-application-...

You can test the operation from a rest client too before writing code in an application, this thread might help you, http://scn.sap.com/thread/3379817

Midhun VP

[Former Member · Accepted solution]

Thanks Midhun,

It was very helpfull.

Is it possible to create multiple records in DB in single POST request ?

The above example creates single entry into backend.  Similarly  is there any way to create/update multiple entries using single POST request.

Regards,

Rumeshbabu S

[midhun_vp · Accepted solution]

The Odata batch request is supported in Odata SDK 3 native apps. It is a part of SMP 3, it may be released in June. I am not sure about the batch request support for SAPUI5.

Midhun VP