SAP Knowledge Base Article - Public

3689438 - Multiple Filter Values Apply OR Logic in SAP Fiori Applications

Symptom

  • Filtering PO line items using two separate conditions in the Material field returns results that match either condition instead of both

  • expects the filter to apply AND logic but system returns OR behavior

Environment

SAP S/4HANA Cloud Public Edition

Reproducing the Issue

  1. Open the Manage Purchase Orders app.

  2. In the filter bar, enter two separate conditions in the Material field.

  3. Execute.

  4. Observe that results include materials matching either of the entered values, not both.

Cause

The filters support multiple values but interprets them using OR logic. The system does not combine multiple values as an AND condition. This is standard design for the filter framework. 

Resolution

When an AND-style filter is required, users must combine the conditions into a single filter expression using wildcard characters (*) where applicable.

General approach:

<Condition1>*<Condition2>

This format:

  • Applies both criteria within one filter value

  • Allows the system to interpret the full string as a single pattern

Keywords

purchase order search, sap s/4hana cloud, multiple conditions, die and color code, material filter, wildcard search, OR condition, AND condition, purchase order report, sap purchasing analytics, open purchase orders, sap po search , KBA , MM-FIO-PUR-ANA-2CL , Fiori UI for Purchasing Analytics (Public Cloud) , Problem

Product

SAP S/4HANA Cloud Public Edition all versions