Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 
Former Member

Here is a step by step guide on how to build an RFC based OData service with multiple selection (input) values.This document would help developers who are new to the Odata services. You can also find few sample queries at the end of the document.

The business requirement given here is to build an OData service which can retrieve shopping cart information from the system based on a combination of input fields (single and multiple values).

Below is the list of input fields:

Selection fields

Multiple values?

User ID (Requestor)

User ID (Creator)

Creation Date  (From)

Creation Date  (To)

Product Category Code


Vendor Number


Shopping Cart Number

External Req Number

Shopping Cart Status

Supplier Part Number

Cost Center

Line Item Description

Company Code

Purchasing Group



Below is the expected output:

Display fields

Shopping Cart Number

Creation Date

Shopping Cart Status

Shopping Cart Requestor

Shopping Cart Creator

Shopping Cart Description

Total Price of Shopping Cart

Process Level

Current Work Agent


Create a RFC function module in the backend system with below parameters as input

For the input parameters that need multiple values to be supplied, create them as range table types.


Go to SAP Netweaver Gateway Service builder (SEGW) and create a project.


Click on Data Model -> Import -> RFC/BOR Interface


Enter the Entity Type name and the RFC details.


Select all the fields to be used in the entity type


Make the Shopping Cart ID as the key field.


Change the field names and set rest of the attributes as required.


Now create an entity set and link the entity type to the entity set.


Now go to Service Implementation and create a GetEntitySet (Query) operation


Do the mapping between entityset and RFC for both input and output fields.

The fields which are of range table type would appear with a [ ] sign.


After all the mapping is completed, click on the “Generate” button (highlighed below in yellow).

This will generate all the runtime artifacts for this service as shown below.


Now go to tcode /IWFND/MAINT_SERVICE in the Netweaver gateway system and search for the service.


Double click on the service ZGSTS_ITM_SC_PO_DISPLAY_SRV to add and activate it.

ICF Nodes and System Aliases are populated. Now the service is activated.

Now we can construct queries in order to retrieve the shopping cart information using this OData service (few examples given below):

/sap/opu/odata/sap/ZGSTS_ITM_SC_PO_DISPLAY_SRV/SCHeaderCollection?$filter= IN_ShopCartId eq '1000045468' and IN_IsidRequestor eq 'USMANAGER6'

/sap/opu/odata/sap/ZGSTS_ITM_SC_PO_DISPLAY_SRV/SCHeaderCollection?$format=json&$top=10&$filter= IN_ShopCartId eq '1000045468'and IN_IsidRequestor eq 'USMANAGER6'

/sap/opu/odata/sap/ZGSTS_ITM_SC_PO_DISPLAY_SRV/SCHeaderCollection?$filter= IN_IsidRequestor eq 'USEMPLOYEE15' and IN_CreateDate eq datetime'2013-12-01T00:00:00' and IN_CreateDateTo eq datetime'2013-12-31T00:00:00'

/sap/opu/odata/sap/ZGSTS_ITM_SC_PO_DISPLAY_SRV/SCHeaderCollection?$filter= IN_IsidRequestor eq 'USEMPLOYEE15' and (IN_CategoryId eq '10100000' or IN_CategoryId eq '43211507')

/sap/opu/odata/sap/ZGSTS_ITM_SC_PO_DISPLAY_SRV/SCHeaderCollection?$format=json&$filter= IN_IsidRequestor eq 'USEMPLOYEE15' and (IN_VendorId eq '0001010250' or IN_VendorId eq '0001201715') and (IN_PurGroup eq '101' or IN_PurGroup eq '105') and IN_ItemDesc eq '*MOUSE*'

Labels in this area