topic Delete lines from custom table in Application Development and Automation Discussions

Delete lines from custom table

Former Member — Mon, 23 Jul 2007 18:09:02 GMT

Hi,

How can I delete all lines from my custom table in Dev System.

Thanks,

Neelu.

Former Member — Mon, 23 Jul 2007 18:10:26 GMT

HI,

If you have many records.. write small program like this

data: itab like standard table of ztable.

select * from ztable into itab.

delete ztable from table itab.

Thanks

mahesh

Former Member — Mon, 23 Jul 2007 18:13:40 GMT

It will be good if u create table maintenance for creating new entries and deleting and modifying existing ones...

Regards

Prax

Former Member — Mon, 23 Jul 2007 18:17:55 GMT

hi,

do this way ..


select * from ztable into it_ztable.
if sy-subrc = 0.
  delete ztable from table it_ztable.
endif.

Former Member — Mon, 23 Jul 2007 18:19:27 GMT

Hi,

You can use transaction SE14 to delete all records of custom table.

Regards,

Ferry Lianto

Former Member — Mon, 23 Jul 2007 18:37:16 GMT

Thank you all.

Regards,

Neelu.

marcelo_ramos1 — Mon, 23 Jul 2007 18:46:02 GMT

Hi,

Goto SE14, on the second screen, mark 'DELETE DATA' option, click on "Activate and Adjust Database" and finish, your table is cleaned !!

Regards,

Marcelo Ramos.