topic Re: DATA TYPE CHANGE in Application Development and Automation Discussions

DATA TYPE CHANGE

former_member605939 — Fri, 08 Mar 2019 10:35:43 GMT

One of our object having Z table with more than 5000 records . One of the fields having data type NUMC with length 4 ( Like 0001 is 1 , 0020 is 20 ) . Now the requirement is to to 5 digit number and with alphabets ( Like 2002A).

New entries will be of length 5 and main concern is if we create field value 00001, it will take 00001 not 1 and but what about old entries how they will behave.

How can i do that the previous data is also accommodate with new data type.

Thanks,

Re: DATA TYPE CHANGE

ArthurParisius — Fri, 08 Mar 2019 11:06:13 GMT

Your correct that in the new situation 1 wil not automatically be changed to 00001, you will need to take care of that yourself. Concerning the existing values, if you want them to have an extra leading 0, I think you should do your data type change in 2 steps. First change it to NUMC length 5 and activate the table (probably with transaction SE14), and than change it the the CHAR 5 data type.

Re: DATA TYPE CHANGE

former_member605939 — Sat, 09 Mar 2019 03:20:45 GMT

I tried as u suggested but for old data it is taking as 4 places for new it is taking 5.

and for old data ( say it was 3 and now taking as 0003 to display the data) and for new data 00003.

Thanks

Re: DATA TYPE CHANGE

matt — Sat, 09 Mar 2019 07:50:54 GMT

Create a copy the Z table. Put some sample data into the copy. Change the data type. See what happens.

Re: DATA TYPE CHANGE

Sandra_Rossi — Sun, 10 Mar 2019 13:18:27 GMT

Please use the COMMENT button. ANSWER is only to propose a solution. If it's too late, you still have an option to convert your answer into a comment.