topic Re: Program to delete entries in table in Application Development and Automation Discussions

Program to delete entries in table

Former Member — Fri, 30 May 2008 16:41:52 GMT

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

Re: Program to delete entries in table

Former Member — Fri, 30 May 2008 16:44:39 GMT

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'.

Re: Program to delete entries in table

Former Member — Fri, 30 May 2008 16:46:35 GMT

Hi Venkat,

Would be suggest some standard program.

Regards,

Surjit P

Re: Program to delete entries in table

Former Member — Fri, 30 May 2008 16:47:14 GMT

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

Re: Program to delete entries in table

Former Member — Fri, 30 May 2008 16:58:22 GMT

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