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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Change in domain of the table

Former Member

‎07-16-2014 8:07 AM

0 Kudos

Hi All,

There is a custom table, where in I need to change the domain of one of the fileds.

One of the currency fields was having WERT7, I need to changed it to WERTV12, to prefix +/- signs.

The table is already in production system with data.

My question is if I change the domain, will it impact the consistency of data ? Should I need to adjust the table (se14)?

Please advise.

Thanks,

Priya

2 REPLIES 2

dani_mn
Active Contributor

‎07-16-2014 8:12 AM

0 Kudos

system will try to convert your data from WERT7 to WERTV12 if it executed successfully you don't have to do anything. If it stops in between it will in-activate the table or may drop the table. than you have to use SE14 to adjust. or in case of drop you have to transport it again. So be careful test in QA server in detail. And save you database table entries in excel before moving to PRD.

Former Member

‎07-16-2014 8:21 AM

0 Kudos

Hi,

Change domain to increase length with the same data type does not harm data. Data loss may occur during data conversion when you change the data type from Numeric to Char.

You can check the data conversion in development and Quality servers too. If that is successful in test servers, then you transport into PRD.

Regards,

Chandra