topic Re: delete entries in Application Development and Automation Discussions

delete entries

Former Member — Thu, 31 May 2007 12:52:20 GMT

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

Re: delete entries

Former Member — Thu, 31 May 2007 12:54:48 GMT

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

Re: delete entries

Former Member — Thu, 31 May 2007 12:56:37 GMT

Hello,

Use the Transaction SM30.

Regards,

Deepu.K

Re: delete entries

Former Member — Thu, 31 May 2007 12:56:47 GMT

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.

Re: delete entries

Former Member — Thu, 31 May 2007 12:57:00 GMT

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.

Re: delete entries

Former Member — Thu, 31 May 2007 13:39:23 GMT

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 .

Re: delete entries

Former Member — Thu, 31 May 2007 13:51:06 GMT

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>

Re: delete entries

Former Member — Thu, 31 May 2007 16:44:59 GMT

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.