#1 – OData CRUD Crash Course – Delete

Prerequisites

You should have done the following steps:

#1 – OData CRUD Crash Course – Query

Step-by-Step Procedure

– Building Delete operation

1. In SAP transaction SEGW, expand a project folder and open TravelAgencySet. Click on Delete 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 “…_DELETE_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.

Here’s implementation:

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

01 method TRAVELAGENCYSET_DELETE_ENTITY.
02
03   DATA: ls_entityset    TYPE stravelag,
04         ls_key_tab      TYPE /iwbep/s_mgw_name_value_pair,
05         lv_error_entity TYPE string.
06
07 * key is TravelAgencySet(agency#)
08   READ TABLE it_key_tab INTO ls_key_tab INDEX 1.
09
10   DELETE FROM stravelag WHERE agencynum = ls_key_tab-value.
11
12   IF ( sy-subrc = 0 ).
13 * delete completed
14   ELSE.
15 * entity not found
16     CONCATENATE iv_entity_name
17                 '('''
18                 ls_key_tab-value
19                 ''')'
20       INTO lv_error_entity.
21     RAISE EXCEPTION TYPE /iwbep/cx_mgw_busi_exception
22       EXPORTING
23         textid      = /iwbep/cx_mgw_busi_exception=>resource_not_found
24         entity_type = lv_error_entity.
25   ENDIF.
26
27 endmethod.

#05 declares a variable which can have the error message if the Delete operation failed. #08 picks up the key value of the deleting entity – such as ../TravelAgencySet(‘12345678‘). #10 does a simple delete command. If the command goes successful, the sy-subrc value should be 0. #16 – #24 sets the user-friendly error message saying the entity doesn’t exist in the TravelAgency table.

Make sure you activate it by icon.

– Testing Delete 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 Create operation via HTTP POST.

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

5. Run the Delete operation.

6. You should receive HTTP 204 No Content. The Delete operation executed successfully!

What’s next? You can choose either of:

– Create operation

– Read operation

– Update operation

List of H2Gs