SAP Knowledge Base Article - Public

3634712 - Supply Planning - Products: Filter Function Does Not Work Correctly

Symptom

  • Facing an issue with the Inclusion and Exclusion filter in the work center view "Supply Planning - Products".
  • If filtering with Planning Group ID with Exclusion of a Planning Group ID, system is returning wrong result.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Navigate to the Supply Planning work center.
  2. Go to the Products view.
  3. Show All Products By Selection.
  4. Open Advanced Filter.
  5. Enter a specific value in the Search field.
  6. Click Go.
  7. The system returns 2 Results: One in the Planning Area XXX with Planning Group ID: XYZ, and the second in the Planning Area AAA with no Planning Group ID assigned.
  8. On the Planning Group ID field, click on the More Filters button.
  9. Check the 'But Exclude' flag and enter the relevant Planning Group ID to be excluded.
  10. Click on the OK button and then Go.
  11. The system is returning a lower Result than expected. 

XXX represents a Planning Area ID.
AAA represents a Planning Area ID.
XYZ represents the Planning Group ID.

Cause

System behaving as designed.

Resolution

  1. Check the behavior and note that the Exclude function behaves differently when compared with Include.
  2. To have the query work properly, it is recommended to set the Include as 'Is Initial'.

Keywords

supply planning, products, Advanced filter, planning group ID, exclude, include, query, is initial , KBA , AP-SDM , Supply and Demand Matching , Problem

Product

SAP Business ByDesign all versions