SAP Knowledge Base Article - Public

2615986 - Filtering of Document does not Yeild Expected Results

Symptom

Filtering of any Document that has symbol "-" in its ID is not giving you expected results.

 

Environment

SAP Business ByDesign

Reproducing the Issue

The below steps are just an example of one of the cases

  1. Go to Cost and Revenue work center
  2. Click on Projects view
  3. Search for project A-XYZ
  4. Select it and click on Project Plan values button
  5. Then click on filter button and enter project task A-XYZ:P
  6. And click on enter button


You expect only task A-XYZ:P to appear
however ,you will see many tasks that start with A

Cause

This is the desired behavior as per the development done currently. That is "-" is used as a delimiter.

It is expected that column filter with value containing "-" will be split based on "-".
So system will consider it as "A*" and gives you the results.

Also, any change to the existing behavior of system will break the existing use cases and hence developers are not going to make changes to this behavior.

Resolution

Please  replace "-" with "*"

In this example "A*XYZ:P" has to be used to get the exact filter result.

This is applicable for all document ID's where symbol "-" is apppearing.

Keywords

Filtering is not working, filtering is not proper,filtering is giving wrong results,filtering isgiving many unneccessary results , KBA , AP-PRO , Project Processing , How To

Product

SAP BUSINESS BYDESIGN 1611 ; SAP BUSINESS BYDESIGN 1705 ; SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1.0 ; SAP Business ByDesign 1302 ; SAP Business ByDesign 1305 ; SAP Business ByDesign 1308 ; SAP Business ByDesign 1311 ; SAP Business ByDesign 1402 ; SAP Business ByDesign 1405 ; SAP Business ByDesign 1408 ; SAP Business ByDesign 1411 ; SAP Business ByDesign 1502 ; SAP Business ByDesign 1505 ; SAP Business ByDesign 1508 ; SAP Business ByDesign 1511 ; SAP Business ByDesign 1602 ; SAP Business ByDesign 1605 ; SAP Business ByDesign 1608 ; SAP Business ByDesign 1702 ; SAP Business ByDesign 1711 ; SAP Business ByDesign 1802 ; SAP Business ByDesign 1805 ; SAP Business ByDesign feature pack 2.0 ; SAP Business ByDesign feature pack 2.5 ; SAP Business ByDesign feature pack 2.6 ; SAP Business ByDesign feature pack 3.0 ; SAP Business ByDesign feature pack 3.5 ; SAP Business ByDesign feature pack 4.0