Creating ODATA service
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 3rd 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.
This is our result link.