topic Re: Activation after changes in structure with errors. in Application Development and Automation Discussions

Activation after changes in structure with errors.

Former Member — Tue, 16 Dec 2008 06:27:37 GMT

hi all,

I have a Z- Structure which is included in a transparent Z- table.

I made some changes in the data element of one of the structure fields, (Changed from Char to NUMC ), now when i activate the structure it shows an error , saying " Alter table not possible on the table.....".

Any idea how to proceed from here, is there some other way to change and activate all the dependent tables.

All answers will be appreciated.

Re: Activation after changes in structure with errors.

GauthamV — Tue, 16 Dec 2008 06:31:41 GMT

hi,

It is difficult to change the data type once created because it will

create inconsistency for the table and data.

Re: Activation after changes in structure with errors.

Former Member — Tue, 16 Dec 2008 06:33:16 GMT

Hi,

You need to go to the tables which are using this structure and then use Data Base Utility ( T code Se14 ) to adjust and activate the database tables.

Also make sure that the programs which are using dependent tables are also changed accordingly and this activity is done some time when system is not being used much.

Hope this helps!!

Regards,

Lalit

Re: Activation after changes in structure with errors.

GauthamV — Tue, 16 Dec 2008 06:38:13 GMT

hi,

using SE14 may temporarily give you some result but the data existing

for that field will be having inconsistency on table.

Re: Activation after changes in structure with errors.

Former Member — Tue, 16 Dec 2008 06:45:38 GMT

Hi,

Go to SE14 and try out activate and adjust database.

Thanks & Regards,

Prinan Pandit

Re: Activation after changes in structure with errors.

Former Member — Tue, 16 Dec 2008 07:28:22 GMT

Hello,

The structure will not get activated till the table containig that structure is not activated i think,

Try to activate the table and its dependent tables first thru database utility se14 then structure will get activated.

Thanks