SAP Knowledge Base Article - Public

2780715 - "Is Not" and "Contains Not" Conditions Not Working in Material Supply and Demand List Data Source

Symptom

When using conditions like "Is Not" or "Contains Not" in data source Material Supply and Demand List, the report is bringing no results, when actually there are values to be retrieved.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Business Analytics work center.
  2. Go to Design Data Sources work center view.
  3. Search for Material Supply and Demand List data source.
  4. Click on Preview button to open the data source in preview mode.
  5. In the Selection pane, locate the field you want to filter by.
  6. Click on the ">" symbol on the left hand side of the field. It will enable a drill down box with the filtering conditions.
  7. Select the condition "!= is not" or "!~ contains not".
  8. Click on the value help icon, on the right hand side of the field.
  9. In the value help window, select the entry you want to be excluded from report results.
  10. Click on OK.
  11. In report Selection pane, click on Apply to update the report results.
  12. No results are displayed at all.

Cause

The data source Material Supply and Demand List does not support using such conditions as "!= is not" or "!~ contains not".

Resolution

If using these conditions is mandatory for your specific business need, you can export the data source / report into an Excel file and apply filters from Excel to exclude the desired entries from the report table.

  •  Note that it is highly recommended to apply filters on "Supply Planning Area ID" field in report Selection, otherwise you may experience timeout issues.

See Also

2780638 - Cannot Filter Dates in Material Supply and Demand List Data Source

Keywords

Conditions in Material Supply and Demand List; Conditions not working; Cannot use conditions; , KBA , AP-SDM , Supply and Demand Matching , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions