Activation after changes in structure with errors.

[Former Member]

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.

[GauthamV]

hi,

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

create inconsistency for the table and data.

[Former Member]

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

[GauthamV]

hi,

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

for that field will be having inconsistency on table.

[Former Member]

Hi,

Go to SE14 and try out activate and adjust database.

Thanks & Regards,

Prinan Pandit

[Former Member]

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