Steps to build an RFC based OData Service with multiple selection values

[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	Yes
Vendor Number	Yes
Shopping Cart Number
External Req Number
Shopping Cart Status
Supplier Part Number
Cost Center
Line Item Description
Company Code
Purchasing Group	Yes
Plant

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

Step1.

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.

Step2.

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

Step3.

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

Step4.

Enter the Entity Type name and the RFC details.

Step5.

Select all the fields to be used in the entity type

Step6.

Make the Shopping Cart ID as the key field.

Step7.

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

Step8.

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

Step9.

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

Step10.

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.

Step11.

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.

Step12.

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

Step13.

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*'