Start of Content Area

Procedure documentation Using Filter Rows  Locate the document in its SAP Library structure

Use

To define a filter, first display the filter row in the list. In the filter row, you specify the filter criteria for each column.

Note

If you define filter criteria in multiple columns, only those data records that fulfill each of these criteria are displayed.

Syntax

To define a filter, use the following syntax in the filter row:

Syntax for Filters in the Filter Row

To display only those data records that...

Use…

Example

…contain the value [comparison value]

[empty] or

=

123 or

= 123

…contain a value that is greater than [comparison value]

>

> 123

…contain a value that is less than [comparison value]

<

< 123

…contain a value that is either greater than or equal to [comparison value]

>=

>= 123

…contain a value that is either less than or equal to [comparison value]

<=

<= 123

…contain any value, but not [comparison value]

! .

! 123

…contain any value between [lower limit] and [upper limit] (including these limit values)

. - .

100 – 123

...contain any value below [lower limit] or above [upper limit], but no value in between (and also not the limit values)

! . - .

! 100 – 123

...fulfill at least one of the filter criteria

. ; .

a – d; p - s

Note

If you want to use a character string as a filter and this character string contains one of the special characters listed above (such as C-1025), you need to place the entire character string in quotation marks ("C-1025", for example).

Using Replacement Characters

In comparison values, you can use a special replacement character for one or more characters; this replacement character is a wildcard character. This enables you to find multiple terms when using just one comparison value. You use the asterisk (*) as the wildcard character in the filter row.

Example

You want to identify all data records in the current column that end with ouse, such as House and Mouse.

To do this, you enter *ouse as the comparison value.

Escaping Wildcard Characters

To sort the list according to a comparison value that contains an asterisk (*), you need to indicate to the system that the character is not to be interpreted as a wildcard character: you need to escape the wildcard character. To do this, you precede the search character with a backslash (\) as the escape character.

Example

To identify all data records in the current column that contain *ouse, you use \*ouse as the comparison value.

Prerequisites

      The pushbutton This graphic is explained in the accompanying text with the quick info text Display Filter Row is displayed in the application toolbar.

      To be able to define a filter in this filter row, the cell of the column must have a white background. Otherwise filtering is not permitted for this column.

Procedure

...

       1.      To define a filter using the filter row, in the application toolbar for the list, choose This graphic is explained in the accompanying text with the quick info text Display Filter Row.

The filter row is displayed as the first row in the list.

       2.      Define the appropriate filter criteria in the relevant columns.

       3.      To apply the filter or filters to the list, press Enter or choose This graphic is explained in the accompanying text with the quick info text Filter at the beginning of the filter row.

The list is restricted to those data records that fulfill the filter criteria defined in the filter row.

       4.      To delete specific filters, delete the filter criteria for the column in the filter row.

       5.      To hide the filter row and thereby delete all filters in it, in the application toolbar for the list, choose This graphic is explained in the accompanying text with the quick info text Delete Filter and Close Filter Row.

 

End of Content Area