Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

DELETION Report- PARAMETER

Former Member
0 Kudos

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

3 REPLIES 3

Former Member
0 Kudos

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.

0 Kudos

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

Former Member
0 Kudos

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.