How To Fix MC774 - Link the selection conditions with AND or OR


SAP Error Message - Details

  • Message type: E = Error

  • Message class: MC - Aggregate: views, matchcodes, lock objects

  • Message number: 774

  • Message text: Link the selection conditions with AND or OR

  • Show details Hide details
  • What causes this issue?

    No linking operator was specified between two selection conditions or a
    link which is not permitted was defined.

    System Response

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

    How to fix this error?

    Usually the lines of the selection condition are linked with AND. Two
    selection conditions for the same field can also be linked with OR. In
    this case OR has priority over AND.

    Error message extract from SAP system. Copyright SAP SE.


Smart SAP Assistant

  • What is the cause and solution for SAP error message MC774 - Link the selection conditions with AND or OR ?

    The SAP error message MC774, which states "Link the selection conditions with AND or OR," typically occurs in the context of reporting or data selection in SAP, particularly in the Material Management (MM) or Controlling (CO) modules. This error indicates that the selection criteria you have defined in your report or query are not properly linked with logical operators (AND/OR).

    Cause:

    1. Improper Linking of Selection Criteria: When you define multiple selection criteria in a report or query, SAP requires that these criteria be logically linked. If you have not specified how the criteria relate to each other (i.e., whether they should all be true at the same time (AND) or if at least one of them should be true (OR)), SAP will throw this error.
    2. Missing Logical Operators: Sometimes, users may forget to include logical operators when setting up their selection conditions, leading to ambiguity in how the system should interpret the criteria.

    Solution:

    To resolve the MC774 error, follow these steps:

    1. Review Selection Criteria: Go back to the selection screen of your report or query and review the criteria you have set.
    2. Add Logical Operators:
      • If you want all conditions to be true for the selection (e.g., Material Type = A AND Plant = 1000), ensure you use the AND operator.
      • If you want at least one condition to be true (e.g., Material Type = A OR Material Type = B), use the OR operator.
    3. Use the Correct Syntax: Ensure that the syntax for linking conditions is correct. This may vary depending on the specific report or query you are using.
    4. Test the Report/Query: After making the necessary adjustments, run the report or query again to see if the error persists.

    Related Information:

    • Documentation: Check SAP documentation or help files related to the specific transaction or report you are using for more detailed guidance on setting selection criteria.
    • SAP Notes: Look for any relevant SAP Notes that might address this error or provide additional context.
    • User Forums: Consider visiting SAP community forums or user groups where similar issues may have been discussed, and solutions shared.

    If the error persists after following these steps, it may be beneficial to consult with your SAP support team or a technical consultant who can provide more in-depth assistance.

    • Do you have any question about this error?


      Upgrade now to chat with this error.


Instant HelpGet instant SAP help. Start your 7-day free trial now.


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