Odata (BYD)

SAP Business ByDesign now offers OData service, come take a look how you can create your own servce

What is OData?

OData (Open Data Protocol) is a REST-based protocol for querying and updating data itis built on standardized technologies such as HTTP, Atom/XML, and JSON.  OData sets itself apart from other REST-based web services by providing a uniform way to describe both the data and the data model.

OData SAP Business ByDesign

The OData modeler enables partners and customers to create self-definer OData services to access and modify PSM released entities. (e.g. in order to build mobile Add-On applications like SAP Manager Approvals or SAP Project Cockpit)

You will need

1.SAP Business By Design Instance (contact us, if you need one)

Create your OData service

  1. Assign Odata modeler to the Business User
  2. Under Application and User Management
    1. Click OData Services
  3. Create a new OData Service
    1. Click “SAP OData Services” drop down
    2. Click “Custom OData Services”
    3. Click “New”
    4. Type a service name
    5. Click “Save and Close” drop down
      1. Click “Save and Open” (New OData Editor will open)
    6. Check “No Authentication Check”
    7. In the Entity Type section
      1. Select “BO Name”
    8. Select the required fields
    9. Click “Save”
    10. Click “Activate”
  4. Click your new “Service URL”
  5. Copy “EntitySet” “Name” from the displayed Sales Order Metadata
  6. Replace the entity name in the URL

Format & Filter


  1. Add “$format=json” at the end of your URL
    (e.g. https://myxxxxx.sapbydesign.com/sap/byd/odata/cust/v1/ms_app/SalesOrderCollection?$format=json)


  1. Add “$filter=<SearchField>eq'<SearchValue>’ at the end of your URL
    (e.g. https://myxxxxx.sapbydesign.com/sap/byd/odata/cust/v1/ms_app/SalesOrderCollection?$format=json&$filter=ID eq ‘1000’)

Contact Us!

Hope you enjoyed the article, if you need help with integration please don’t hesitate to reach out to us.

We have skills in:

Integrating SAP BYD with your software
Customizing SAP BYD font-end & back-end
And much more…

Leave a Reply

Your email address will not be published. Required fields are marked *

© 2020 Copyright :mindsight