Skip to Content
Technical Articles
Author's profile photo laxmi jibhe

A Step by Step process to create Odata services in SAP / SAP HANA system



While creating Odata services, I had gone through multiple blogs post and found that there are few steps which are not self explanatory and hence at the end of creating an odata service we get bad HTTP response . This is mainly due to missing explanation for how to load meta data and how to test the entity set data .

In this blog post, I am going to tell you step by step process to create Odata services for SAP /SAP HANA system and how to test it.

I tried to explain the whole process in 4 steps.

Step 1. Go to transaction code – SEGW .


Click on Icon Create. A pop window will appear , Fill the details as per below mention in screen shot and click on check icon or enter.



Below screen will appear where you can see below folder in project. In Folder data model, we can see three sub folders. Entity Type – it acts as work area , Entity Sets -It act as internal table and associations.



Now we are going to define structure of work area and internal table , Right click on Data model select import and select DDIC structure .



Here give the details of structure and structure name as per below screen below.

Select radio button Entity type and and click on check box entity set. fill ABAP structure as VBAK and click on next


Now you will get the pop up screen with VBAK table fields name. Select fields for your structure and click on next.



Other window will appear where we have to select the key field. tick on Vbeln as key field and click on finish. You may get warning message , it can be totally ignored.

Now expand folder entity type and fill the below parameters in properties , Please don’t tick Null check box for VBELN as it is key field.

Similarly Create Structure for SD Item following same steps

click on Save button at the top of menu bar

Now click on generate Icon, A pop up window will appear with class details , click on tick icon and proceed further. It will ask for package , give details and proceed further . These are also knowns as runtime artifacts.


Step 2. Go to transaction code /IWFND/MAINT_SERVICE .

Click on push button Add services .


Next screen will appear, give the alias name and execute , Search you for your project .

Now double click on your project name . A pop up window will appear , enter the package details and click on tick icon. An Information message will be shown where it will confirm about the service is created and metadata loaded successfully


Now click back and go to main screen of transaction /IWFND/MAINT_SERVICE and find your service.

Click on SAP Gateway Client



A new screen will come, Execute the transaction and check the response .


Now we will write code to get data.

Step 3. Go to transaction code SEGW and expand folder service Implementation  .

Under service implementation – Expand SDheaderSet. you will find different options. Right click on GetEntitySet and select GO to ABAP work Bench . It will redirect to the class


Now expand the method drop down and select method for GetEntitySet for Header data and right click and select redefine.


Write below code in method. Save and activate all related objects for classes.

Similarly , Write code for GetEntitySet for Item and activate .


Step -4

Go to transaction /IWFND/MAINT_SERVICE and find out you service , select your service and click on load metadata.

Information message will pop up – Metadata has been loaded successfully.


Now Click on SAP Gateway Client .


Now Click on Entity set.


Select entity for header and enter

Click and execute and you will get the header data in response


Similarly, Select entity set for item and execute . You will get data for item


Here , We had completed our Odata service creation with a Service Builder Project with two entities and two entity-sets. We have generated the runtime artifacts and registered and activated our OData service. We had redefined methods of header and item entity set , load metadata and test the entity set with for test data.


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Gowri Pujitha Kapu
      Gowri Pujitha Kapu

      Hi Laxmi,

      While adding a service in /IWFND/MAINT_SERVICE,Iam getting an error "System alias 'LOCAL' does not exist".Please help me out if any necessary configuration is missed out.

      Author's profile photo laxmi jibhe
      laxmi jibhe
      Blog Post Author

      Hi Gowri,

      System Alias need to be maintained, Please check if System Alias is created in your system if not then maintain as per below

      SPRO -> SAP Gateway -> Odata channel -> Connection Settings -> SAP Gateway to SAP System -> Manage SAP System Aliases

      Once the system alias is created, Maintain that for your odata service in  /IWFND/MAINT_SERVICE. In Transaction   /IWFND/MAINT_SERVICE , Select your Odata service and click on below Pushbutton on screen which you can see in right bottom window.


      Author's profile photo Toni Ariyanto
      Toni Ariyanto

      Hi Laxmi,

      I don't know whether the article is related to my problem or not, but after i did all steps above i want to connect SAP Analytics Cloud (SAC) to my odata service. When i create new connection using odata service connection, i have an error "the user does not have permission to access the requested resource".

      Is it any step that i missing or need more config? Can you help me please?


      Thank you.

      Author's profile photo Anurag Gupta
      Anurag Gupta

      have you enabled ODATA service via transaction SICF ?

      Author's profile photo laxmi jibhe
      laxmi jibhe
      Blog Post Author

      Hi Anurag,

      Yes, we can enable OData service via SICF transaction .


      Author's profile photo Anudeep Appidi
      Anudeep Appidi

      Wonderful Explanation. Thanks Ma'am

      Author's profile photo Venkatesh Jajula
      Venkatesh Jajula


      Author's profile photo Soujanya Puli
      Soujanya Puli

      Hi Laxmi,

      Very good document for beginners. Thanks.




      Author's profile photo Miloš Volek
      Miloš Volek

      Thanks for sharing! Its very well written, detailed information.

      Author's profile photo Aqib Pathan
      Aqib Pathan


      Excellent blog to begin with! Keep it up



      Author's profile photo indranil panzade
      indranil panzade

      Indeed, Great Job! Happy to see your blog. Keep it up !.

      Author's profile photo Mehak Kaur
      Mehak Kaur

      Good one!

      Author's profile photo Mani Reddy
      Mani Reddy



      I'm getting below error while trying to execute headerSet. Any idea please ? I have followed all the mentioned steps in the blog.


      Author's profile photo Glauco Kubrusly
      Glauco Kubrusly


      Probably you must redo this step: redefine method GetEntitySet.

      Author's profile photo Sanvi Kadam
      Sanvi Kadam

      Hello Mani,


      I have also faced the same issue, but it got resolved -

      Click on activate, after the method is re-defined

      Author's profile photo Siswanto Tan
      Siswanto Tan

      Hello laxmi,


      overall this tutorial is very easy to understand, although I'm curious about one part ( regarding the behavior of Odata method sequence ):

      • upon executing the URI, from the SAP NetWeaver Gateway Client from your example below for Header, it seems to automatically run the method get_entityset ( or is it get_entity) and return the correspondence value

      so question is: what if I wanted to test the create / update / delete method, how do I actually change the URI to test the other method? is it possible to do so in SAP environment or doable in external system environment (such as Postman, etc)






      *Update: I've understood that to call other method ( update / create / delete ) is based on the http Method ( POST, PUT, DELETE ),
      only one question left: how do I test the Odata service from out of SAP, do I use Postman based on the URI given in the gateway client screen, or is there other usable software?

      Author's profile photo Uday Gubbala
      Uday Gubbala

      You can refer to Jan's blog where he has described as to how to execute ODATA operations via POSTMAN

      Author's profile photo Hemant Vaswani
      Hemant Vaswani

      Hi All,

      Can you help me understand , after loading the metadata, when i attempt to click on "SAP Gateway Client " button, the click is acknowledged but the new window as seen in this blog is not appearing at all, what could be the reason.


      after click on the button none screen pops up i tried click on Call Browser but nothing happens I am using SAP GUI 770 Ver Windows