oData service which consumes RFC

OData with RFC function module.

 

 

In this step-by-step post we will create oData project which consumes RFC: BAPI_FLIGHT_GETLIST. After getting input from frontend this oData service will execute and send filtered records back to frontend as output.

Here we will take AIRLINE as input: 

and Table parameter FLIGHT_LIST will be used as output:

Step 1: To create oData project Goto TCode: SEGW → Click on create button

Step 2: Provide the Project name and description

Step 3: Your project is created and you’ll get the below screen

Step 4: Now we need to create Entity and Entity set: Right click on Data Model → Import → RFC/BOR Interface

Step 5: Provide Entity name and BAPI name as below. Select Remote radiobutton and Provide RFC destination if your destination is not local → Click on Next.

Step 6: Select  FLIGHT_LIST here and click on next.

Step 7: As we have discusses earlier, at least one key field is necessary, so selecting here AIRLINEID as key and select default entity set checkbox. 

Step 8: Entity Type and Entity Set are created now.

Step 9: Now we need to maintain mapping between oData service and BAPI. Expand Service Implementation folder → Right click on GetEntitySet (Query) → Click on Map to Data Source.

Step 10: Provide Data Source type = RFC & Name = BAPI_FLIGHT_GETLIST.

Step 11: We will get the following screen

Drag the respective fields of FLIGHT_LIST to Data Source Parameter to maintain mapping.

Step 12: Mapping for output fields is done in above step, now we need to do mapping for input field AIRLINEID.

Click on Insert Row button to add a new row.

Do F4 and select Airlineid.

Drag Input parameter AIRLINE and drop to newly added field.

Now mapping is done.

Step 13: Generate Runtime Artifacts by clicking on below marked button.

Step 14: Click on OK and save.

Step 15: You can check the auto generated code by this mapping in _GET_ENTITYSET method of Data Provider Base Class ( _DPC Class ).

Step 16: Now we need to register the Service.

GoTo the TCode: /IWFND/MAINT_SERVICE or follow below path

Click on Add Service button

Step 17: Provide System Alias name and Technical Service Name (you can get it from Runtime Artifacts) → Press Enter or Click on Get Services → Select your service and click on Add Selected Services button. 

Step 18: To test the oData service, select your Service and go to the TCode- /IWFND/GW_CLIENT or click on SAP Gateway Client.

Step 19: You’ll get the following screen → Click on EntitySets button and select your entity.

URL has been updated.

After executing, we get the following output.

Step 20: We can provide input values through filter keyword in URL.

URL = /sap/opu/odata/sap/ZMTEST1_RFC_SRV/FLIGHTSet?$filter=Airlineid eq ‘AA’

 

---