topic Re: Increase the data length in Application Development and Automation Discussions

Increase the data length

Former Member — Fri, 11 Dec 2009 05:34:08 GMT

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.

Re: Increase the data length

Former Member — Fri, 11 Dec 2009 05:42:49 GMT

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

Re: Increase the data length

Former Member — Fri, 11 Dec 2009 06:26:35 GMT

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

Re: Increase the data length

Former Member — Fri, 11 Dec 2009 13:57:01 GMT

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.