Filtering Data in SAP Business OnePDF download from SAP Help Portal:http://help.sap.com/saphelp_sbo91/helpdata/en/45/10ff61cf465d7be10000000a11466f/content.htm

Created on April 07, 2016

The documentation may have changed since you downloaded the PDF. You can always find the latest information on SAP HelpPortal.

Note

This PDF document contains the selected topic and its subtopics (max. 150) in the selected structure. Subtopics from other structures are not included.

© 2016 SAP SE or an SAP affiliate company. All rights reserved. No part of this publication may be reproduced or transmitted in any form or for any purposewithout the express permission of SAP SE. The information contained herein may be changed without prior notice. Some software products marketed by SAPSE and its distributors contain proprietary software components of other software vendors. National product specifications may vary. These materials areprovided by SAP SE and its affiliated companies ("SAP Group") for informational purposes only, without representation or warranty of any kind, and SAPGroup shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group products and services are those that are setforth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additionalwarranty. SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE inGermany and other countries. Please see www.sap.com/corporate-en/legal/copyright/index.epx#trademark for additional trademark information and notices.

Table of content

PUBLIC© 2014 SAP SE or an SAP affiliate company. All rights reserved.

Page 1 of 4

Table of content1 Filtering Data in SAP Business One1.1 Filter Table Window

PUBLIC© 2014 SAP SE or an SAP affiliate company. All rights reserved.

Page 2 of 4

1 Filtering Data in SAP Business One

Filters refine your search in SAP Business One. For example, when a report yields too many hits, you can narrow the search to a specific customer code ordue date range.

Use the procedure below to filter data in SAP Business One.

Procedure1. In SAP Business One, select a document or report containing data you want to filter.2. In the toolbar, choose ( Filter Table... ).

The Filter Table window appears.3. Define the filter as required, selecting the appropriate rules and values.4. To confirm the filter definitions, choose Filter .

The selected window appears with the required filtered data. The filtered fields appear with the ( Filter ) icon.5. To close the Filter Table window, choose OK .

Removing Filters

To see an unfiltered view of the document or report, choose ( Filter Table... ) in the toolbar.

NoteBy default, SAP Business One saves the last filter selections for each document or report. To delete existing filter selections, you must choose Clearand then OK in the Filter Table window.

More InformationFilter Table Window

1.1 Filter Table Window

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... ).

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

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.

NoteThe 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 theValue and To Value fields.

Out of Range Displays all rows with records that are outside the range of values between theValue 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 theValue 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 theValue field.

Is Empty Displays all rows that do not contain any records.

Is Not Empty Displays all rows that contain records.

PUBLIC© 2014 SAP SE or an SAP affiliate company. All rights reserved.

Page 3 of 4

Value

From the dropdown list, select a value to match the rule.Alternatively, you can enter a value in the field. To do this, select the blank option from the dropdown list.

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 .

More InformationFiltering Data in SAP Business One

PUBLIC© 2014 SAP SE or an SAP affiliate company. All rights reserved.

Page 4 of 4