SAP Knowledge Base Article - Public

2243834 - How to Search for the Contacts Which are not Assigned to any Account

Symptom

How to search for the contacts which are not assigned to any account.

Reproducing the Issue

  1. Go to the Accounts work center.
  2. Go to the Contacts view.
  3. Select the Advanced Filter.
  4. Select the More Options of the Account field.
  5. In Options select | Contains pattern and in Value select *.
  6. Select the Ok button and then choose Go button.
  7. The result show all the contacts where account is assigned.
  8. Now again select the Advanced Filter.
  9. In Options select | Contains pattern and keep Value field blank, select the But Exclude, in next Options select | Contains pattern and in Value select *.
  10. Select the Ok button and then choose Go button.
  11. No results appear.

Cause

The query selected in the Advanced Option is not correct.

Resolution

For the search for contacts without accounts please choose the option Is initial with value = ''.
With above query the result list will show all the contacts where account is not assigned.

It works in described way because Is initial option means where the account field is Initial or Blank.
Hence Initial with == means that the contacts where Account field = Blank / Initial.

  1. Go to the Accounts work center.
  2. Go to the Contacts view.
  3. Select the Advanced Filter.
  4. Select the More Options of the Account field.
  5. In Options select Is initial with value = ''.
  6. Select the Ok button and then choose Go button.
  7. The list shows all contacts where account is not assigned.

Keywords

KBA , LOD-CRM , Cloud for Customer , How To

Product

SAP Cloud for Customer 1505 ; SAP Cloud for Customer 1508 ; SAP Cloud for Customer 1511 ; SAP Hybris Cloud for Customer 1708 ; SAP LE APPL. PLATFORM 1508 ; SAP LE APPL. PLATFORM 1511 ; SAP LE APPL.PLATFORM 1708