Words and Phrases
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.
- From the System Navigator, click Tailoring > Database Dictionary.
- Place the cursor in the File Name field, and then click Search.
- Select any table from the record list.
- Click the Fields tab.
- Place the cursor in a type structure to add a field to the structure.
- Click New Field/Key.
- 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.
- 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:
- 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.