SAP Table Editing Function

This is a SAP Trick that is possibly too powerful, if authorizations are not in place in your system you dont want to use this too liberally:

To edit the contents of a table (Virtually any table from customizing to database records):

  1. Use transaction SE16n or in some systems transaction n.
  2. Enter the table name and see the records. (Sometimes you may be able to change a tables contents depending on its attributes.)

However if you wish to change most tables regardless of table attributes/control you can do the following:

  1. Use transaction SE16n or in some systems transaction n.
  2. Then enter &sap_edit in the command field.
  3. You will see a message “SAP editing function is activated”.
  4. Now enter the table name and execute to see the records. You will now be able to change the contents of the table.

This SAP technique may be useful to maintain faulty data in your system. But should only be used by a very experienced person.

3 Comments

  1. nathan August 17, 2011 at 2:32 pm · Reply

    this function has been removed by SAP as of SP6

  2. Fred Palmer October 7, 2011 at 6:16 am · Reply

    Pretty good allocation about SAP Table…… I think this SAP tricks do help me to change most tables!! Everyone would enjoy using SAP tricks for database records :)

    • admin October 7, 2011 at 12:40 pm · Reply

      Glad to help Fred, thank you for the feedback

Leave a Reply