Add a field to a table

Note: You must use the Windows client whenever you need to add a new field/key to a database dictionary table.

1. From the System Navigator, click Tailoring > Database Dictionary.
2. Place the cursor in the File Name field, and then click Search.
3. Select any table from the record list.
4. Click the Fields tab.
5. Place the cursor in a type structure to add a field to the structure.
6. Click New Field/Key.
7. Specify information for all required fields.
   • Choose a data Type from the list. For an array, choose the appropriate data type if all elements are the same type. Otherwise, choose one of the following:
     • Text for an array of different data types
     • Structure for an array of structures
   • Type a field Caption.
   • Click Rename field if you decide to change the name of the field.
   • Specify Data policy settings as needed for Default value, Validation rule, and Data encrypted (encryption status).
   • Specify Match table and Match field values to define or enforce foreign key relationships. For example, you can specify that the contact.name field in one table must match a valid contact.name field from another table.
   • Provide Editing rules (display properties) for Mandatory display, Read-only, Availability, and Invisibility.
   • If necessary, specify one or more Alias fields with a different name but the same index, level, and type as a selected field.
8. Click Save.

Tip: You can edit any field or key directly from the System Navigator. Double-click the field or key to view the details with the Table Editor.

Related concepts

System Definition
System Definition utility
Table tab
Table definition
Table management
Fields and Keys tab

Related tasks

Access the System Definition utility
Edit a field in a table
Edit a record key