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,143

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,336

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,337

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,336

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,336

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,336

Hi,

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

Regards,

Ferry Lianto

Read only

0 Likes
1,336

Thank you all.

Regards,

Neelu.

Read only

marcelo_ramos1
SAP Mentor
SAP Mentor
0 Likes
1,336

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.