Consume HANA XSODATA services on SAP NW GW

[ratnakar_reddy]

Hi Team,

We have an requirement for UI5 application to consume HANA DATA via XSODATA services.

The solution architecture is defined as following .

SAP NW GW system connected with HANA DB with HTTP Destination having system alias configured. The UI5 application get deployed into SAP GW, here GW is a just web container and not using any ABAP functionalities with  ui5 application.

In order to consume the XSODATA services on SAP GW , followed below links and tried to consume ODATA service at application side .

• http://www.saplearners.com/how-to-consume-hana-xs-odata-service-in-sap-netweaver-gateway/

• http://scn.sap.com/thread/3587498

• http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d0b5be6f-afb7-2f10-e68c-dad80774a...

We are able to get the metadata of XSODATA service and as well as Entityset data at GW client , but $Filter is not working  when passed on URI.  PFB the details

/sap/opu/odata/sap/ZFINALSANVIEW_SRV/getPdaPgaData?$filter=MSN eq '07102'

Getting error attached  while testing above link at GW client

But the $filter is working on XSODATA when applied as below

https://:

please let us know if we need to implement any logic with-in runtime classes as similar as we do in general for SAP ODATA services. I suspect here that the final filter should happen on HANA side and GW ODATA just to pass the request as part of service configured within its definition

please share your pointers , advance thanks for your support

Thanks ,

Ratnakar

[ratnakar_reddy]

The Hana XSODATA service applied with $Filter as below is working on browser.

https://:<host>:<port>/XXX/Sandbox/NGxxx/getFinalview_PDA_PGI/Zinputparam.xsodata/getPgapdDdata?$fil... eq '07102'&$format=json

Ratnakar

[lynn_lin]

Hi,

Please check if the following notes can solved the issue.

2256525 - Incorrect internal length is calculated for properties

2264058 - Wrong internal error message on certain Filter- or OrderBy-Values

Regards,

Lynn