topic Re: Changing a Value Range in a Domain in Application Development and Automation Discussions

Changing a Value Range in a Domain

Former Member — Fri, 04 May 2007 12:30:38 GMT

I want to remove the values in a value range on a domain that is currently in use in a database table. The table is in production with 1 million records. I want to change an existing domain on this feild to get rid of the range and transport it.

whats the impact on the existing data and table ?

Re: Changing a Value Range in a Domain

alison_lloyd — Fri, 04 May 2007 12:38:44 GMT

I take it this is a custom table?

As long as the new values are not more restrictive you should be OK but add some entries in development/test and check. If the new entries are more restrictive it will corrupt the table

Re: Changing a Value Range in a Domain

Former Member — Fri, 04 May 2007 12:48:35 GMT

It is a custom table and I am removing the value range in its entirety.

Re: Changing a Value Range in a Domain

Former Member — Fri, 04 May 2007 14:03:41 GMT

Hi J.J,

I have tried your scenario in sandbox. This works fine. As you change the domain just for removing the ranges value without any other modification, you won't even need to adjust the table.

But if you do any other modification to domain like data type or so, then you will be required to adjust the table in SE14 transaction. Now as large number of records are already in production, you can not introduce any other value range, which will mess you database.

Just removing the range values works fine and has no impact on existing data and even on table.

Hope this sort out your issue.

PS: If the answer solves your query, plz close the thread by rewarding points to each reply.

Regards

Re: Changing a Value Range in a Domain

Former Member — Fri, 04 May 2007 16:03:18 GMT

thanks, this answers my question. I just want to remove it. I am not adding any new values. thx

Re: Changing a Value Range in a Domain

hymavathi_oruganti — Mon, 07 May 2007 08:41:47 GMT

hi,

if u delete the current domain and want to add new, the value range of the new domain wonly will effect to all the records. there is no doubt in it. but while deleting u should be carefull. u go to tcode se14 and adjust database.