SAP Knowledge Base Article - Public

3766054 - Error: "User can mark only 100 standard fields as search fields" when configuring Case Field Query Properties

Symptom

  • A custom Case field cannot be marked as Searchable in Field Query Properties.
  • The following error message is displayed:
    • User can mark only 100 standard fields as search fields
  • The Case service shows a search-relevant field count greater than the allowed limit (for example, 110/100).
  • Some fields can be marked as searchable without errors, while others cannot.

Environment

SAP Service Cloud Version 2

Reproducing the Issue

  1. Navigate to System Settings.
  2. Open Extensibility Administration.
  3. Select Cases.
  4. Open Field Query Properties.
  5. Search for a custom field.
  6. Enable the Searchable option.
  7. Observe the error: "User can mark only 100 standard fields as search fields"

Cause

The limit is enforced at the service level, not only for fields displayed in the Case entity.

A field is considered search-relevant when it is marked as:

  • Searchable
  • Filterable
  • Sortable

The search-relevant count includes:

  • Standard fields
  • Custom fields
  • Fields from the Case entity
  • Fields from related child entities

When the total number of search-relevant fields exceeds the maximum supported limit of 100, additional fields cannot be made search-relevant.

A field that is already counted as search-relevant (for example, because it is already filterable or sortable) can sometimes be marked as searchable without increasing the total count. This explains why some fields can be configured successfully while others cannot.

Resolution

Review the search-relevant field usage for the Case service.

  1. Open Field Query Properties.
  2. Identify fields that are currently marked as:
    • Searchable
    • Filterable
    • Sortable
  3. Remove unnecessary query properties from fields that are not required for business searches.
  4. Reduce the total number of search-relevant fields to 100 or fewer.
  5. Mark the required custom field as Searchable.

The search-relevant field count includes fields from the main Case entity and all related child entities. Therefore, the displayed searchable field count for Cases alone may not explain the total search-relevant count reported by the system.

See Also

SAP Help Portal - Enhanced Search Field Limits

Keywords

field query properties, search-relevant limit, searchable fields, filterable, sortable, enhanced search, case, service level, 100 fields limit, error user can mark only 100 standard fields as search fields, custom field, cannot mark searchable, child entities , KBA , CEC-CRM-CAS , Case Management for SAP Sales/Service Cloud , CEC-CRM-CZM-EXT , Extensibility for SAP Sales/Service Cloud , Known Error

Product

SAP Service Cloud Version 2 all versions