topic Re: Delete records from data base. in Application Development and Automation Discussions

Delete records from data base.

Former Member — Thu, 02 Nov 2006 22:06:08 GMT

Hello Friends,

I have to delete records from a table from QAS and I dont want to write a program for that.

Is there a way that the data from the tabe can be deleted without a program.

I want to delete records which are created at a specic time and I know the time and date. I have to delete like 1000 records.

Thanks,

Madhu.

Re: Delete records from data base.

Former Member — Thu, 02 Nov 2006 22:07:58 GMT

Hi,

If you have access to delete in se11..Go to SE11 select the records and then delete them..

THanks,

Naren

Re: Delete records from data base.

Former Member — Thu, 02 Nov 2006 22:09:47 GMT

This is a custom table right?

Rob

Re: Delete records from data base.

Former Member — Thu, 02 Nov 2006 22:15:04 GMT

Yes that is a custom table and Manually it is difficult for me to create those data because i am sure it more than some thousand,

Thanks ,

Madhu,

Re: Delete records from data base.

Former Member — Thu, 02 Nov 2006 22:46:13 GMT

IF it is a custom table and if you have access to SE11 you can go there and delete it...

or write a small report in which you can specify

Delete dbtab where (your condtion).

The second option is better.. it gives you better control

Re: Delete records from data base.

Former Member — Thu, 02 Nov 2006 23:34:02 GMT

U can use trx SE16 or SE30

Max

Re: Delete records from data base.

Former Member — Fri, 03 Nov 2006 11:53:16 GMT

Hi,

I think deleting more than 1000 records using se11/ se16 manually will take more time and it is risky also . Why dont u write one litle prog for that , which wont take much time .

Think about it !!

If helpful pl reward,

Cheers.

Re: Delete records from data base.

Former Member — Fri, 03 Nov 2006 12:02:10 GMT

U can use transaction SM30/SM31 where you can enter conditions to filter the records you wish to display. select the records and you would be able to delete the records at a single go !!

Please make sure that you are deleting records from custom table and not SAP Table. It is not advisable to delete records from SAP table using the above transaction.

Re: Delete records from data base.

Former Member — Fri, 03 Nov 2006 12:03:27 GMT

Hi Madhu,

You can delete records from table by selecting the record then

double click on record--->enter debug mode(/h) and enter

you will go to code..there you change to 'DELE' function code to code.

then execute..

after you will see delete button. from that button, we can delete the records.

Regards,

Ramanji