Skip to Content

Consume HANA XSODATA services on SAP NW GW

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-dad80774a223?overridelayout=true

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

Error.jpg (231.8 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jun 24, 2016 at 09:10 AM

    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?$filter=MSN eq '07102'&$format=json

    Ratnakar

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.