Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Delete lines from custom table

Former Member
0 Likes
3,145

Hi,

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

Thanks,

Neelu.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,338

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

6 REPLIES 6
Read only

Former Member
0 Likes
1,339

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

Read only

Former Member
0 Likes
1,338

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

Regards

Prax

Read only

Former Member
0 Likes
1,338

hi,

do this way ..


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

Read only

Former Member
0 Likes
1,338

Hi,

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

Regards,

Ferry Lianto

Read only

0 Likes
1,338

Thank you all.

Regards,

Neelu.

Read only

marcelo_ramos1
SAP Mentor
SAP Mentor
0 Likes
1,338

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.