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: 

Table Entries

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

paul_bakker2
Active Contributor
0 Kudos

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

11 REPLIES 11

former_member204264
Participant
0 Kudos

This message was moderated.

paul_bakker2
Active Contributor
0 Kudos

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

former_member200338
Active Contributor
0 Kudos

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

rajkumarnarasimman
Active Contributor
0 Kudos

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

former_member195402
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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.

former_member183424
Active Contributor
0 Kudos

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.

0 Kudos

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

shweta_sahay
Explorer
0 Kudos

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.

former_member220028
Active Contributor
0 Kudos

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

satyabrata_sahoo3
Contributor
0 Kudos

There must be a Maintenance dialog/Transaction/Program for data entry into this table as it already have data.

Do a Where-used search, you can find it.

If not then its better if you create its maintenance dialog and maintain data.