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

Program to delete entries in table

Former Member
0 Likes
4,370

Hi,

The table maintenance is not enabled for a table.

I wish to delete some entries in that table.

Would be please suggest some problem or workaround.

Points will be awarded.

Thanks,

Surjit P

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,549

GO to the Table, check the entries to be deleted by clicking on the checkbox on the left side. Execute display option.

Enter '/h' in command bar for switching debugging on and check value for field 'code' in the fieldnames. It will be 'SHOW', change that to 'DELE' instead and save it. Execute it by pressing 'F8' and you will be on screen asking for option to delete that required entry.

Cheers,

Vikram

4 REPLIES 4
Read only

Former Member
0 Likes
1,549

hi use like this..

PARAMETERS p_carrid TYPE sflight-carrid.

DELETE FROM sflight

WHERE carrid = p_carrid AND

fldate = sy-datum AND

seatsocc = 0.

or use delete mara where matnr = '100-100'.

Read only

0 Likes
1,549

Hi Venkat,

Would be suggest some standard program.

Regards,

Surjit P

Read only

Former Member
0 Likes
1,549

Hello,

An workaround!

Go to transaction SE16 enter the table name and fill in the selection screen the conditions to select the records to be deleted.

Now in the list select the records to be deleted enter /h in the command and press ENTER two times.

In the debug, enter the field CODE and set the value of it to DEL5 .

The records will be deleted!

Regards

Read only

Former Member
0 Likes
1,550

GO to the Table, check the entries to be deleted by clicking on the checkbox on the left side. Execute display option.

Enter '/h' in command bar for switching debugging on and check value for field 'code' in the fieldnames. It will be 'SHOW', change that to 'DELE' instead and save it. Execute it by pressing 'F8' and you will be on screen asking for option to delete that required entry.

Cheers,

Vikram