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

SAP Error Message - Details

• 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 criteria used in the selection process.
  Optimize Hierarchies: Review and optimize the hierarchical structures in use. Ensure that they are not overly complex and that they are necessary for the business process.
  Batch Processing: If possible, break down the selection process into smaller batches to avoid overwhelming the system.
  Performance Tuning: Work with your SAP Basis team to analyze and tune the performance of the queries being executed. This may involve indexing or adjusting database parameters.
  Review Custom Code: If there are custom developments or enhancements in place, review them for efficiency. Custom code can sometimes lead to performance bottlenecks.
  SAP Notes and Support: Check for any relevant SAP Notes that may address this specific error. SAP frequently releases updates and patches that can resolve known issues.
  
  Related Information:
  
  Transaction Codes: Depending on where the error occurs, you may be using transaction codes like ME21N (Create Purchase Order), VA01 (Create Sales Order), or others related to material or sales processing.
  SAP Community: Engaging with the SAP Community forums can provide insights from other users who may have encountered similar issues.
  Documentation: Review SAP documentation related to the specific module you are working with for best practices on handling hierarchies and selections.
  
  If the issue persists after trying the above solutions, it may be beneficial to engage SAP support for further assistance.