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

  • Show details Hide details
  • 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

    Already have an account? Login here!




Instant HelpGet instant SAP help. Sign up for our Free Essentials Plan.


Related SAP Error Messages

Click the links below to see the following related messages:

Click on this link to search all SAP messages.


Rating
The AI Support Assistant is great. It provides comprehensive assistance even on the most difficult issues. I highly recommend this service.
Rate 1
John Jordan
SAP Consultant & Author