Changing Data Types and Lengths of Existing Fields 

Procedure

If a data element is assigned to a field, you must change the technical field attributes (data type, length, number of decimal places) in the domain of the data element.

Changing Table Fields with Data Elements

       1.      On the maintenance screen of the table, choose the Fields tab page.

       2.      Double-click on the name of the data element.

The data element maintenance screen appears.

       3.      Double-click on the name of the domain.

The domain maintenance screen appears.

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

       5.      Make the required changes and choose  with the quick info text Save.

Note that this change affects all the table fields that refer to the particular domain. Foreign keys could become inconsistent and conversions may be required. You must consider the effects of this action before changing the domain by choosing  with the quick info text Where-Used List on the maintenance screen of the domain and checking if the domain is used in other tables.

       6.      Choose  with the quick info text Activate.

The table is activated again and the table field is adjusted to the domain change.

Changing Table Fields with Direct Type Entry

...

       1.      On the maintenance screen of the table, choose the Fields tab page.

       2.      Position the cursor on the field and choose Predefined type.

You can now enter values in fields Data type, Length, Decimal Places and Short description.

       3.      Change the entries for the data type, length and possibly the number of decimal places.

       4.      Choose  with the quick info text Save.

       5.      Choose  with the quick info text Activate.

Table conversion is necessary if you change the field attributes. For more information, see Adjusting Database Structures.