Skip to Content

Creating OData Services

0 %
Creating OData Services
// Explore More Tutorials

Creating OData Services

20 min.
Creating OData Services(Core Data Services)

You will learn

  • How to create OData Services based on the exposure of consumption views

Step 1: Preview the consumption view

In this step you will preview the content of the consumption view ZXSHC_AIRLINEQUERY**

Make sure that your Eclipse Framework is open in the ABAP perspective. In the project explorer tab select ZXSHC_AIRLINEQUERY in the sub folder Core Definitions. Right-click on that folder, select Open With and then Data Preview. In the open tab on the right side, the content of the consumption view will be displayed.

Steps to preview the consumption view

Switch back to the tab ZXSHC_AIRLINEQUERY of the code editor. Mouse over the small icon preceding line 6. In the new displayed embedded window the following text is displayed: ...Service ZXSHC_AIRLINEQUERY is created. Activation to be done manually(/IWFND/MAINT_SERVICE/)[OData Exposure] ... . The command /IWFND/MAINT_SERVICE has to be executed in the ERP System for the service Exposure.

Command to execute the preview in ERP
Step 2: Service registration OData activation and OData Exposure

Open the ERP System SHA from the SAP Log on, enter the command (transaction) /IWFND/MAINT_SERVICE and execute it.
Service registration command

The Activate and Maintain Services window will be displayed. This is where you register the consumption view and expose it as OData.

Execute the application for service registration in ERP
Step 3: Add service

On the Activate and Maintain Services window , click the Add Service icon.

Execute the application for service registration

A new window, Add Selected Services will open. In that window, maintain the System Alias by pressing the F4-Help and selecting LOCAL_PGW in the system alias pop-up window.

File system is filled with the alias Local

Enter ZXSHC_AIRLINEQUERY_CDS as the Technical Service Name (the name of the service).

Service technical name is filled

Press the icon Get Services, then select Add Selected Services. Then click Enter to complete this step.

Get the serviceClick to get the service
Step 4: Set package assignment

The pop-up window Add Service is opened with pre-filled information; therefore, you don’t need to make any change. Click Local Object icon to fill the package assignment (this will be filled with $TMP) and press Enter to continue. An information pop-up with the information Service 'ZXSHC_AIRLINEQUERY_CDS' was created and it metadata was loaded successfully will appear. Click Enter to complete the step.

Assignment of package to local objectCreation of service successful
Step 5: Verify OData association

Switch back to the ABAP perspective. Now if you hover the icon (number 1 in the screenshot below) on the code editor you will see in the pop-up window that the view has been exposed as OData. Furthermore, if you press the Check ABAP Developer Object icon (number 2 in the screenshot).

Mouse hover

then hover the icon on the code editor a new pop-up window will confirm that the OData service has been generated.

Mouse hover

In the pop-up window on the code editor, click on the link labeled OData-Service

Link the OData service

Your default browser will be launched.

Launch the bowser
Step 6: Log in

You are now requested to log in. Enter SHA for the user name. Use your current ERP System password. Click Enter.

Enter the login

If you get this screen, everything is working properly and the service has been correctly exposed.

Display the OData service

If you replace the URL extension ?sap-ds-debug=true with $metadata and press Enter , detailed information about the service will be displayed.

Display the meta dataDisplay the meta data
Step 7: Check complete code

If you now replace the above URL extension with the query data name zxshc_Airlinequery followed by / , more detailed information as well as service entities will be displayed

The queryDisplay the query

If you replace the URL with $count and click Enter, the number of entries will be displayed.

Use the count statement for displaying the queryDisplay of the number of queries


Although SAP offers trial editions for free you will still have to cover the costs for running these trial editions on AWS.
This tutorial is part of the S/4HANA Core Data Services. If you want to learn more about the OData, see the OData documentation.

Next Steps

Back to top