topic Re: Table Entries in Application Development and Automation Discussions

Table Entries

Former Member — Sun, 27 Jul 2014 14:15:11 GMT

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

Re: Table Entries

Former Member — Sun, 27 Jul 2014 16:50:05 GMT

This message was moderated.

Re: Table Entries

paul_bakker2 — Mon, 28 Jul 2014 00:08:05 GMT

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

Re: Table Entries

Former Member — Mon, 28 Jul 2014 03:23:41 GMT

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

Re: Table Entries

rajkumarnarasimman — Mon, 28 Jul 2014 03:57:23 GMT

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

Re: Table Entries

Former Member — Mon, 28 Jul 2014 04:23:24 GMT

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

Re: Table Entries

Former Member — Mon, 28 Jul 2014 04:49:07 GMT

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.

Re: Table Entries

former_member183424 — Mon, 28 Jul 2014 05:04:19 GMT

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.

Re: Table Entries

jyotirmaya_mallick — Mon, 28 Jul 2014 11:15:21 GMT

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

Re: Table Entries

shweta_sahay — Mon, 28 Jul 2014 11:25:29 GMT

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.

Re: Table Entries

Former Member — Mon, 28 Jul 2014 12:26:34 GMT

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

Re: Table Entries

satyabrata_sahoo3 — Mon, 28 Jul 2014 15:11:15 GMT

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.