SAP Web IDE oData And The SAPB1 Service Layer

[former_member247972]

We are relatively new to the SAP Web IDE. We have set up the oData service including the table(s) we wish to work with on our local server and connected using the SAP Cloud Connector. Fiori apps have been created accessing UDO's only at this time. The issue is that it appears to be updating the tables directly and not using the REST functionality. I would really like to use the Web IDE template functionality as it really enables us to start the project rapidly.

What are our options here?

Is there a way to route the oData requests through the service layer in a similar manner as the REST calls?

Is there a way to generate the app from the templates to use REST instead of oData?

Is there a way to combine these?

Rest destination

oData destination

[former_member247972]

What I would really like to see are some templates that would use the SBO service layer instead of ODATA.

[duncanspeidel]

Hi Tom,

What makes you think it is directly editing the tables. In order to do a direct table update you would need to provide table name and HANA credentials. The service layer does the update using REST (OData).

It looks like you have configured the cloud connector to communicate with the service layer. The service layer is accessed via REST but does the updates via OData.

Best regards,

Duncan

[former_member247972]

Duncan,

The tables in SAPB1 have fields in them that are controlled/updated by they system. These cannot be passed/updated by the standard REST commands. In order to update these properly, you have to use the HTTP POST or PATCH and service layer URL. See the screenshot below. The fields in yellow, cannot be updated via REST (ODATA) as they are updated by SAPB1.

2019-02-26-09-42-01.jpg

Regards,

Tom Arnold