How to consume external OData services in SAP Gateway

7
29678

Dear SAPLearners, in this SAP Gateway OData tutorial, we will learn how to consume external OData services in SAP Gateway.

External OData services means the service which are from 3rd party systems (or) Non-SAP systems.

OData Services Consumption and Integration (OSCI)

With OData Services Consumption and Integration (OSCI) SAP has provided the provision of consuming external services.

So lets get started.

Supported System Version

SAP NetWeaver Gateway 2.0 SP6 or higher / SAP NetWeaver 7.40 SP2 or higher

Business Scenario

In this demo example we are going to consume Northwind OData service from www.odata.org. You can get the list of available OData services here.

Step-by-Step Procedure

Create an HTTP connection to your external system by creating a RFC connection of type G in SAP  Gateway system

1. Go to t-code SM59 – Configure RFC Connection. Select HTTP Connections to External Server node and click on Create.

Configuration of RFC Connections

2. Enter the RFC Destination name and Target Host name like below and hit Save Save

New RFC Destination

3.  Test the connection by clicking on Connection Test button in the application toolbar. You should be able to connect to the server and should see the HTTP Response code as 200 like below.

Connection Test

Create SAP System Alias

4. Create a System Alias for the above created RFC destination. Go to SPRO → SAP Reference IMG and Navigate to this path : SAP Netweaver → Gateway → ODATA Channel → Configuration → Connection Settings → SAP Netweaver Gateway to SAP System → Manage SAP System Aliases.

Manage SAP System Alias

5. Enter SAP System Alias name, Description, RFC Destination and Software Version. Select Local GW and For Local App check-box as well. Click on Save Save to save the entries.

New System Alias

6. Go to transaction /IWBEP/OCI_SRV_GEN – OData Service(GW) Generator for External Data Services. Provide following details 

HTTP DestinationODATA_ORG
Service NamespaceV2/(S(xuh52ptttgitgrkbtjzk1o31))/OData
Service NameOData.svc
Model Provider ClassZCL_NORTHWIND_MPC
Data Provider ClassZCL_NORTHWIND_DPC
Model NameZNORTHWIND_MDL
Service NameZNORTHWIND_SRV
OSCI OData Generator

7. After entering above information hit Execute button to generate the service.After successfully service generation you should see the below screen.

Service generated successfully

8. Our next step is to activate and register service.Go to /IWFND/MAINT_SERVICE – Activate and Maintain Services. Hit Add Service button to add our service.

9. In the below screen enter System Alias = NORTHWIND and hit Get Services button.We will get a list of services, select our service and hit Add Selected Services button.

Add Selected Services

10. In the Add Service popup window, check the details and click OK button.

Add Service Details

11. We have successfully registered the service,now its time to test the service.

12. Finally to test the OData service, Go to transaction /IWFND/GW_CLIENT – Gateway Client. Enter the service name and execute.

Gateway Client

Congrats!! You have successfully learned how to consume external OData services in SAP Netweaver Gateway. Stay tuned to us for more SAP Netweaver Gateway tutorials and subscribe for more updates.

Please feel free to comment and let us know your feedback. Subscribe for more updates.

If you liked it ❤️, please share it! Thanks! 🙏

Like us on Facebook and follow us on Twitter.

mail

SAPLearners.com is now on Telegram. Click here to join our channel and stay updated with the latest tutorials and updates.

Comments are closed.