topic Re: delete itab in Application Development and Automation Discussions

delete itab

Former Member — Tue, 07 Nov 2006 15:15:29 GMT

Hello Experts,

I have to delete some of the itab records based on a condition. There are 2 internal tables.

ITAB1:

EBELN EBELP MATNR LIFNR

45001 00010 10044 10101

45002 00010 10044 10101

45003 00010 10044 10222

45004 00020 10044 10222

45005 00030 10044 10350

45006 00040 10044 10350

ITAB2:

EBELN EBELP MATNR LIFNR

000000 00000 10044 10101

000000 00000 10044 10222

now i have delete the records of ITAB1 where <b>ITAB1-LIFNR <> ITAB2-LIFNR.</b>

Can you please suggest me the way.

Thanks a lot for the help.

Re: delete itab

Former Member — Tue, 07 Nov 2006 15:17:18 GMT

LOOP AT ITAB2.
  DELETE ITAB1 WHERE LIFNR <> ITAB2-LIFNR.
ENDLOOP.

Message was edited by: Matt Nagel

Re: delete itab

Former Member — Tue, 07 Nov 2006 15:18:34 GMT


SORT itab2 BY lifnr.
LOOP AT itab1.
  READ TABLE itab2 WITH KEY lifnr = itab1-lifnr
                            BINARY SEARCH.
  IF sy-subrc <> 0.
    DELETE itab1.
  ENDIF.
ENDLOOP.

Re: delete itab

Former Member — Tue, 07 Nov 2006 15:18:57 GMT

Hi Sey,

Loop at ITAB1 into wa_itab1.

loop at i_tab2 into wa_itab2 where ITAB2-LIFNR <> ITAB1-LIFNR.

delete i_tab1 from wa_itab1.

endloop.

reward points if this helps.

Manish

Re: delete itab

Former Member — Tue, 07 Nov 2006 15:20:32 GMT

sort itab1 by lifnr.

sort itab2 by lifnr.

Loop at itab2.

read table itab1 where lifnr = itab2-lifnr.

if sy-subrc <> 0.

delete from itab1 where index = sy-index.

endif.

endloop.

Re: delete itab

Former Member — Tue, 07 Nov 2006 15:21:29 GMT

Hi,

sort itab2 by ebeln ebelp matnr lifnr.

Loop at itab1.

gv_index = sy-tabix.

read table itab2 with key ebeln = itab1-beeln

ebelp = itab1-ebelp

matnr = itab1-matnr

lifnr = itab1-lifnr.

if sy-subrc <> 0.

delete itab1 index gv_index.

endif.

endloop.

Hope this will help you.

Regards,

Satya.

Re: delete itab

Former Member — Tue, 07 Nov 2006 15:23:32 GMT

Hi,

LOOP at itab1 into lw_itab1.

read table itab2 into lw_itab2

with key lifnr = lw_itab1-lifnr.

If sy-subrc<> 0.

delete itab1.

endif.

ENDLOOP.

If helpful pl reward.

Cheers.

Re: delete itab

Former Member — Tue, 07 Nov 2006 15:26:38 GMT

thnk you all a ton.