Skip to Content
0
Former Member
Apr 20, 2009 at 05:24 PM

Data elemnet change data type

24 Views

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