07-13-2021 2:34 AM
We have a custom table Z001 which is not empty in production environment, Now I want to change a non-key column type from integer to float. So how to do that? What I think is 1. create another table Z002 2. transport all data in Z001 to Z002 3. empty Z001 4 alter z001.5.move data back from z002.
Is there a better solution? and if not, do I need to write a program to transport the table data or is there a Tcode for that ?Thx.
07-13-2021 4:54 AM
07-13-2021 6:31 AM
from Integer to Float, you should not have issu, better is to test in development system.
The problem is from Char to Number
07-13-2021 7:23 AM
Copy the table in dev to a dummy table, add one line, then try to do the change and adjust with SE14.
07-13-2021 8:51 AM
Using SE14 you will execute an ALTER TABLE sql statement. Check this in development or sandbox, as integer is more restrictive than float you should have no problem.
NB: As suggested by sandra.rossi you could try it on a local copy of the table, create a non transportable table, a small report to copy a bunch of records and check the SE14 Activate and Adjust database Log)