You must define the base tables and fields of the view before you can restrict the set of data records that can be selected with the view by defining a selection condition (see Join, Projection and Selection ).
The maintenance screen of the view appears.
You can enter a condition in each line, with the following form:
Table, Field name, Operator, Comparison value, AND/OR
Proceed as follows:
You can find the valid operators with the F4 help.
Text literals (which must be enclosed in apostrophes) and numbers are permitted as comparison values, depending on the data type of the field.
You can enter the fields for which you want to define selection conditions directly or copy them with Table fields.
OR operations are possible only between lines referring to the same field.
OR takes priority over AND. The condition <COND1> AND <COND2> OR <COND3> is interpreted as <COND1> AND (<COND2> OR <COND3>).
You can formulate selection conditions for all the fields of the table contained in the view. It is not important whether or not these fields were included in the view.
If you attach a table to your text table using a maintenance view you do not need a selection condition in the form text field = SY-LANGU since the system derives this restriction directly from the text foreign key .