Show TOC

Object documentationFilter Table Window Locate this document in the navigation structure

 

The Filter Table window lets you set rules to retrieve specific results for data in a document or report.

To open this window, open the document or report and choose Filter Table ... (Filter Table ...).

Note Note

This topic documents fields and other elements in this window that either are not self-explanatory or require additional information.

End of the note.
Filter Fields
Field

Displays the fields of the selected report or document, for example, G/L Accounts and Business Partners.

Rule

Select the rule according to which you want to filter the records.

Note Note

The following table explains the various available filter rules.

Filter Rules

Filter Value

Description

Equal

Displays all rows with records that equal the value in the Value field.

Not Equal

Displays all rows with records that do not equal the value in the Value field.

In Range

Displays all rows with records that are within the range of values between the Value and To Value fields.

Out of Range

Displays all rows with records that are outside the range of values between the Value and To Value fields.

Greater than

Displays all rows with records that are larger than the value in the Value field.

Greater or Equal

Displays all rows with records that are larger than or the same as the value in the Value field.

Smaller than

Displays all rows with records that are smaller than the value in the Value field.

Smaller or Equal

Displays all rows with records that are smaller than or the same as the one in the Value field.

Is Empty

Displays all rows that do not contain any records.

Is Not Empty

Displays all rows that contain records.

End of the note.
Value

Select a value to match the rule.

To Value

If the rule that you have selected is either In Range, or Out of Range, select a value. For all other rules the field is disabled.

Filter

Confirms filter definitions.

After confirming, choose OK to close the window.

Cancel

Cancels the selections you just made and closes the window.

Clear

Deletes all filter definitions that you have made. For this deletion to take effect, you must choose OK.