Delete records from data base.

[Former Member]

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.

[Former Member]

Hi,

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

THanks,

Naren

[Former Member]

This is a custom table right?

Rob

[Former Member]

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,

[Former Member]

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

[Former Member]

Hi

U can use trx SE16 or SE30

Max

[Former Member]

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.

[Former Member]

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.

[Former Member]

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