Skip to Content

Creating an OData Service with an Entity Relationship

Creating an OData Service with an Entity Relationship
You will learn

The first example of this exercise was very simplistic because it only exposed one database table as a single entity. Often you need to also represent relationships between multiple entities. For example you might want to build an OData service which has both the Purchase Order Header and Items. For this you would build a 1:many relationship between the two entities.

jung-thomasThomas JungJanuary 5, 2021
Created by
September 6, 2016


  • 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: Create a Simple OData Service
  • Step 1

    Create an OData service called purchaseOrders.xsodata

    service {
    	as "POHeader" navigates ("Items" as "POItem");
    	as "POItem";
    	association "Items"
    	principal "POHeader"("PURCHASEORDERID")
    	multiplicity "1"
    	dependent "POItem"("HEADER.PURCHASEORDERID")
    	multiplicity "*";

    And looks like this:

    Association OData

    And if you see the error marker, you can safely ignore it. It is unfortunately a false error.

  • Step 2

    Run the core_xsjs module first, and then the web module. Replace the end of the URL to access the OData service and notice that the base service definition now has two entities.


    The PO Header data now has a hyperlink relationship to the item entity.

  • Step 3

    Associations can be an excellent way to load child elements on demand; however there is also an option to expand the children details in place so that all levels can be retrieved with one request. Test the service again using the same steps as in the previous section of this exercise. This time add $expand=POItem to the end of the URL. You will then see that all the items are embedded within each header record (i.e., it is no longer deferred as in the previous test).

Back to top