How To Fix CM_SUB_INFOSYS034 - Query cannot be included; it contains a where-used list


SAP Error Message - Details

  • Message type: E = Error

  • Message class: CM_SUB_INFOSYS - Substance information system

  • Message number: 034

  • Message text: Query cannot be included; it contains a where-used list

  • Show details Hide details
  • What causes this issue?

    You attempted to include a
    <DS:GLOS.3699DDF3DD932996E10000009B38F9B7>query</> containing at least
    one <DS:GLOS.3696E119942B221EE10000009B38F9B7>query step</> that
    executes a where-used list. However, queries with where-used lists
    cannot be included since they may contain a change of specification
    category. If you change the sequence of the individual query steps in a
    query of this type, this can lead to an inconsistent result.

    System Response

    INCLUDE EHS_NA_NO_MAINTAIN OBJECT DOKU ID TX

    How to fix this error?

    Perform the search step by step and save the search history as a query.

    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 CM_SUB_INFOSYS034 - Query cannot be included; it contains a where-used list ?
    The SAP error message CM_SUB_INFOSYS034 indicates that a query cannot be included in a certain context because it contains a "where-used list." This typically occurs in the context of SAP BW (Business Warehouse) or SAP HANA when dealing with queries, InfoProviders, or data models.
    
    Cause: The error arises when you attempt to include a query that references a "where-used list." This means that the query is dependent on other objects or has dependencies that prevent it from being included in the current context. The "where-used list" indicates that the query is being used in other contexts or has dependencies that need to be resolved first.
    Solution: To resolve this error, you can take the following steps: Check Dependencies: Review the query to identify any dependencies it has on other objects. You can do this by checking the where-used list for the query in the SAP system. Modify the Query: If possible, modify the query to remove

    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
ERPlingo's SAP support assistant is amazing. Saves me countless hours trying to solve complex SAP issues myself. It's a real game changer!
Rate 1
Thomas Michael
SAP Consultant, Author & Speaker