Database modification

[Former Member]

Hi All,

I need to modify two fields (to increase the data length ) in a custom table.

There will be some data existing in the table. Will those data remain if I transport this modified table to Production?

If not , what I can do to retain those data in the table?

Please suggest if I need to take of anything else too while modifying the fields in this table.

Thanks in advance.

Regards,

Sanjeet

[Former Member]

Hi All,

I need to modify two fields (to increase the data length ) in a custom table.

There will be some data existing in the table. Will those data remain if I transport this modified table to Production?

If not , what I can do to retain those data in the table?

Please suggest if I need to take of anything else too while modifying the fields in this table.

Thanks in advance.

Regards,

Sanjeet

[Former Member]

Hi Sanjeeth,

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.

Best Regards,

Ram.

[ThomasZloch]

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!

Thomas

[Former Member]

HI,

After making the modification in your Z-table. Got to SE14 and Adjust and Activate the table with Save data radio button.

Then there will no be any issue after transport as well.

[former_member203501]

hi ,

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 .

[Former Member]

Thanx to all of you for useful suggestion..

Regards,

Sanjeet

[Former Member]

Go To se11.

Open the table.

Go to Utilities->database utilities

Mark the radio button Save Data and press the button Activate and adjust data.