topic Re: Table-Structure Change in Application Development and Automation Discussions

Table-Structure Change

Former Member — Wed, 06 Aug 2008 08:35:09 GMT

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.

Re: Table-Structure Change

Former Member — Wed, 06 Aug 2008 08:36:59 GMT

You have to run enhancement tool..

Re: Table-Structure Change

Former Member — Wed, 06 Aug 2008 08:37:44 GMT

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

Re: Table-Structure Change

Former Member — Wed, 06 Aug 2008 08:39:20 GMT

utilities->Databaseopbject->database utility

Re: Table-Structure Change

Former Member — Wed, 06 Aug 2008 08:41:45 GMT

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.

Re: Table-Structure Change

vinoth_kumar7 — Tue, 30 Aug 2011 07:40:14 GMT

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

Re: Table-Structure Change

arseni_gallardo — Tue, 30 Aug 2011 10:02:26 GMT

Vinoth,

You must exectute transaction SE14, as instructed by Kalyan.

Regards

Re: Table-Structure Change

Former Member — Tue, 30 Aug 2011 10:22:42 GMT

Hi vinoth,

in menubar select

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

regards,

Haritha.

Re: Table-Structure Change

vinoth_kumar7 — Wed, 31 Aug 2011 09:53:43 GMT

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

Re: Table-Structure Change

vinoth_kumar7 — Wed, 31 Aug 2011 10:03:50 GMT

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

Re: Table-Structure Change

Former Member — Wed, 31 Aug 2011 11:08:03 GMT

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.

Re: Table-Structure Change

suryakong522 — Mon, 20 Mar 2023 04:34:56 GMT

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

Try activating again