Table-Structure Change

[Former Member]

Hi Guys!!!

I have created a Z***** table n activated,now i want to change the data type from FLTP to CHAR but the thing is am getting an error "Structure change at field level (convert table Z******).what i supposed to do?

Warm Regards,

Mohandoss P.

[Former Member]

You have to run enhancement tool..

[Former Member]

first delete the table maintainance generator and change the field data type

[Former Member]

utilities->Databaseopbject->database utility

[vinoth_kumar7]

hi... In that i cant chang any thing.. how to over come this problem (structure change at field level (convert table zemp)).

[arseni_gallardo]

Vinoth,

You must exectute transaction SE14, as instructed by Kalyan.

Regards

[Former Member]

Hi vinoth,

in menubar select

utilities->database object->database utility> select the activate and adjust database.

regards,

Haritha.

[vinoth_kumar7]

thnx Haritha... one more doubt.. Hw to delete a table permanently from DB?? and once i try delete it shows z#### is still used in abap dictionary due to use in Dictionary object the deletion cant be performed -Vinoth

Edited by: Vinoth Kumar.86 on Aug 31, 2011 4:00 PM

Edited by: Vinoth Kumar.86 on Aug 31, 2011 4:03 PM

[vinoth_kumar7]

Hi... can i delete a table permanently from DB? i tried but it showing ( emp no field is still being used as a view field in view Z___ )... in that what i do???

Edited by: Vinoth Kumar.86 on Aug 31, 2011 3:35 PM

Edited by: Vinoth Kumar.86 on Aug 31, 2011 3:38 PM

[Former Member]

Hi,

Along with that message i think u will get 'ok' and 'delete' button will come..

please click on delete button.

but make sure that the table field is not using any where after deleting the table. other wise dependent programs will give dump.

Regards

Aravind.

[Former Member]

Hi,

If you have created a data element for it. Make changes in the data element and activate. Then activate the table once. Your table will have the new data type.

Sharin.

[suryakong522]

Go to SE14 -> ENTER TABLE NAME AND EDIT ->then click on activate and adjust database

Try activating again