topic Re: database table in Application Development and Automation Discussions

database table

Former Member — Tue, 25 Mar 2008 19:07:08 GMT

hii all,

i had got a db table with 50 entries and now i have to delete the first 10 entries using reports, an u lpz help me in that...

Re: database table

Former Member — Tue, 25 Mar 2008 19:09:40 GMT

hi use this command ..

delete dbname(table name) where matnr = '100-100'(if condition exists).

check this example....

PARAMETERS p_carrid TYPE sflight-carrid.

DELETE FROM sflight

WHERE carrid = p_carrid AND

fldate = sy-datum AND

seatsocc = 0.

regards,

venkat.

Edited by: venkat appikonda on Mar 25, 2008 8:10 PM

Re: database table

Former Member — Tue, 25 Mar 2008 20:07:42 GMT

As far as I know, you can't use index option in delete statement of database table. So, deleteing first 10 rows using delete statement can not be done by specifying position.

However, work around can be, first select from that table using up to 10 rows

select * up to 10 rows from dbtab into table itab .

and then delete from that database table using internal table that holds those 10 rows.

using

DELETE dbtab FROM TABLE itab.

G@urav.