Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to alter a not-empty custom table structure ?

former_member625844
Participant
0 Kudos

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.

4 REPLIES 4

You can use SE14 transaction to adjust and activate your table.

FredericGirod
Active Contributor

from Integer to Float, you should not have issu, better is to test in development system.

The problem is from Char to Number

Sandra_Rossi
Active Contributor
0 Kudos

Copy the table in dev to a dummy table, add one line, then try to do the change and adjust with SE14.

raymond_giuseppi
Active Contributor

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)