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