Show TOC

Using the Add Filter ButtonLocate this document in the navigation structure

Context

Procedure

  1. In the top-right of the Data Preview tool, identify the Add Filter button.
  2. Choose Add Filter to list the columns.

  3. Choose a column from the list.

    A section to set the filter criteria appears.

    The table below describes some filter criteria that you can use:

    Operator Description
    Equal The Equal operator selects all records with value equal to the value specified in the text field. This operator works with column data types such as:
    • String
    • Numeric
    • Timestamp
    Not Equal The Not Equal operator selects all records with value not equal to the value specified in the text field. This operator works with column data types such as:
    • String
    • Numeric
    • Timestamp
    Lower The Lower operator selects all records with value lower than the value specified in the text field. For columns with String data type, Data Preview selects values with lexical order lower than the value specified in the text field. This operator works with column data types such as:
    • String
    • Numeric
    • Timestamp
    Lower or equal The Lower or equal operator selects all records with value lower than or equal to the value specified in the text field. For columns with String data type, Data Preview selects values with lexical order lower than or equal to the value specified in the text field. This operator works with column data types such as:
    • String
    • Numeric
    • Timestamp
    Greater The Greater operator selects all records with value greater than the value specified in the text field. For columns with String data type, Data Preview selects values with lexical order greater than the value specified in the text field. This operator works with column data types such as:
    • String
    • Numeric
    • Timestamp
    Greater or equal The Greater or equal operator selects all records with value greater than or equal to the value specified in the text field. For columns with String data type, Data Preview selects values with lexical order greater than or equal to the value specified in the text field. This operator works with column data types such as:
    • String
    • Numeric
    • Timestamp
    Like The Like operator selects all records with value that matches the regular expression value specified in the text field. This operator works with columns of String data type.
    Not Like The Not Like operator selects all records with value that does not match the regular expression value specified in the text field. This operator works with columns of String data type.
    In List The In List operator selects all records with value that is equal to any of the values specified in the text field. This operator works with columns of String and Numeric data types.
    Not In List The Not In List operator selects all records with value that is not equal to any of the values specified in the text field. This operator works with columns of String and Numeric data types.
    Is Null The Is Null operator selects all records with the value “is null”. This operator works with column data types such as:
    • String
    • Numeric
    • Timestamp
    Is Not Null The Is Not Null operator selects all records with the value “is not null”. This operator works with column data types such as:
    • String
    • Numeric
    • Timestamp

    For information about data types, see Mapping of the ABAP Data Types

  4. Set filter criteria using the available options.

    The filtered value appears in the column.

Related Information