ERP Database - The Unofficial ERP Knowledge Base

Facebook Twitter del.icio.us Digg it
ERP Database contains a huge collection of articles related to ERP System and Software. Many of the articles are specifically related to SAP. All these ERP/SAP articles are freely available to everyone.

If you would like to submit an article or share any document related to ERP or any specific ERP software. Please mail it to support@erpdb.info. Please make sure that the documents are not copyrighted.
Social Bookmarks:

SAP Tips: Change Database tables directly

Print This Post Email This Post Written by admin on Jan 31st, 2008 | Filed under: ABAP

SAP being a very robust system has some flaws.. maybe they kept it intentionally so that we can play with it. Anyways, As far as i know there are two ways in which the table data can be changed directly incase if you do not have a SM30 view or there is no interface written to handle the database tables.

One easy way of handling it the use of ‘&SAP_EDIT ‘. Just go to SE16n and give the table name and in the command windows key in ‘&SAP_EDIT’(without quotes) and execute. You will have all the values editable. Ofcourse not the primary keys…! If you want to change the primary keys.. then just delete it and create a new entry in SE16n.

the other way is below.. need a very little debugging experience.

Here is a simple example which will allow you to modify any content of the table directly without the need of table maintenance.

Go to Transaction :SE16

Change 1

Give any material number.

Change 2

Imp: Before going further, first goto Menu –> Settings –> user Parameters –> Data browser –> and tick on SE16 Standard list.

press ‘/H’ in the command window and double click on the line of the record, which you would like to modify.

Change data 3

After the double click.. you should get a screen like below.. just press F7 once..

Change data 4

In Here, if you see the value of the CODE, the variable value is set to ‘SHOW’, change it to ‘EDIT’ and click on change.

Change Data 5

Now switch of the debugging and execute and viola! you got all the fields editable.. just change it to what ever you need and press ‘SAVE’.

Change data 6

See the new contents.

Change data 7

Copyright SAP DB : Visit us for More SAP Tips

Share

If you like this post, you may as well like these too:

  1. Source Code: Working with database tables and internal tables REPORT ZSOURCE0103. * Declaration of a work area for a Dictionary tableTABLES CUSTOMERS. * Internal table used as snapshot of the database tableDATA ALL_CUSTOMERS LIKE CUSTOMERS OCCURS 100 WITH HEADER...
    2.
  2. ABAP Programs: Using internal tables as snapshots of database tables REPORT ZSOURCE1103.* Work area for a database tableTABLES CUSTOMERS.* Internal tableDATA ALL_CUSTOMERS LIKE CUSTOMERS OCCURS 100 WITH HEADER LINE.* Filling the internal table with all entries of the database tableSELECT...
    3.
  3. ABAP Tips on Data Dictionary and Internal tables Data Dictionary Maintenance Views Lock Objects Internal Tables Free text search in a field in a internal table Types of Internal Tables Working with Internal Tables...
    4.
  4. Maintain Customizing directly in Production Often you require maintaining certain transactions which calls customizing table in the live production system. For example: Maintain exchange rates Opening and closing the period Maintain overhead rates Maintain assessment...
    5.
  5. ABAP Tips and Tricks #3: Programming Tips When one uses the MOVE statement, try keep the destination operands as the same data type as the ‘from’ operands. Use the FREE <table> command once the program has completed...
    6.
  6. SAP Database website Updates Now you can also take an active part in writing articles for Us. Please Login or Register. Quick steps to write articles. Step 1 : Login Step 2 : Click...
    7.
  7. SAP Tables Accounting BSAD Accounting: Secondary index for customers (cleared items) BSID Accounting: Secondary index for customers BSIW Index table for customer bills of exchange used BSIX Index table for customer bills...
    8.
  8. All the SAP System Tables http://www.jmen-web.de/sap/tables/systables.pdf...
    9.
  9. SAP tables MM Download here...
    10.
  10. Methods for modifying SAP Standard Tables You can modify SAP ‘Standard Tables’ using: Append Structures Customizing INCLUDES...
    11.
  11. SAP Tables Categorized by Business Process 1    Customising 1.1    General settings 1.1.1    Countries T005            Countries 1.1.2    Currency TCURC            Currency codes TCURR            Wisselkoersen TCURT            Currency name TCURX           ...
    12.
  12. SAP HR Tips and Tricks Here is a huge collection of Tips and Tricks on SAP HR. Understand more about Payroll, Organisation structure, HR Objects, Staffing and more in this Manual....
    13.
  13. SAP Tips Mag Some SAPTips Mag ebooks for download. June-July 2007 (Rapidshare) (Mediafire) Aug-Sep 2007 (Rapidshare) (Mediafire) Oct-Nov 2007 (Rapidshare) (Mediafire) Dec-Jan 2008 (Rapidshare) (Mediafire) Feb-March 2008 (Rapidshare) (Mediafire) April-May 2008 (Rapidshare) (Mediafire)...
    14.
  14. Logical Database FAQs Logical Database Frequently Asked Questions FAQs 1. Preparation of the data records by the L.D.B and reading of the data records in the actual report are accomplished with the command...
    15.
  15. Change Management in SAP NetWeaver Change Management in SAP NetWeaver’s Enterprise Portal (EP) and Knowledge Management (KM) has always been some what of a sore point with clients. Clients that implement EP and KM, most...
    16.


6 Comments Get FREE daily updates by RSS or e-mail

6 Responses to “SAP Tips: Change Database tables directly”

  1. eXtreme Abaper, on June 25th, 2008 at 9:36 pm Said:

    Hi,

    Its a good tip, But it requires debug with change authorization.

    If you have debug with change authorization, its not difficult to get the SE16n change authorization as well I think.

    Regards….

    eA..

  2. Cant Tell U my Name, on June 29th, 2008 at 7:40 pm Said:

    Man it really worked thanks

  3. Lino lopes, on February 13th, 2009 at 9:17 am Said:

    Hi there,

    Here´s another tip to change database tables. This one does not require debug neither change authorization.

    Go to transaction SE16n.

    Enter the name of the table you want to edit and hit the ENTER key.

    In the transaction/command edit box at the top of the screen enter the string: &SAP_EDIT and hit the ENTER key again.

    if you did it right, you´ll see the message “SAP edit funcions activated” at the bottom of the screen (in the status line).

    Now, enter the filters for the table fields in this selection screen as to restrict the table lines that will be shown. If you do not do this, all table lines will be shown.

    When you execute the transaction, the ALV with the table lines will be in edit mode with all the table fields open for edit.

    Make the changes you need to the table lines and press the save button to save your changes. You can make changes in more than one line before saving the changes.

    Hope that helps!

    Any doubts, my email is lino@hr.com.br.

    Cheers!
    Lino

  4. Keerthi, on March 25th, 2009 at 5:19 am Said:

    Hi

    Really good one.

    But I don’t have authorisation to execute transaction code &SAP_EDIT. Could you plz let me know what role (object) needs to be add to my account to get authorization for this t.code.

    Thanks in advance

    Regards
    Keerthi

  5. ram, on March 25th, 2009 at 10:29 am Said:

    Check SU53

  6. jingmeifan, on November 3rd, 2009 at 8:26 pm Said:

    Thank you very much. It's really help me a lots.

Leave a Reply