topic Re: DELETION Report- PARAMETER in Application Development and Automation Discussions

DELETION Report- PARAMETER

Former Member — Fri, 21 Sep 2007 10:12:39 GMT

hi experts,,

I am working on a DELETION Report which delete the certain Table entries.i want to insert the PARAMETER so that if I enter the values(ex:1000) only that much of entries to be deleted.

can u please give me some hints regarding the logic..

plz help me

mahesh

Re: DELETION Report- PARAMETER

Former Member — Fri, 21 Sep 2007 10:15:17 GMT

Your do

parameters: p_rows(4) type n.

SELECT * up to (p_rows) rows

into table t_data

from <table>

then <table> from table t_data.

Re: DELETION Report- PARAMETER

Former Member — Fri, 21 Sep 2007 10:18:19 GMT

hi,

Parameter: count type p value 0.

loop at itab into wa.

if count <1000.

delete tablename where fld1 = wa-fld1.

count = count +1.

endif.

endloop.

or you can also wirte:

do 1000 times.

delete table where fld1 = wa-fld1.

enddo.

Re: DELETION Report- PARAMETER

Former Member — Fri, 21 Sep 2007 10:25:27 GMT

thank you for replye .

do you mean after 1st select ( SELECT * up to (p_rows) rows

into table t_data

from <table>)

we need to use anothe select to put into data t_data

plz replye