Skip to Content
Author's profile photo Chandrashekhar Mahajan

Creating OData service based on Search Help


With SAP NW Gateway SP08, there is an option to create OData service by importing search help. Please refer

You will find some of the details at

In this document, I will demonstrate creation of OData service based on search help BRF_SH_CUSTOMID (Search Help for Flight Customers).


1) Create project ZSEARCH_HELP. Right click on Data Model and Select Import–>Search Help. Provide Entity type name FlightCustomer and provide Search help (from F4 ) as BRF_SH_CUSTOMID and click Next button.


2) Select parameters from RESULT_LIST which you want to include in search help and click Next. Here, I will select all parameters as shown below.


3) Mark fields which you want to be key properties. Here I will select property ID as key property. Click Finish.

Note that Create Default Entity Set is marked by default and hence we need not to create Entity set as wizard will create it.


As result of this step, entity type and entity set will get created as displayed below,


4) Now we will do service implementation for Query and Read operation. first let’s do it for Query operation. Expand Service Implementation folder and right click on GetEntitySet(Query) operation and select Map to Data Source. Select Data Source Attributes as displayed below.


Press Propose Mapping button which will enable system to select mapping automatically.


5) Now let’s map GetEntity (Read) operation. Right click and select Map to Data Source. Select Data Source Attributes as mentioned above. Click on propose Mapping but as this is read operation, we need to provide input key to read it.Click on Insert Row button and add input key property. here I will select ID. then drag the ID parameter from right screen to Data Source Parameter. This will provide input key as ID.


Now Check project consistency and if everything is okay then click on Generate Runtime Objects. This will generate runtime artifacts. Finally do the service maintenance which involves service registration. Click on Maintain which will open window for Gateway Client.

Service Testing

Let’s test Query operation with request URI /sap/opu/odata/sap/ZSEARCH_HELP_SRV/FlightCustomerSet

It will display the search help result as below. you can use $count, $top etc query parameters.


Now let’s test Read Operation with URI /sap/opu/odata/sap/ZSEARCH_HELP_SRV/FlightCustomerSet(‘00000017’). Output will be as below,


Closing Remarks

With the import wizard, it is very simple to create OData service based on elementary search help. please keep in mind below constraints. Reference

The following are the constraints:

  • Only elementary search helps are supported. Collective search helps are not supported.
  • Search helps that call UI in their exit function are not supported, as this cannot be validated by the Service Builder.
  • At runtime, a query operation that is based on a search help data source can retrieve a maximum of 9,999entries.

Also note that

Only the search helps in the local SAP system can be used as a data source.

Please feel free to put your comments and suggestions.

Happy learning and Coding!

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo REKHA D R
      REKHA D R

      Hello ChandraShekhar,

      How can I use SAP NetWeaver Embedded Search Search Models ( use transaction ESH_MODELER) to create Odata Sercives ?

      SAP Fiori Search - SAP Fiori for SAP Business Suite - SAP Library

      says Fiori uses Embedded Search. But how to make the model available to Odata service ?



      Author's profile photo Vishnu Pankajakshan Panicker
      Vishnu Pankajakshan Panicker

      how to access backend search help



      Author's profile photo Deborshi De Sarkar
      Deborshi De Sarkar


      I am trying to follow this document. But in my case here no options like Search Help from Data Model-> Import ..

      Can you please help me on this ..

      Thanks !!

      Author's profile photo Sankara Bhatta
      Sankara Bhatta

      super..super..super 🙂

      Author's profile photo Sasidhar Velupula
      Sasidhar Velupula

      Hi Chandra,

      Thanks for the detail steps on topic related to oData service.

      I had created similar F4 help in odata service, created entity set for standard search help and attached to UI5 input field. It is working fine but there are 6 fields in output of search help but in UI5, it is displaying only one field in search help output. So please let me know if there are any settings needs be done to appear ALL fields on search help output table. Thanks

      Sasidhar V


      Author's profile photo Ranjani Sekar
      Ranjani Sekar

      Hi Chandrasekhar,

      thanks for the details.

      i need to import Collective search help for Vendor but i am getting error,

      is there any other way to import Collective Search helps?

      Please help.

      Kind Regards,

      Ranjani Sekar