topic Re: DELETE ONE ENTRY in Application Development and Automation Discussions

DELETE ONE ENTRY

Former Member — Tue, 25 Nov 2008 15:48:44 GMT

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.

Re: DELETE ONE ENTRY

former_member194669 — Tue, 25 Nov 2008 15:51:27 GMT

Try this way


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

a®

Re: DELETE ONE ENTRY

former_member156446 — Tue, 25 Nov 2008 15:51:27 GMT

try

delete it_final where value not in so_werks.

Re: DELETE ONE ENTRY

former_member203501 — Tue, 25 Nov 2008 15:52:44 GMT

hi do like this ...

loop at it_final .

delete it_final where field1 ne r_range .

endloop.

Re: DELETE ONE ENTRY

Former Member — Tue, 25 Nov 2008 16:00:06 GMT

it is giving the error if i am doing like this

delete it_final where l_valpr_usd not in s_reqval.

please assist.

Re: DELETE ONE ENTRY

former_member203501 — Tue, 25 Nov 2008 16:10:08 GMT

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.

Re: DELETE ONE ENTRY

Former Member — Tue, 25 Nov 2008 16:17:37 GMT

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

Re: DELETE ONE ENTRY

Former Member — Tue, 25 Nov 2008 16:17:56 GMT

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