Maintaining Selection Conditions of Views
Once you have defined the base tables and fields of the view, 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).Procedure
Table, Field name, Operator, Comparison value, AND/OR
Table: Name of the base table from which the field was taken.
Field name: Name of the field for which the selection condition was formulated.
Operator: Operator for comparing the field contents and comparison value. You can find the valid operators with the F4 help.
Comparison value: Constant value with which the field value is compared. Text literals, which must be enclosed in apostrophes, and numbers are permitted as comparison values, depending on the data type of the field.
AND/OR: Link between two lines of the selection condition.
You can enter the fields for which you want to define selection conditions directly or copy them with Table fields.
OR operations are only possible between lines referring to the same field. Note that OR takes priority over AND. The condition <COND1> AND <COND2> OR <COND3> is therefore 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