Develop > Tailoring > Data management > Data validation > Look-up processing > Add field level definitions

Add field-level definitions

  1. Click Tailoring > Database Manager.
  2. Type validity in the Form field, and then click Search.

    A list of the validity form records in your database opens.

  3. Double-click validity.summary, and then click Search.

    The Validity Table Specifications summary form opens.

  4. In the Field Name field, type the name of the field in which you want to create a validation record.
  5. In the Files/Formats field, type the name of the file or files in which this field is found.
  6. Click Search to search for records that may already exist with this field.
  7. If no record exists, click New to add your new record.

    The following message appears in the status bar: Data Validation record added.

  8. Complete the remaining fields in the form (including the other tabs) with the exception of the Values Summary and Range Summary arrays.
  9. Click More or the More Actions icon, and select Validate to validate the information you have entered in the form.

    If you have entered an invalid value in the form, a message appears in the status bar specifying the error.

  10. Click Save when you have successfully validated your record.

    A message appears in the status bar, stating that the Data Validation record has been updated.

Related concepts

Accessing the validity file
Data validation
Format Control processes

Related tasks

Display value summary details
Display range summary details
Create validity table definitions
Add value definitions
Add range definitions
Validate the validity definitions
Delete an entire validity record
Delete a single value or range definition
Delete value or range definitions from a table
Print a detailed report of an entire validity record
Validate fields during record processing
Create a validity lookup option in Format Control
Call validate.fields from Format Control

Related references

Validity validation rules