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

#1 - OData CRUD Crash Course - Read

Step-by-Step Procedure

- Building Update operation

1. In SAP transaction SEGW, expand a project folder and open TravelAgencySet. Click on Update 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 "..._UPDATE_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. 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
   v - variable

03   DATA: ls_entityset    TYPE stravelag,
04         ls_key_tab      TYPE /iwbep/s_mgw_name_value_pair,
05         lv_error_entity TYPE string.
07   io_data_provider->read_entry_data( IMPORTING es_data = ls_entityset ).
09 * key is TravelAgencySet(agency#)
10   READ TABLE it_key_tab INTO ls_key_tab INDEX 1.
12 * make sure the value matches with the one in OData payload
13   IF ls_key_tab-value EQ ls_entityset-agencynum.
15 * new data
16     UPDATE stravelag FROM ls_entityset.
18     IF ( sy-subrc = 0 ).
19 * entity found and updated
20       er_entity = ls_entityset.
21     ELSE.
22 * entity not found
23       CONCATENATE iv_entity_name
24                   '('''
25                   ls_key_tab-value
26                   ''')'
27         INTO lv_error_entity.
28       RAISE EXCEPTION TYPE /iwbep/cx_mgw_busi_exception
29         EXPORTING
30           textid      = /iwbep/cx_mgw_busi_exception=>resource_not_found
31           entity_type = lv_error_entity.
32     ENDIF.
33   ENDIF.
35 endmethod.

#05 declares a variable which can have the error message if the Update operation failed. #07 picks up the new entity value which comes in from the OData client. #10 picks up the key value of the updating entity - such as ../TravelAgencySet('12345678'). #13 checks if the key value in the URL and the agencynum value in the OData payload is the same value. #16 does a simple update command. If the command goes successful, the sy-subrc value should be 0. #23 - #32 sets the user-friendly error message saying the entity doesn't exist in the TravelAgency table.

Make sure you activate it by icon.

- Testing Update operation

1. Do the Query operation. In the query step, set the two HTTP Header parameters - these are required to do any data modification (either Create/Update/Delete) against OData services in SAP Gateway.

X-CSRF-Token = Fetch

Content-Type = application/atom+xml; charset=UTF-8

2. In a response header, you'll find the token value in X-CSRF-Token. Copy it. (Note: the token will keep valid until the browser gets closed)

3. Replace the copied value with "Fetch" string. Now your REST client is ready for Update operation via HTTP PUT.

4. Choose one of the entities you want to update - in <id> tag.

5. Run the Read operation.

6. You should obtain the entity value in a response body. Copy it.

7. And paste it in the Body payload.

8. By making use of this body content, we'll update the existing entity. For this case just change the <d:Name> value to a new one. You can change other values if you like - but make sure the XML tag is well formed by a set of opening and closing tags.

9. Let's issue by HTTP PUT. The URL is /TravelAgencySet('agency#').

10. You should receive HTTP 204 No Content. The Update operation executed successfully!

11. By the Read operation, you can make sure the value in the TravelAgency table has been really updated.

What's next? You can choose either of:

- Create operation

- Delete operation

List of H2Gs