Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
Showing results for 
Search instead for 
Did you mean: 


You should have done the following steps:

#1 - OData CRUD Crash Course - Query

Step-by-Step Procedure

- Building Read operation

1. In SAP transaction SEGW, expand a project folder and open TravelAgencySet. Click on GetEntity (Read) and choose Go to ABAP Workbench. As the first implementation, you'll see the popup.

2. Click on the *_DPC_EXT folder. The right pane should show the Class Interface shown in the next step.You'll see the list of the methods. Scroll down - click and focus on the "..._GET_ENTITY" and press the Redefine icon.

Tip: Make sure if your editor is in edit mode with the icon. Redefine icon is .

3. Delete the commented out lines of code. You have an empty implementation.

4. If you click "Signature" text, you'll see the in & out parameters of this method. We'll implement so that it returns "ER_ENTITY" parameter.

Here's implementation:

   Naming convention:
   l - local scope
   t - table
   s - structure

03   DATA: ls_key_tab   TYPE /iwbep/s_mgw_name_value_pair,
04         ls_entityset TYPE stravelag.
06 * key is TravelAgencySet(agency#)
07   READ TABLE it_key_tab INTO ls_key_tab INDEX 1.
09   SELECT SINGLE * FROM stravelag INTO ls_entityset WHERE agencynum = ls_key_tab-value.
11   er_entity = ls_entityset.
13 endmethod.

#03 declares a variable which holds the "key" value in the URL - such as ../TravelAgencySet('12345678'). #07 picks up the key value. #09 selects an entity value with they key "agancynum". #11 sets the returning value which will be sent in OData.

Make sure you activate it by icon.

- Testing Read operation

1. Run the Query operation.

2. In a response body, choose an entity you want to read - find the OData URL in <id> tag.

3. Paste the URL and do the HTTP GET.

4. You should receive a response body content of the entity. The Read operation executed successfully!

What's next? You can choose either of:

- Create operation

- Update operation

- Delete operation

List of H2Gs

1 Comment