SAP Knowledge Base Article - Public

3042526 - Search By Country In Account Advanced Search Return Different Countries Than Selected

Symptom

You want to find the accounts of a specific country, then in the Advanced Search of the Accounts view you select a country XYZ (where XYZ is any country) in the Country/Region standard field and perform the query.

However when you check the results you see some different countries than the one you selected in the Country/Region field.

Environment

SAP Cloud For Customer

Reproducing the Issue

  1. Go to Customer Work Center.
  2. Open Accounts view.
  3. Click on Advanced Search button.
  4. Select country XYZ(where XYZ is any country) in the Country/Region field.
  5. Click Go to perform the query.
  6. Check in the results that the Country/Region column is showing some results different than the one you selected.

Cause

Accounts may have multiple addresses maintained which may also have different countries.

Resolution

You need to check the Addresses maintained in the Account that shouldn't be appearing:

  1. Open the Account that shouldn't be appearing in the results.
  2. Go to the Addresses tab. 
  3. The Account have multiple addresses.
  4. Click on each one and check maintained Country/Region value.
  5. One of them will have the country you selected in the search.

If you don't wish this to show up in the search, then the account must have a single country only. If it has multiple addresses with countries, the search will find it and add to the results, as this would be the expected behavior.

Keywords

Account; Country; Advanced Search; Filter; Results; Addresses; C4C; , KBA , LOD-CRM-ACC , Account , How To

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions