Skip to Content
author's profile photo Former Member
Former Member

DElete a entry through se16

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Best Answer
    Posted on Apr 17, 2008 at 06:34 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 17, 2008 at 06:12 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 17, 2008 at 05:01 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2015 at 07:25 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 17, 2008 at 05:02 AM

    Dear Sumiti,

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

    Reward if helpful,

    Regards,

    Esha Raj

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 17, 2008 at 06:06 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.