OData query without manually writing code

[raffinkira]

Hi all,

Currently, after building OData models, I re-define the READ/Query method, writing SQLs to access the table.

I am wondering if automatic mapping can be done between URI and SQL.

Does SAP provide a standard solution or framework for that?

Regards,

Ming

[Andre_Fischer]

Hi Ming,

the way you develop OData Services in SAP would be to develop a CDS view. When Publishing the CDS view as an OData Service you don't have to implement the READ/Query Methods.

What platform are you working on ?

SAP NetWeaver ABAP AS or HANA XS Engine?

Regards,

Andre

[raffinkira]

Hi Andre,

I am developing on SAP NetWeaver for ABAP.

So do you mean I just need to define a CDS view for DB table then the query would be automatically implemented?

[Andre_Fischer]

More or less automatically. At least without the need to code anything.

When using 750 you would go for Referenced Data Source

https://blogs.sap.com/2016/06/01/odata-service-development-with-sap-gateway-using-cds-via-referenced...

When using 740 you would have to use the mapped data source approach.

https://help.sap.com/doc/saphelp_nw75/7.5.5/en-US/ed/2ed4e2cbc54ffdba3aead4f3a73640/frameset.htm

Regards,

Andre