topic Delete DB table rows do not exist in ITAB in Application Development and Automation Discussions

Delete DB table rows do not exist in ITAB

ekekakos — Tue, 19 Apr 2022 10:20:26 GMT

I have a ztable with 3 rows,

I fill an ITAB with this 3 rows .

Then the user deletes the row with material 202 from the ITAB.

So now the ITAB has the following records:

How can I update the DB ZTABLE in order to have the same records as the ITAB.

1 way is to delete the records from ZTABLE and then MODIFY it from the ITAB.

So my question is, how to DELETE the extra row from ZTABLE in order to have the same number of rows with ITAB?

Thanks

Elias

Re: Delete DB table rows do not exist in ITAB

FredericGirod — Tue, 19 Apr 2022 12:14:49 GMT

Could you please, post your code, using the beautoful button [CODE].

Or just check the transaction ABAPDOCU, enter the keywork DELETE

Re: Delete DB table rows do not exist in ITAB

Sandra_Rossi — Tue, 19 Apr 2022 13:12:15 GMT

Lock the table (to avoid concurrent update by other user)
Read the database table into internal table
Logic to change the lines of the internal table
Compare database table versus internal table
Update database according to deletions, insertions, modifications
Unlock the table

Alternatively, the step 4 can be avoided if the logic records the type of operation for each changed line (i.e. delete, insert, modification)

Re: Delete DB table rows do not exist in ITAB

ekekakos — Tue, 19 Apr 2022 13:24:32 GMT

Thanks Sandra. My problem is in step No 5. The Insertion & Modification are covered by the command MODIFY. But how to tell the SAP: DELETE the lines from DB ZTABLE that do not exist in ITAB or KEEP only the lines that exist in ITAB?

Re: Delete DB table rows do not exist in ITAB

lemoreno — Tue, 19 Apr 2022 16:27:12 GMT

Hi Elias,

I think you can do this:

Create 2 internal tables, one of them with all selected records, the other one with those records that were deleted by the user.

DATA: ti_selected TYPE STANDARD TABLE OF tp_table,
      ti_deleted  TYPE STANDARD TABLE OF tp_table.

SELECT field1, field2,....
INTO @ti_selected
FROM dbtable.

*When the user deletes a row, move it to TI_DELETED, then delete it from TI_SELECTED.
APPEND es_selected TO ti_deleted.
DELETE ti_selected WHERE .... .

*At the end of the process, delete the data base table with the records in TI_DELETED.
DELETE dbtable FROM TABLE @ti_deleted.

*Modify the records with TI_SELECTED
MODIFY dbtable FROM TABLE @ti_selected.