topic Re: delete comparing 2 internal tables in Application Development and Automation Discussions

delete comparing 2 internal tables

Former Member — Wed, 30 Sep 2009 14:44:08 GMT

Hi,

Is there any one line syntax to delete entries from an internal table comparing the fields of another internal table.

Regards

mac

Re: delete comparing 2 internal tables

Former Member — Wed, 30 Sep 2009 14:49:13 GMT

I dont think you can achieve it using any one line syntax.

u need to use this

DELETE itab [WHERE log_exp].

Use this statement inside another loop with which u want to compare the table whose lines need to be deleted.

кu03B1ятu03B9к

Edited by: Kartik Tarla on Sep 30, 2009 8:19 PM

Re: delete comparing 2 internal tables

Former Member — Wed, 30 Sep 2009 14:51:54 GMT

U need to insert the table to be deleted in a loop of main table:

LOOP AT ITAB1.
   DELETE ITAB2 WHERE FIELD = ITAB1-FIELD.
ENDLOOP.

Max

Re: delete comparing 2 internal tables

Former Member — Wed, 16 Dec 2009 10:44:52 GMT

Solved myself

Re: delete comparing 2 internal tables

Former Member — Wed, 09 Mar 2011 05:14:27 GMT

can you please tell me how did you solve it.

Re: delete comparing 2 internal tables

Amit91 — Fri, 28 Nov 2014 10:10:40 GMT

Hi,

You want to delete all records from it_tab_child which are present in it_tab_parent i.e. child has 100 records but you want to delete 50 records which are present in parent.

SORT it_tab_child BY key_field.

LOOP AT it_tab_parent ASSIGNING <fs_parent>.

"Warning: it_tab_child cannot have duplicate record on key_field!!!

READ TABLE it_tab_child ASSIGNING <fs_child> WHERE key_field = <fs_parent>-key_field

BINARY SEARCH.

IF sy-subrc EQ 0.

<fs_child>-key_field = space.

ENDLOOP.

DELETE it_tab_child WHERE key_field = space.

***This code has ~40% more efficient than deleting records inside the loop.

Re: delete comparing 2 internal tables

matt — Sat, 29 Nov 2014 07:23:15 GMT

Make it_tab_child a HASHED table with a unique key, and it'll be even faster.

SORT/READ/BINARY SEARCH is so last millennium.

Re: delete comparing 2 internal tables

kathylau007 — Tue, 07 Mar 2023 10:21:22 GMT

IF lt_tab1[] IS NOT INITIAL.

DATA(lr_vbeln) = VALUE psi_we_selopt_tt( FOR ls_tab1 IN lt_tab1
( sign = 'I'
option = 'EQ'
low = ls_tab1-vbeln ) ).

DELETE lt_tab2 WHERE vbeln in lr_vbeln.

ENDIF.