12-11-2009 5:34 AM
Hi,
I have added custom fields through .Include structure CI_EKKODB in table EKKO. Now i want to increase the data length from 3 to 4 for data type DEC. If i increase the data length whether data will be lost in EKKO table or not. What are the precautions i have to take to avoid data lost?
Thanks in advance.
12-11-2009 5:42 AM
Hi
Convert the table using the Database Utility (SE14).
Give object name as you table and click edit.
To save data stored in table, click on 'activate & adjust database' with 'Save data'
Tanaya
Edited by: Tanaya A on Dec 11, 2009 11:14 AM
12-11-2009 5:42 AM
Hi
Convert the table using the Database Utility (SE14).
Give object name as you table and click edit.
To save data stored in table, click on 'activate & adjust database' with 'Save data'
Tanaya
Edited by: Tanaya A on Dec 11, 2009 11:14 AM
12-11-2009 6:26 AM
Hi,
When you will change the data length, system will automatically ask you to activate/adjust the table.
Goto T-code SE14.
Type your table name (EKKO), then click on the SAVE DATA radio button at the bottom, & then click the last button of Activate/Adjust Table. Your changes would be done & data will not be lost.
Hope that solves your problem.
Rgds
Prateek
12-11-2009 1:57 PM
Hi,
Thanks for your replies.
When i was changing the data type earlier ( DEC 3 ) from decimal places 0 to 1, data has lost in EKKO table even though adjusted the database from SE14. I have created primary and secondary indexes also.