topic Re: Data elemnet change data type in Application Development and Automation Discussions

Data elemnet change data type

Former Member — Mon, 20 Apr 2009 17:24:50 GMT

Hi Gurus!

I have a table that has a date field in char 24 format and the table has like 700000 records in it. I would like to change the data type of the date field to DATS format . This si a custome field . When I go and change the data type of theat field to DATS and activate it , it does chage and get activated , but it gives an error in the table where it has been used saying


TABL Ztable is inconsistent in active version
Check table ZWELL_DLS (auser/04/20/09/11:21)
Field ZNEW_DATE: Length change
  ALTER TABLE is not possible
Structure change at field level (convert table ZTABLE)
Check on table ZTABLE resulted in errors

How do I change the data type so that the table is not affected and everything is ok. Or do I need to go and adjust the table again through SE14 ? So if I go and do it through SE14 then after transporting this field to QAT and subsequently PRD it will need to be adjusted again which seems a not very good way of doing it I suppose. Could anyone please help me out with this please.

Thanks

Re: Data elemnet change data type

Former Member — Mon, 20 Apr 2009 17:28:54 GMT

if you chnage the data type ..you lost all data..

with out losing data you can not do any thing..

Regards,

Prabhudas

Re: Data elemnet change data type

Former Member — Mon, 20 Apr 2009 17:32:18 GMT

So I will have to go through database utility itself , if I would like to save the data and change the data type ?

Re: Data elemnet change data type

Former Member — Mon, 20 Apr 2009 17:36:34 GMT

yes..

Re: Data elemnet change data type

Former Member — Tue, 21 Apr 2009 02:43:54 GMT

Hi Aarav,

first try this.

Goto SE14... & enter your table and then use the Activate & Adjust database button..

if your problem does not solve then,

You download all the data through the a BDC Download or directly from SE11... And do necesary modification on the data type.

After doing modification, write a upload program.

Thanks & regards,

Dileep .C

Re: Data elemnet change data type

Former Member — Tue, 21 Apr 2009 04:07:07 GMT

Please make a new table with desired fields and move the data from original table and later rename it.