Skip to Content

Connect more than one (1) query in SAP Gateway for ODATA

Hi guys,

Is it possible to connect more than one (1) query in a single SAP gateway? I tried to connect 2nd query in my existing gateway but it's asking me to overwrite the currently connected query. So I think this is not possible? Is there another way to do this?

I followed the blog below to create the gateway.

https://blogs.sap.com/2012/12/08/transform-sap-bw-queries-into-odata-service-generation-and-activation/comment-page-1/

Thanks.

Loed

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 14, 2018 at 06:04 PM

    Hi Loed,

    it is not possible to generate an OData service that is based on two or more queries.

    But if you have generated several OData Services each based on one single query you can combine them using the

    SEGW feature „include GW service“.

    Also it is possible to consume several OData Services within on SAP UI5 application.

    Best Regards,

    Andre

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 17, 2018 at 07:45 AM

    Hi Andre,

    Is it the option below? What is the advantage of combining them?

    Also, do you have an idea how to enter a value for the query with variable? Because after clicking the EXECUTE button it gave me an error to specify a value for variable SOLD TO PARTY.

    ERROR:

    Thanks.

    Loed

    Add comment
    10|10000 characters needed characters exceeded