In the Criteria window click on link to define a where condition.

tj-where-0

Click Field to select a table field.

tj-where-1

Select a field from the list that contains the names of the tcrables and the fileds seperated by the tilde character ‘~’

tj-where-2

Select an operator from the list:
EQ: equal
NE: not equal
LT: less than
LE: less or equal than
GT: greater than
GE: greater or equal than
LIKE: find a string fitting the value.
WHERE MAKT~SPRAS LIKE ‘D%’ find all languages that start with the letter ‘D’.
NOT LIKE: Negation of LIKE.
IS NULL: Is NULL
IS NOT NULL: Ist not NULL.

tj-where-operation

Set a value for the criterion. Variables in the form of @myValue are supported too.

tj-where-value

Now the criterion is defined.

tj-where-3

New criteria

Click on the right side on the button to create a new criterion.

tj-where-single-criteria

You have the following logical operators to combine conditions:
AND: Both conditions must be true.
OR: One or both conditions must be true.

tj-where-and

You can even add a criteria group. Click on the symbol on the right side.

tj-where-criteria-group

tj-where-criteria-group-2

Manual input / Open SQL

To write a condition manually, click on the symbol on the right side and confirm the warning that criteria definitions will be lost.

tj-where-4

Now you use the free open SQL mode (SAP syntax) to write manually your SQL statement.

tj-where-5