Changing Domains

1. Open the Repository Browser and navigate to the domain that you want to change.
2. Double-click on the required domain.

   The maintenance screen for the domain appears in display mode.

3. Choose  with the quick info text Display <-> Change.

   You are now able to make changes to the domain.

   Caution

   All the tables and structures in which a field or component refers to the particular domain are affected by changes made to the domain.

   A conversion of these tables may be necessary. For more information, see Adjusting Database Structures . This is time-consuming for tables containing a large number of records. Foreign keys also become inconsistent in such tables and structures. You must use the where-used list  before you change a domain.

To do the appropriate changes, choose one of the procedures below.

Changing the Data Type, Number of Places or Number of Decimal Places

You can change the data type and number of places or decimal places simply by overwriting the relevant data.

A change of this type can cause all tables that contain a field referring to the changed domain to be converted.

You must find out all the database tables in which a field refers to the domain before making such a change. To do this, perform the following:

1. In the context menu of the domain, choose the Where-Used List.

   A dialog box appears.

2. In the new dialog box, choose Indirect Application .

   A list appears.

3. Select Database Tables and choose  with the quick info text Execute.
4. The system displays all the database tables in which a field refers to the domain.

Changing the Output Attributes

Changing the output attributes of a domain has an effect on the dialog behavior in all the screens in which a field refers to this domain.

You must find out which screens are affected before making such a change. To do this, perform the following.

1. In the context menu of the domain, choose the Where-Used List.

   A dialog box appears

2. In the new dialog box, choose Indirect Application.

   A list appears.

3. Select Screens and choose  with the quick info text Execute.

   All the screens in which a field refers to the domain are listed.

Changing the Value Table

The value table is used as a proposal value for foreign key definitions. If you change the value table, use the Where-Used List to check if foreign keys that were already created also have to be changed. You can find out which foreign keys are affected by finding all the fields that refer to the domain and checking them against the changed value table.