topic Re: SE 14 - Table Adjust in Application Development and Automation Discussions

SE 14 - Table Adjust

former_member188001 — Fri, 02 Jan 2009 16:03:40 GMT

Hello all,

Can anyone tell me what is the main reason behind using SE14. Also let me know, if we delete entries from database table, do we need to adjust the table ? If yes then what will that do.

Regards,

Salil

Re: SE 14 - Table Adjust

Former Member — Fri, 02 Jan 2009 16:06:32 GMT

Did you see [Online manual|http://help.sap.com/erp2005_ehp_02/helpdata/EN/a4/3790360ee65840e10000009b38f839/frameset.htm] for SE14?

Re: SE 14 - Table Adjust

Former Member — Fri, 02 Jan 2009 19:08:37 GMT

Hi,

The table has to be adjusted only when the fields are altered.

<removed_by_moderator>

Regards

Vasavi kotha

Edited by: Julius Bussche on Jan 2, 2009 8:32 PM

Re: SE 14 - Table Adjust

Former Member — Fri, 02 Jan 2009 19:17:04 GMT

Don't beg for points.

Thank you.

Re: SE 14 - Table Adjust

santosh_kumarm — Sat, 03 Jan 2009 17:55:32 GMT

Hi Salil Vidya,

Whenever you have data in a table and alter the primary key fields in the table. we need to adjust the table at the Database level. because when you try to activate the table after altering the key fields in a table. an error message or inactive state is maintained. so when you run the SE14 for the table after modifying the key fields. the table is adjusted at the database level and the table is activated.

Hope information shall be useful.

Regards

Santosh Kumaar.M

Re: SE 14 - Table Adjust

Former Member — Mon, 05 Jan 2009 06:10:04 GMT

Hi ,

The database utility is the interface between the ABAP Dictionary and the relational database underlying the R/3 System. The database utility allows you to edit (create, delete and adjust to changes to their definition in the ABAP Dictionary) database objects derived from objects of the ABAP Dictionary.

You can call the database utility from the initial screen of the ABAP Dictionary with Utilities ® Database utility (Transaction SE14). The initial screen for the database utility appears.

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.

You go directly to this screen from the maintenance screen of the object in the ABAP Dictionary with Utilities --- Database utility.

Regards,

Radhika.

Re: SE 14 - Table Adjust

Chandra-Bade — Mon, 05 Jan 2009 21:43:42 GMT

If you delete any table entries you don't require to adjust the data base. when ever changes to the data base with respect to fields are made utilities are adjusted.

If any table is altered and activated and that table is used in the view then the changes are not correct in the view unless the table is adjusted using SE14.

Hope this Helps you.

Regards

Chandrasekhar Bade