delete entries

[Former Member]

can any one tell me how to delete entries from a database table from 30 to 80 entries i need to delete.

[former_member186143]

go to SM30 fill in the table name , select the rows, delete them and save

ofcourse you are talking about Ztables right ?

and if SM30 is not working you first have to maintain that in the table with SE11

Message was edited by:

A. de Smidt

Message was edited by:

A. de Smidt

[Former Member]

Hello,

Use the Transaction SM30.

Regards,

Deepu.K

[Former Member]

go to transaction se16n

entry your DBtable.

then type &sap_edit.

now you are able to delete the rows that you want.

reward with points if its helpful.

[Former Member]

You can write a code in SE38. just declare the table and user delete from statement.

If the delete is not locked by user authorization you can delete the rows you want to delete.

[Former Member]

Hi..

You can follow this also :

DELETE FROM 'database' WHERE field1 = 'x' AND

field2 = 'y' AND

field3 = 'z' .

In this way records satisfying ur Condition will be deleted .

Praveen .

[Former Member]

hi

If you just want to delete 30 to 80 the rows from a program

use

<b>DELETE from <ZTABLE> where <CONDITION>.

modify ZTABLE</b>

regards

ravish

<b>plz dont forget to reward points if helpful</b>

[Former Member]

this code will definitely work.....

first move the data from database to an internal table upto 80 rows.

select * from <dbtab> upto 80 rows into table itab1.

insert lines of itab1 from 30 into itab2.

delete <dbtab> from table itab2.

enddo.