Table Delete using T-Code. se16n

[Former Member]

Dear All,

I need to delete some duplicated record from Table TEVEN (Infotype2011) because some employees Intime and out time has been duplicated.

For this purpose, i have been used &SAP_EDIT to delete the records in table but after the security patch updated... now i unable to use this T-Code (&SAP_EDIT).. Pls anyone let me know , what can i do for this? and also are there any other option to delete the particular records in table TEVEN (Infotype 2011)

Thanks and Regards,

Dinesh.

[Former Member]

Hi DInesh,

You can ask basis consultant to change the client settings, then &SAP_EDIT will work. IF Basis consultant does not change the client setting the please follow the way. In that you will be able to delete one record at one time.

1) Goto transaction SE16

2) Give the Table Name.

3) Then give the duplicate field value.

4) Execute it.

5) Double click it. It will appear in one screen.

6) Then on the transaction panel write /H

7) Press enter. One message will be displayed Debugging Swith On.

😎 Again Press Enter

9) Then click on code and the value of code will be SHOW.

10) Change the SHOW to DELE.

11) Then Delete Entry button will appear.

12) Click on the Delete Entry button.

13) Entry will be deleted.

14) For that you should have debuging access in SAP.

Thanks & Regards,

Sandip Biswas

[Former Member]

Dear Sandip,

thanks for your response.. I have tried according what you said but deleting records one bye one is not possible because i have nearly 6.500 records which has been duplicated.so I approach ABAP's to write a user interface to delete the record according to the input parameter..

Thanks lot for your responce.

Regards,

Dinesh.

[Former Member]

Hi Dinesh,

As this is one time activity I would suggest not to create any ABAP Program for that. You can ask the basis consultant to open client for a few minutes and then you perfrom SE16N and &SAP_EDIT. After your activity is done then they will again close the client. Transaction for opening client is SCC4.

Thanks & Regards,

Sandip Biswas