---
parser: v2
author_name: Thomas Jung
author_profile: https://github.com/jung-thomas
primary_tag: products>sap-hana
tags: [  tutorial>intermediate, topic>odata, products>sap-hana, products>sap-hana\,-express-edition   ]
slug: xsa-xsodata
canonical_url: https://developers.sap.com/tutorials/xsa-xsodata
---
# SAP HANA XS Advanced, Creating a Simple OData Service
<!-- description --> Creating a Simple OData Service

## Prerequisites  
- This tutorial is designed for SAP HANA on premise and SAP HANA, express edition. It is not designed for SAP HANA Cloud.
- **Proficiency:** Intermediate
- **Tutorials:**
- [Import tables and large Datasets](https://developers.sap.com/tutorials/xsa-import-shine-data.html)
- [SAP HANA XS Advanced, Creating a Node.js Module](https://developers.sap.com/tutorials/xsa-xsjs-xsodata.html)

## Next Steps
- [Create and OData Service with Entity Relationship](https://developers.sap.com/tutorials/xsa-xsodata-entity.html)

## You will learn  
Create a simple OData service connecting to your table and data.
## Time to Complete
**10 Min**.

---

### Create new file


Right mouse click on the `core_xsjs/lib/xsodata` folder and choose `New->File`.

![New file](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-xsodata/1.png)

Enter the name as `businessPartners.xsodata` and click **OK**.

![file name](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-xsodata/2.png)


### Expose business partner table


You want to define an OData service to expose the business partner table. This table is in defined in the `BusinessPartners.hdbtable` artifact.

![MD.BusinessPartners](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-xsodata/3_1.png)

The syntax of the XSODATA service is relatively easy for this use case. You need only define a namespace (your package path), the name of the HANA Table you will base the service from (`MD.BusinessPartner`) and the name or alias of the OData entity (`BP`). Therefore the content of the XSODATA file would be:

```text
service {
"MD.BusinessPartner" as "BusinessPartners";
}
```

![odata service](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-xsodata/3.png)

You can ignore the error marker in the `xsodata` editor.  If it a false error, unfortunately.


### Save and run


Save the file and build the Node.js `core_xsjs` module. Then run the `html5` module (defined as `web` earlier). Once it opens a separate browser tab, change the URL path to `/xsodata/businessPartners.xsodata?$format=json` to test this new service. The resulting document describes the service entities.  You have the one entity named `BP`.

![test oData](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-xsodata/4.png)


### Append URL


You can now adjust the URL slightly and add the `/$metadata` parameter to the end of it.

For Example: `/xsodata/businessPartners.xsodata/$metadata`

You can see the field descriptions for all the attributes of the OData service.

![access metadata](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-xsodata/5.png)


### View data


In order to view the data of the entity, you would append `BP` to the end of the URL:


For Example:
`/xsodata/businessPartners.xsodata/BusinessPartners?$format=json`

You are now able to see the data from the `businessPartner` table.  

![Business Partner data](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-xsodata/6.png)




### Try other parameters




You can also experiment with standard OData URL parameters like $top, $skip, or $filter.  These options are interpreted and handled by the OData service for you.  You get complex service handling without any coding. For example the following URL would return only three business partner records and would skip the first five records.  Such parameters are helpful when implementing server side scrolling, filtering, or sorting in table UI elements.



For Example:
`/xsodata/businessPartners.xsodata/BusinessPartners?$top=3&$skip=5&$format=json`


![output](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-xsodata/7.png)