DELETE ONE ENTRY

[Former Member]

hi.

i want to delete the entry from the it_final if it the field value doesnot fall in the range of select options s_req.

please help.

[former_member194669]

Try this way

loop at itab where not req in s_req.
  delete itab index sy-tabix.
endloop.

a®

[former_member156446]

try

delete it_final where value not in so_werks.

[former_member203501]

hi do like this ...

loop at it_final .

delete it_final where field1 ne r_range .

endloop.

[Former Member]

it is giving the error if i am doing like this

delete it_final where l_valpr_usd not in s_reqval.

please assist.

[former_member203501]

see this......

report ztest.

data: begin of itab occurs 0,

name type char10,

end of itab .

ranges: r_name for mara-matnr .

r_name-low = 'test01'.

r_name-sign = 'I'.

r_name-option = 'EQ'.

append r_name .

r_name-low = 'test02'.

r_name-sign = 'I'.

r_name-option = 'EQ'.

append r_name .

itab-name = 'test01'.

append itab .

itab-name = 'test02'.

append itab .

itab-name = 'test03'.

append itab .

itab-name = 'test04'.

append itab .

itab-name = 'test05'.

append itab .

delete itab where name in r_name .

loop at itab .

write:/ itab-name .

endloop.

[Former Member]

Sample code which is working

tables:mara.
select-options: s_matnr for mara-matnr.

types: begin of t_mara,
       matnr type matnr,
       end of t_mara.

data: it_mara type standard table of t_mara.


select matnr into table it_mara
from mara where matnr in s_matnr.

delete it_mara where matnr in s_matnr.

Make sure that column in where clause of delete is a part of the internal table

Regards,

Prashant

[Former Member]

Sample code which is working

tables:mara.
select-options: s_matnr for mara-matnr.

types: begin of t_mara,
       matnr type matnr,
       end of t_mara.

data: it_mara type standard table of t_mara.


select matnr into table it_mara
from mara where matnr in s_matnr.

delete it_mara where matnr in s_matnr.

Make sure that column in where clause of delete is a part of the internal table

Regards,

Prashant