topic Database modification in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/database-modification/m-p/4958019#M1155899 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I need to modify two fields (to increase the data length ) in a custom table.</P><P>There will be some data existing in the table. Will those data remain if I transport this modified table to Production?</P><P>If not , what I can do to retain those data in the table?</P><P></P><P>Please suggest if I need to take of anything else too while modifying the fields in this table.</P><P></P><P>Thanks in advance.</P><P></P><P>Regards,</P><P>Sanjeet</P></BODY></HTML> Wed, 10 Dec 2008 12:17:55 GMT Former Member 2008-12-10T12:17:55Z Database modification https://community.sap.com/t5/application-development-and-automation-discussions/database-modification/m-p/4958019#M1155899 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I need to modify two fields (to increase the data length ) in a custom table.</P><P>There will be some data existing in the table. Will those data remain if I transport this modified table to Production?</P><P>If not , what I can do to retain those data in the table?</P><P></P><P>Please suggest if I need to take of anything else too while modifying the fields in this table.</P><P></P><P>Thanks in advance.</P><P></P><P>Regards,</P><P>Sanjeet</P></BODY></HTML> Wed, 10 Dec 2008 12:17:55 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-modification/m-p/4958019#M1155899 Former Member 2008-12-10T12:17:55Z Re: Database modification https://community.sap.com/t5/application-development-and-automation-discussions/database-modification/m-p/4958020#M1155900 <HTML><HEAD></HEAD><BODY><P>Hi Sanjeeth,</P><P></P><P>If you are just increasing the length of the data type, it should not affect the data. Even after transporting i think it will not affect the data in anyways.</P><P></P><P>Best Regards,</P><P>Ram.</P></BODY></HTML> Wed, 10 Dec 2008 12:20:23 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-modification/m-p/4958020#M1155900 Former Member 2008-12-10T12:20:23Z Re: Database modification https://community.sap.com/t5/application-development-and-automation-discussions/database-modification/m-p/4958021#M1155901 <HTML><HEAD></HEAD><BODY><P>The table will be adjusted and the data will still be there. Think of it as a MOVE-CORRESPONDING between old and new data structure. So do not change the field names!</P><P>Thomas</P></BODY></HTML> Wed, 10 Dec 2008 12:24:32 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-modification/m-p/4958021#M1155901 ThomasZloch 2008-12-10T12:24:32Z Re: Database modification https://community.sap.com/t5/application-development-and-automation-discussions/database-modification/m-p/4958022#M1155902 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>After making the modification in your Z-table. Got to SE14 and Adjust and Activate the table with Save data radio button.</P><P></P><P>Then there will no be any issue after transport as well.</P></BODY></HTML> Wed, 10 Dec 2008 12:26:57 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-modification/m-p/4958022#M1155902 Former Member 2008-12-10T12:26:57Z Re: Database modification https://community.sap.com/t5/application-development-and-automation-discussions/database-modification/m-p/4958023#M1155903 <HTML><HEAD></HEAD><BODY><P>hi ,</P><P> </P><P> i dont think so that some thing is needed for this . when you change the data element then it will show you if any thing goes wrong at the time of activation . but it will effect the programs where it is used . I did it at my system . it is working fine for me . But i am not sure about this .</P></BODY></HTML> Wed, 10 Dec 2008 12:30:07 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-modification/m-p/4958023#M1155903 former_member203501 2008-12-10T12:30:07Z Re: Database modification https://community.sap.com/t5/application-development-and-automation-discussions/database-modification/m-p/4958024#M1155904 <HTML><HEAD></HEAD><BODY><P>Thanx to all of you for useful suggestion..</P><P></P><P>Regards,</P><P>Sanjeet</P></BODY></HTML> Wed, 10 Dec 2008 12:36:55 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-modification/m-p/4958024#M1155904 Former Member 2008-12-10T12:36:55Z Re: Database modification https://community.sap.com/t5/application-development-and-automation-discussions/database-modification/m-p/4958025#M1155905 <HTML><HEAD></HEAD><BODY><P>Go To se11.</P><P>Open the table.</P><P>Go to Utilities-&gt;database utilities</P><P></P><P>Mark the radio button Save Data and press the button Activate and adjust data.</P></BODY></HTML> Wed, 10 Dec 2008 12:59:54 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-modification/m-p/4958025#M1155905 Former Member 2008-12-10T12:59:54Z