Delete large no of records from db

[Former Member]

Hi All,

When am trying to delete a large no of data from db table it is giving dump if i use Delete db from inttable statment.How can i avoid this?

Thanks,

Rakesh.

Edited by: Rakesh More on Jul 29, 2008 1:25 PM

[Former Member]

Hi

What is the Error Message?

[matt]

Delete fewer records at one go.

[Former Member]

instead of write logic like delete db from itab. use loop to delete record by record

[Former Member]

DELETE RECORDS IN A PARTICULAR INTERVAL REGULARLY

[Former Member]

Use

DELETE dbtab FROM wa.

Regards

rajesh

[Former Member]

I have to delete more than 20 lakhs records.I dont think the internal table can hold so much of data!!

[Former Member]

Delete as ...

do.

select * from <table> into

table it_table up to 20000 rows.

if sy-subrc = 0.

DELETE <table> FROM TABLE it_table.

refresh : it_table.

else.

exit.

endif.

enddo.

[Former Member]

First I have to display total no of records to the user and after the user clicks delete button the records have to be deleted.So i cant use SELECT UPTO n rows.

[Former Member]

Hi,

sorry i thought u want to delete records from db directly....

If u want to delete records of db table from internal table, try as follows,

loop at itab into w_itab.

delete DB from w_itab.

Endloop.

Regards,

Kusuma.

Edited by: kusuma kurapati on Jul 29, 2008 1:32 PM

[Former Member]

Hi,

For deleting table entries, Use the transaction SE16N,

Do give the table name and then enter the value range for deleeting...

On the transaction view entry(left corner top where you enter any transaction code)...enter(&SAP_EDIT) and then press execute button

On next screen, you get all the entries based on the value range..

Now you can select all and delete at one go...

Reward if useful

Regards

Shiva

• Note: Be carefull!!! while deleting..

[Former Member]

Hi,

Thier may be some limit .. while deleting the records.......