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

Table Entries

I have a custom table which has already entries added to it. The entries is also been transported across the systems by using transports.

Now i need to add couple of entries into the table - but the table does not have TMG or SM30. I am not sure how to add the entries.

Could any one let me know how can i add some entries to the table in development system.

Thanks

Senthil

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

11 Answers

  • Posted on Jul 28, 2014 at 12:08 AM

    Hi,

    In SE11, have you tried to create new entries via the menu item Utilities > Table Contents > Create Entries?

    If this is not available, maybe you should consider creating a Table Maintenance Dialog. If you need to add / change entries now, someone else will almost certainly have the same requirement in the future!

    Other options are to use SE16N, or write a small abap program to add the entries in DEV.

    In SAP, there are always lots of ways to skin a cat :-)

    good luck

    Paul

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 28, 2014 at 04:23 AM

    Hi Senthil,

    in SE11 check the where-used-list of your table, if there is a custom program which is for table maintenance.

    Regards,

    Klaus

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 27, 2014 at 04:50 PM

    This message was moderated.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 28, 2014 at 03:23 AM

    Did you look for maintainence view? goto sm30, give the table name and press find maintenance dialog button.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 28, 2014 at 03:57 AM

    Hi Senthil,

    Please check whether the Table Maintenance attribute is set for the customized table. If the attribute is set, we can make entries via SE16N itself. Kindly find the link below for detailed screenshots.

    Regards

    Rajkumar Narasimman

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 28, 2014 at 04:49 AM

    Hi Senthil,

    Like Paul mentioned,

    Have you tried following options?

    1. TC SE11, via the menu item Utilities > Table Contents > Create Entries?

    2. SM30 - Table Maintenance, if Maintenance view is available

    if not you can create one.

    3. You can also try SE16N, only if you are authorized.

    4. Else easy way is to write a small ABAP program which will add entry in your z-table. However, you must remember that Open SQL statements do not check authorization or the consistency of data in, the database. The following statements are purely technical means of programming database updates. They are to be used with care, and only to be used in exceptional cases.

    INSERT

    Single Record

    Multiple Record

    INSERT <db> FROM <wa>

    INSERT <db> FROM TABLE <itab> [ACCEPTING DUPLICATE KEYS].

    *1st record
    WA_T001-BUKRS = 'E001'.
    WA_T001-BUTXT = 'This is text1'.

    APPEND WA_T001 TO IT_T001.
    CLEAR WA_T001.

    *2nd record
    WA_T001-BUKRS = 'E002'.
    WA_T001-BUTXT = 'This is text2'.

    APPEND WA_T001 TO IT_T001.
    CLEAR WA_T001.

    "Insert Multiple records from ITAB
    INSERT T001 FROM TABLE IT_T001.

    Also check Modify Query. But I guess Insert query might solve your purpose.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 28, 2014 at 05:04 AM

    What the way do you want to update your table ?

    As you have said it is a custom table, so you can update the table directly from t-code N and @sap_edit.

    But still I'll not advice the same, because we know direct table update (on that way) can create lots of inconsistent (Also it is depend on your table uses).

    The safe way to update the table via a FM.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 28, 2014 at 11:15 AM

    Hi Senthil,

    you can use FM SE16N_INTERFACE to add rows or other modification.

    Pass the parameter

    I_EDIT = 'X'

    I_SAPEDIT = 'X'

    thanks,

    Jyoti

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 28, 2014 at 11:25 AM

    If you are unable to insert entries through SE11 create entries then it is better to create a table maintenance (if it doesn't exist) for this custom table as if later on you or anyone else want to add entries then it will be easy using table maintenance.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 28, 2014 at 12:26 PM

    Hi,

    when you cant find a programm, that fills the table. Why dont you use the table-maintain-generator so the table can be maintained in sm30. The goal is not to find the latest trick to insert rows right? When using SAP you normaly want to use the standard as often as possible.

    regards

    Stefan Seeburger

    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.