This is the tricks to delete a row in an SAP table. This tricks will be very useful for example to delete hanging transport with truck icon in STMS. Generally, when import is going on, STMS program save a temporary data in TMSTLOCKP or TMSTLOCKR table. For newer SAP version you can find process queue inTMSTLOCKNR and TMSTLOCKNP table. Here’s the procedure :

1. Run transaction SE16



2. Open table TMSTLOCKNR
3. Leave all fields as default. Then press Execute (F8).
4. Double click in the row you want to delete or display details
5. type /h in the command box to activate debug. Then press enter twice, you will see like this picture :



6. Double click text code, then change SHOW to DELE. Dont forget to click pencil icon to confirm change in the right side of this field



7. Run (F8)
8. Press Delete Button



9. Click Back twice
10. Row will be deleted

Note : Please be careful doing this trick since this will permanently delete a data record in table. Make sure that you have already familiar with this function. If you are not sure to do this, ask your ABAPer to do this for you.