Skip to Content
Author's profile photo Former Member

Expose Attribute Views as XS OData Service in HANA

1. You need to change the Eclipse IDE perspective to SAP HANA Development. Navigate toWindow → Open Perspective → Other to change the perspective of your HANA Studio to SAP HANA Development   (OR)   Select the SAP HANA Development perspective in the perspective shortcut which is at the top right corner of your SAP HANA Studio.


2. In the Open Perspective window, select SAP HANA Development Perspective and hit OK.


3. In the left section, you will see three new tabs Project Explorer, Repositories and Systems.Select Repositories tab.

4. Right click to create a new repository workspace for the HANA System you have already logged in.


5. In the Create New Repository Workspace window, select the HANA system for which you want to create workspace, enter Workspace name and hit Finish.


6. Your new workspace will be created


7. Expand the created workspace and identify your repository package , right click on it and chooseCheck Out.

Tip : Checked out package will have tick mark like thisCheck_Out


8. After checking out, select your package and press Cntrl+N (or) Right click → New → Other.

9. In the New window search with XS OData and select XS OData FileXS_OData_Fileand hit Next.


10. In the New XS OData Service window, enter File name, choose Template as “Basic” and hit Finish.


11. A new HANA XS OData service will be created with predefined syntax like below.


12. We are not going to use the predefined syntax as it, remove that and copy and paste the below code


13. Lets see what the HANA XS OData service file contains

  1. Service definition starts with syntax – service {  }.
  2. you have to provide the full path of attribute view where it is stored and its name.
  3. as  –  you have to provide the Entity Type name.
  4. with – columns of attribute view you want to expose.
  5. key – key of the attribute view.

14. Activate the service by clicking on Active Button Activateon the tool bar.  You can also right click on the package and choose Activate / Activate All.


15. Before testing the service we need to first expose our package to do so we need to create two files in our package they are .xsaccess and .xsapp. Right click on your package → New → File


16. Copy and paste below code into newly created .xsaccess file.


17. Again repeat the Step-17 to create .xsapp file. This file will be a blank file.

18. Activate all objects in the package. Now we are ready for testing.HANA XS OData services are accessed by URL.Open your chrome browser and enter URL of your XS OData service in the below format.


18. You will see the XS OData service metadata output like below in the browser.


19. Now append the entity name “EmployeeCollection” to the above URL and you will see the data of the attribute view like below.



20. We you have successfully exposed HANA attribute view as XS OData service.Now we can use this XS OData service in SAPUI5/SAP Fiori applications to display the data in UI.

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo SAKRIYANAIK NK

      Excellent blog - the same odata services can also consumed in SAP Cloud API management and SAP Cloud CPI - via SAP Cloud connector  and will be used for integrating with External cloud applications.

      This saves lot of time and money for the customers!!