simple qa: delete from itab with another itab

[Former Member]

i s.option: f_name an i eneter data(example: 1000).

i get data in itab

1000

10001

10002

........................

i want to delete all teh number that thay no 1000

i made

delete from itab where field ca f_name

[Former Member]

i s.option: f_name an i eneter data(example: 1000).

i get data in itab

1000

10001

10002

........................

i want to delete all teh number that thay no 1000

i made

delete from itab where field ca f_name

[Former Member]

delete from itab where field cp '1000'.*

try this..........

\[removed by moderator\]

regards

anbu

Edited by: Jan Stallkamp on Jun 10, 2008 1:38 PM

[Former Member]

write as :

delete itab where field in f_name.

[peter_ruiz2]

hi,

there are several options. you can use a loop statement or a range

here is a sample using range

range: r_field.

move 'I' to r_field-sign.
move 'EQ' to r_field-option.
move '1000' to r_field-field.
append r_field to r_field.

move '10001' to r_field-field.
append r_field to r_field.

move '10002' to r_field-field.
append r_field to r_field.

delete itab where field in r_field.

here is a sample using a loop.

data:
  begin of itab1 occurs 0,
     field(5) type char,
end of itab1.

append '1000' to itab1.
append '10001' to itab1.
append '10002' to itab1.

loop at itab1.
delete itab where field eq itab1-field.
endloop.

regards,

Peter

[Former Member]

hi,

do this way ..

delete itab where field in f_name.