‎2008 May 30 5:41 PM
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
‎2008 May 30 5:58 PM
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
‎2008 May 30 5:44 PM
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'.
‎2008 May 30 5:46 PM
Hi Venkat,
Would be suggest some standard program.
Regards,
Surjit P
‎2008 May 30 5:47 PM
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
‎2008 May 30 5:58 PM
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