SAP Knowledge Base Article - Public

3153606 - How to Filter Any field with Blank Value

Symptom

You want to filter the contracts with Installed Base as blank or any field which is blank.

Environment

SAP Service Cloud

Reproducing the Issue

  1. Go to the Contracts workcenter.
  2. Open Advance filter.
  3. For the Installed Base field, make the selection as Exclude; Equal to * and choose Go.

The results displays all the contracts.

Cause

The filter to be used is "is Initial" blank and it will display all the results without installed based

Resolution

  1. Go to the Contracts workcenter.
  2. Open Advance filter.
  3. For the Installed Base field, make the selection as Is Initial and don't enter anything in the textbox.

See Also

The solution works for all the fields accross all workcemters.

Keywords

#tickets #accounts #filter #blank , KBA , LOD-CRM-SRP , Service Request Processing , Problem

Product

SAP Cloud for Customer core applications all versions