topic Re: Deleting from Internal table..... in Application Development and Automation Discussions

Deleting from Internal table.....

Former Member — Tue, 19 Feb 2008 11:22:43 GMT

Hi All,

I have two internal tables with same structure like: IT_REC_LIST and IT_REC_LIST_DEL.

I have 10 records in this internal table: IT_REC_LIST and same 5 records in this internal table: IT_REC_LIST_DEL. I don’t have any key fields.

So I want to delete those 5 records from IT_REC_LIST. Could you please let me know hw to write the code, when I write like below its going for dump.

DELETE IT_REC_LIST [] FROM IT_REC_LIST_DEL [].

Akhitha.

Re: Deleting from Internal table.....

Former Member — Tue, 19 Feb 2008 11:28:14 GMT


loop at IT_REC_LIST_DEL.
  DELETE IT_REC_LIST FROM IT_REC_LIST_DEL .
endloop.

Re: Deleting from Internal table.....

Former Member — Tue, 19 Feb 2008 11:33:03 GMT

Hello,

You can do like :


loop at IT_REC_LIST .
read table IT_REC_LIST_del with key field1 = IT_REC_LIST-field1.
if sy-subrc eq 0.
delete IT_REC_LIST. 
endif.
endloop.

<REMOVED BY MODERATOR>

Vasanth

Edited by: Alvaro Tejada Galindo on Feb 19, 2008 5:28 PM

Re: Deleting from Internal table.....

kesavadas_thekkillath — Tue, 19 Feb 2008 11:40:15 GMT

there must be a field similar in two itabs..

without that based on what u r deleting..it makes no sense.

Re: Deleting from Internal table.....

Former Member — Tue, 19 Feb 2008 11:43:47 GMT

Ya, i got it,

all are same fields in both internal tbales, but its not key fields..

Re: Deleting from Internal table.....

kesavadas_thekkillath — Tue, 19 Feb 2008 11:48:03 GMT

data:wa1 like itab1.

data:wa2 like itab2.

Loop at it1 into wa1.

read table it2 into wa2 with key <field1> = <wa1-field1>

<field5> = <wa1-field5>.

if sy-subrc = 0.

delete it1 from wa1.

endif.

endloop.

Re: Deleting from Internal table.....

Former Member — Tue, 19 Feb 2008 11:49:55 GMT

hi,

lets have itab with 10 fields.

itab1 with 5 fields.

then

loop at itab.

delete itab1 where col2 = itab-col1.

endloop.

loop at itab1.

write : itab1-col2.

endloop.

try this.

Re: Deleting from Internal table.....

Former Member — Tue, 19 Feb 2008 11:59:04 GMT

hw u r saying that, what is col2 and what is col1, i dont think that will work.....

Akshitha.

Re: Deleting from Internal table.....

kesavadas_thekkillath — Tue, 19 Feb 2008 12:00:41 GMT

did u try my post

Re: Deleting from Internal table.....

Former Member — Tue, 19 Feb 2008 12:04:38 GMT

Im sure, that will work, but its not that much lengthy code, it should come for only one or two lines as they are expecting, thats why im thinking.....! any other alternate.

Akshitha.