Creating ODATA service

[neminath]

Creating Netweaver Gateway service for ODATA.

Create a project

Go to TCODE  : SEGW.

Click On “Create Project” Button

A pop up will appear. Input all data as required, and click Continue.

A new project will appear on the left hand side.

Now Right click on “Data Model” folder and select “Redefine” - > “BW Query Service”

A Wizard will get open

Input as bellow:

Access type             : Controller for MDX

                             : This is by default MDX if  you don’t have Easy Query on architecture 

RFC Destination       : BWDCLNT100

                             : This is the system from where we are fetching query

Catalog Name                   : ZOD_MKTG

                             : This will be provided by BW resource

Query Name            : ZOD_MKTG/ZQRY_ZMP_MKTG_Q01                           

: This will be provided by BW resource

Input all this data and click on Next button

On Next screen, put the description for the Model and Service, and Click on Next Button

On 3^rd Step, we get all the entity set.

Select all and click on Finish Button

A success message will appear.

Now click on “Create Runtime Object Button”

A popup will appear, Select the “Overwrite Extended Service” check box, and click Continue.

Give Package and TR details and Click Save Button.

Success Messages will appear.

Now, activate the services. To do so, go to Tcode : /IWFND/MAINT_SERVICE

Click on “Add Service” Button on application bar. Here put the client name(BWD100) and click on “Get Services” Button

It will list the all services created. Select the service that we have create and click on the “Add Selected Service” Button.

A popup will appear, put package name and click on Continue button.

A success pop up will appear.

Click Continue on success message popup and then click back button on Add selected service window. You will come to initial “Activate and Maintain service” screen.

Here scroll to your service and double click on service name.
Then click on the “Gateway Client” Button.

This open a new window : NetWeaver Gateway Client

Click on “Add URI button”. A popup window will appear. Select “$Metadata”.

Now Request URI have $metadata at end. Now Click on Execute Button.

You will XML file on HTTP Response side.

Scroll to the Bottom of the XML file to atom link segment.

Here you can find the HTTP link for meta data. Copy this link; we need to send this to .Net team

http://XXXXXX.XXXXXXX.XXXXX.com:8010/sap/opu/odata/sap/YTEST_ZOD_MKTG_TESTPRJ_3_SRV/$metadata

Now find the “Entity Container Name” segment, and find the Entity set name with label as our query description.

Copy the Entity set name, here, “ZOD_MKTG_ZQRY_ZMP_MKTG_Q01Results”.

Paste this at the end of Request URI by removing “$metadata”, and then execute.

It will give the result in HTTP Response window.

From here copy the Hppt link appear in <ID> segment

For Exp.

http://XXXXXXXXX.XXXXXX.XX.com:8010/sap/opu/odata/sap/YTEST_ZOD_MKTG_TESTPRJ_3_SRV/ZOD_MKTG_ZQRY_ZMP...

This is our result link.