3687612 - How advanced filters works in Purchase Request screen

Advanced filters return different results based on Include and Exclude selections.

SAP Business ByDesign

• When one option is selected in Include and one in Exclude, the system uses AND logic.

• When two options are selected in Include, the system uses OR logic.

• When two options are selected in Include and one in Exclude, the system uses OR logic.

• When one option is selected in Include and multiple in Exclude, the system uses AND logic.

This is the designed system behavior. To avoid confusion in advanced filters, use below scenario:

In include select equal to Consistent, system returns only the purchase request which are consistent.

Use straight forward values include to filter the respective fields and values.

Refer to: Using Column Filters in Worklists | SAP Help Portal

advanced filters, purchase requests, inconsistent filters, sap business bydesign, exclude condition, include condition, filter functionality, purchase orders, filter issue, sap cloud tenant, advanced search, filter criteria , KBA , SRD-SRM-PRO , Purchase Requests and Orders , How To