How To Fix MSITEM124 - Large number of custom selections due to hierarchy

MSITEM124 - Overview

• Message type: E = Error

• Message class: MSITEM - Line Item Display with ALV, RFITEM**

• Message number: 124

• Message text: Large number of custom selections due to hierarchy

What causes this issue?

You have specified hierarchies in the custom selections. Expanding the
hierarchies into single values or intervals of data produces many
selections. This can lead to problems in the data selection because the
SQL Select on the data base can only process a limited amount of custom
selections.

System Response

A warning message is issued because the selection may generate a dump.

How to fix this error?

Check your entries. You can reduce the number of selections for
hierarchies by entering data intervals in the custom selections for the
corresponding field to which the hierarchy refers. In this way, the
hierarchy is no longer used for the selection by the read program.
Instead, it is only used for preparing the data during output.

Procedure for System Administrators

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message MSITEM124 - Large number of custom selections due to hierarchy ?

  The SAP error message MSITEM124 typically indicates that there is a large number of custom selections being made due to a hierarchy in a material or item selection process. This can occur in various SAP modules, particularly in Material Management (MM) or Sales and Distribution (SD), where hierarchical data structures are used.
  
  Cause:
  
  Large Hierarchical Structures: The error often arises when the system is trying to process a large number of items or selections that are part of a complex hierarchy. This can lead to performance issues or exceed system limits.
  Inefficient Queries: If the queries or selections are not optimized, they can result in excessive data retrieval, causing the system to throw this error.
  
  Configuration Issues: There may be configuration settings in the hierarchy that are not optimized for the volume of data being processed.
  
  
  Solution:
  
  Limit Selections: Try to limit the number of selections being made. This can be done by narrowing down the