Skip to Content
0
Mar 09, 2015 at 01:51 PM

Support for wild card search in SAP Gateway based Odata services

2584 Views

I understand there are some constraints with SAP Odata implementation, especially around the $filter command. Is it possible to do wildcard searches with Odata services implemented on SAP Gateway? One of the use cases we have is to look up customer account by customer name, for example a query that looks something like URL below.

https://<server>:<port>/sap/opu/odata/sap/ZCUSTOMER_HELP_SHIP_TO_SRV/Customerhelp_shiptoSet?$filter=contains(Mcod1,'BRK')

When we execute this query on SAP Gateway we get an error that states "contains" is invalid command with an SAP note that lists SAP's Odata implementation limitations.

Any suggestions on how we can get around this limitation?

Thanks in advance for your response!