topic Re: Inserting new fields in a Dictionary Table? in Application Development and Automation Discussions

Inserting new fields in a Dictionary Table?

Former Member — Wed, 14 Feb 2007 19:39:42 GMT

I want to insert 3 new columns in my customized(z-table) which has got some records.

Can I directly insert the fields in the table by gooing in SE11.

If not is there any way I can be safe and achieve that functionality?

Regards

Nicky

Re: Inserting new fields in a Dictionary Table?

Former Member — Wed, 14 Feb 2007 19:42:23 GMT

Yes u can.

It's better to add new fields as last fields else you have to run the database utilities to adjust the databse defintion of your z-table.

Max

Re: Inserting new fields in a Dictionary Table?

Former Member — Wed, 14 Feb 2007 19:47:45 GMT

Hi,

Yes, you can insert new fields in the custom table using SE11.

Once it is done, you can use database utility (SE14) to adjust the table and regenerate the table maintenance.

Regards,

Ferry Lianto

Re: Inserting new fields in a Dictionary Table?

Former Member — Wed, 14 Feb 2007 19:48:55 GMT

Thanks

How ti use the database utitlity?

Re: Inserting new fields in a Dictionary Table?

Former Member — Wed, 14 Feb 2007 19:50:36 GMT

Hi,

Please check this link for more information on database utilty.

In your case, you may want to adjust database structure with the new additional fields.

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f0e3446011d189700000e8322d00/content.htm

Regards,

Ferry Lianto

Re: Inserting new fields in a Dictionary Table?

Former Member — Wed, 14 Feb 2007 22:46:51 GMT

Hi,

Not a problem at all.

Just insert the new fields and save. Then go to utilies -> database utility (SE14).

Select activate and adjust database.

The table will be adjusted accordingly without affecting the data in it.

Regards

Subramanian

Re: Inserting new fields in a Dictionary Table?

Former Member — Thu, 15 Feb 2007 03:56:53 GMT

Once you insert the fields, if the db table is having the records then it will show error message. to activate the table then goto se14 and activate directly with saving the data

the SE14 does

Edit, create, delete or adjust your database table

The database utility is the interface between the ABAP Dictionary and the relational database underlying the R/3 System.

This tools allows you to delete all the data in the tables.

You can call the database utility from the initial screen of the ABAP Dictionary with

Utilities -> Database utility (Transaction SE14).

You can use the database utility to edit all the database objects that are generated from objects of the ABAP Dictionary.

These are database tables that are generated from transparent tables or physical table pools or table clusters, indexes, database views and matchcode pooled tables or matchcode views.

If you want to use the database utility, you need authorization for authorization object

S_DDIC_OBJ, e. g. S_DDIC_ALL.

Regards

Shiva