Procedure documentation Defining Constraints Locate the document in its SAP Library structure

Use

A constraint for the values of a column is composed of one or more conditions that you formulate line-by-line and can link together.

Caution

You can only formulate constraints for columns with valid column definitions.

Procedure

  1. If required, enter the name for the constraint.
  2. Select the column that you want to formulate the condition for.
  3. Select a predicate for the condition. To negate the condition, use the Not-Operator !. Negation is not possible with relational operators.
  4. Enter the relational expression for the condition, and confirm it with Enter.
    When you enter the relational expression, you can choose between the following options:

    5. Option

    Meaning

    Single Value

    The expression consists of a single value

    All

    The condition must be fulfilled with all expressions in the list (Expression List)

    Any

    The condition must be fulfilled with one expression in the list (Expression List)

    Default

    The expression consists of the default value of the column
  5. Enter how the formulated condition is to be linked with the next condition.

    6. Caution

    If you retrospectively reset the relation type back to none, all subsequently formulated conditions are deleted immediately.

  6. To insert a new constraint, choose New Constraint.
  7. To insert new constraints and at the same time copy the definition of existing constraints in the same table, select the required constraints, and choose Copy Constraint.
  8. To insert new constraints and copy the definition of existing constraints from existing tables, choose Import Constraint. A window opens, containing all constraints defined by the current user. Select one or more constraints and choose OK.
  9. In order to delete a constraint, select the constraint and choose Remove Constraint.