How To Fix WB2B411 - Selection restricted to &1 hits

WB2B411 - Overview

• Message type: E = Error

• Message class: WB2B - Trading Contract

• Message number: 411

• Message text: Selection restricted to &1 hits

What causes this issue?

In the report, the number of read accesses is restricted to &V1&.
Hits are displayed in a sorted sequence, but the list may not match the
data in the database due to the restriction to a maximum number of read
accesses.

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

System Response

How to fix this error?

Set the number of accesses permanently by a special report variant or
change it temporarily on the selection screens.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

WB2B411 - Details

• The SAP error message WB2B411: Selection restricted to &1 hits typically occurs in the context of the SAP Business Warehouse (BW) or SAP BusinessObjects when a query or selection is made that returns a large number of records, and the system restricts the output to a certain limit for performance reasons.
  
  Cause:
  
  Record Limit: The system has a predefined limit on the number of records that can be displayed or processed in a single query. This limit is often set to prevent performance issues when dealing with large datasets.
  Query Design: The query may not be optimized, leading to a large number of records being returned.
  User Settings: User-specific settings or system-wide settings may impose restrictions on the number of records that can be displayed.
  
  
  Solution:
  
  Refine the Query: Modify the selection criteria in your query to narrow down the results. This can include adding filters or parameters to reduce the number of records returned.
  Increase the