topic Re: OData query without manually writing code in Application Development and Automation Discussions

OData query without manually writing code

raffinkira — Tue, 15 Jan 2019 12:04:20 GMT

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

Re: OData query without manually writing code

Andre_Fischer — Tue, 15 Jan 2019 12:21:52 GMT

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

Re: OData query without manually writing code

raffinkira — Tue, 15 Jan 2019 13:38:11 GMT

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?

Re: OData query without manually writing code

Andre_Fischer — Tue, 15 Jan 2019 14:12:07 GMT

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-data-sources/

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