SAP Knowledge Base Article - Public

2598034 - Extension Field Search Filter for Customers Does Not Work as Expected in Account Advanced Filter

Symptom

You filter for an extension field but the search returns wrong results.

Environment

SAP Cloud for Customer

Reproducing the Issue

You would like to use an extension field to filter customers in Advanced Search Filter:

  1. Go to the Customers work center.
  2. Go to the Accounts view.
  3. Open Advanced Search Filters.
  4. Check the extension field.
  5. Click on Go.

Ticked Ext_Filed.png

    6.  Note the result.
    7.  Uncheck the extension field.
    8. Click on Go.

Unticked Ext_field.png

    9.  Note the result.

The result is the same with and without the filter.

Cause

This might be caused by the wrong business context selected during the extension field creation. For example, in this scenario the business context for the Field is 'Primary Contact Extensibility'.


Business_Context.png

The business context is set for the advanced search parameter.The search is performed in the related contact of the account and not in the account; this explains why 'Not specified' and 'False' leads to the same result considering that contacts don't have that block set.

Resolution

Remove the extension field and add it with the business context 'Account - General Information'.

E_Business Context.png

After having added the right business context the search will return the correct results.

Keywords

Account, Extension Field, Account Search, SalesSupportBlock, Account Query,Filter , KBA , LOD-CRM-ACC , Account , How To

Product

SAP Cloud for Customer add-ins 1802

Attachments

1.png
2.png
3.png
4.png