Application Development 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: 

DElete a entry through se16

Former Member
0 Kudos

hi ,

I need some info reagarding se16. We need to delete a entry using se16 and we dont have authorization or a specific role to do so. We tried the reverse way by first creating the cts in development box and then add the table key . But when we do so we are not able to identify whether we can create or delete through that cts. The table is INDX from which we have to delete the entry.

So can someone please tell how can you create or delete a entry through se16

1 ACCEPTED SOLUTION

Clemenss
Active Contributor

Hi Sumiti,

before deleting table entries you should make sure that there are no further relationships to other tables. If it is a SAP table it is strictly recommended to use only SAP transactions to reach that goal.

You can delete table entries using SM30 after creating a maintenance view for the table. This is the best way because you can record the table changes and you can put table changes into transports to transfer them to other SAP systems.

The next possibility (recommended for development and test systems only) is modify the entries in transaction SE16N (aka N): Start SE16N or N, enter table name, enter &sap_edit in command line on top of window, Enter. Then Execute (F8). You can change, delete, insert records.

The same - but less convenient - applies to SE16: Display and mark the records you want to change or delete, show detail view (F7). Enter /h to activate debugger, ENTER. You find yourself in debugger in form set_status_val. Change the value of variable code to 'DELE' for deletion, 'EDIT' for change or 'INSR', then F8 to continue. Now the respective function is active.

But please be careful. The changes are not logged but your name is logged in the system log - if you do this on productive system then ... see you next time in jail

Regards,

Clemens

10 REPLIES 10

Former Member

Hi,

There is a nasty trick to do this... Depending on the SAP release use transaction SE16N or SE16. Enter the name of the table and then in the command field &sap_edit. Then your maintenance functions will be available.

If this function is not available in the release you are working on, try this procedure.

1. goto SE11, enter the Table name

2. click on the techincal settings.

3. execute

4. click on the record u want to delete.

5. go to debug mode, press enter / F8.

6. change the value of code to 'DELE'.

7. press F8.

8. now you will be able to delete that entry.

Regards,

Raj.

0 Kudos
Enter the name of the table and then in the command field &sap_edit. Then your maintenance functions will be available.

what is that

then in the command field &sap_edit

i dint get that can u kindly explain this.

Regards

sas

0 Kudos

I used the solution provided by Former Member.

Effective.

Former Member
0 Kudos

Dear Sumiti,

You can mantain a table including adding and deleting entries using transaction SM30.

Reward if helpful,

Regards,

Esha Raj

Former Member
0 Kudos

Hi,

Try this step to delete the entries in table.

Go to se11, give the table name and get in change mode.

Goto to Utilities -> Table contents -> Display

excute the content on the table.

select the datas and select table entry in the menu bar

Delete the entry.

when comparing to se16 or se16n its easiest way.

Reward if its useful.

SantoshKallem
Active Contributor

hii,

goto SE16N and give the table name and press enter.

then run t-code &SAP_EDIT

and EXECUTE.

you will get all entries in change mode, there you can add , delete, change entries.

regards.

santhosh reddy

0 Kudos

thanks, it worked

Clemenss
Active Contributor

Hi Sumiti,

before deleting table entries you should make sure that there are no further relationships to other tables. If it is a SAP table it is strictly recommended to use only SAP transactions to reach that goal.

You can delete table entries using SM30 after creating a maintenance view for the table. This is the best way because you can record the table changes and you can put table changes into transports to transfer them to other SAP systems.

The next possibility (recommended for development and test systems only) is modify the entries in transaction SE16N (aka N): Start SE16N or N, enter table name, enter &sap_edit in command line on top of window, Enter. Then Execute (F8). You can change, delete, insert records.

The same - but less convenient - applies to SE16: Display and mark the records you want to change or delete, show detail view (F7). Enter /h to activate debugger, ENTER. You find yourself in debugger in form set_status_val. Change the value of variable code to 'DELE' for deletion, 'EDIT' for change or 'INSR', then F8 to continue. Now the respective function is active.

But please be careful. The changes are not logged but your name is logged in the system log - if you do this on productive system then ... see you next time in jail

Regards,

Clemens

0 Kudos

Thanks, I was able to delete the transaction from the table through SM30 only.

Former Member

Hey

If You want to delete all rows in table the best and quickly way to this is:

1. go to se11 - with table name - display mode

2. go to utilities - database objects - database utility

3. activate and adjust database - delete data

thats all

Andrew