Stop googling SAP errors. Use our Free Essentials plan instead - no credit card needed. Start Now

Close

How To Fix W/187 - & price lists and no materials were found for the selection


SAP Error Message - Details

  • Message type: E = Error

  • Message class: W/ -

  • Message number: 187

  • Message text: & price lists and no materials were found for the selection

  • Show details Hide details


  • Self-Explanatory Message

    Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of messages in the SAP system have a message text, however this is frequently insufficient to comprehend or resolve the problem.

    To make things easier, more detailed information is frequently added to describe the issue, how to fix it, and the necessary steps or configuration modifications.

    Unfortunately, there isn't any extra information in this error notice.



    What else can you do?

    First, use our AnswerBot below to get a possible cause and solution (requires a premium subscription).

    Also, review the in-depth Common Questions & Answers listed below; you could discover a solution there or be able to connect with others who have faced similar challenges.

    You can also try searching the SAP support portal (support.sap.com) but you need a special user ID to access it. It is possible that an SAP support note exists that provides additional details about the mistake or even steps for fixing it.


Smart SAP Assistant

  • What is the cause and solution for SAP error message W/187 - & price lists and no materials were found for the selection ?

    Certainly! Here's a detailed explanation regarding the SAP warning message W/187 related to price lists and no materials found for the selection:


    SAP Message W/187: "Price lists and no materials were found for the selection"

    Cause:

    • This warning message typically occurs when you execute a report or transaction that involves price lists (e.g., condition records, pricing reports, or material price lists), but the system does not find any materials matching the selection criteria.
    • Possible reasons include:
      • The selection criteria (material numbers, material groups, plants, etc.) do not correspond to any existing materials in the system.
      • The price list or condition records exist, but no materials are assigned or linked to those price lists for the selected parameters.
      • Incorrect or overly restrictive selection parameters (e.g., date range, material group, sales organization) that exclude all materials.
      • Master data inconsistencies or missing data (e.g., materials not maintained in the relevant plant or sales area).

    Solution:

    1. Check Selection Criteria:

      • Review the input parameters used in the report or transaction.
      • Broaden the selection criteria to include more materials or different material groups.
      • Verify that the plant, sales organization, distribution channel, and other organizational units are correctly specified.
    2. Verify Material Master Data:

      • Ensure that the materials exist in the system and are active.
      • Check if the materials are assigned to the relevant plants and sales areas.
      • Confirm that the materials have valid pricing conditions or price lists maintained.
    3. Check Condition Records / Price Lists:

      • Use transaction codes like VK13 (Display Condition Records) or VK11 (Create Condition Records) to verify if price lists or condition records exist for the materials.
      • Confirm that the condition records are valid for the selected date range and organizational units.
    4. Adjust or Maintain Data:

      • If no materials are linked to the price lists, maintain the necessary condition records or price lists.
      • If materials are missing, create or update the material master data accordingly.
    5. Consult Logs or Debug:

      • If the issue persists, check application logs or enable debugging to trace why no materials are found.

    Related Information:

    • Transaction Codes:
      • VK13 – Display Condition Records
      • VK11 – Create Condition Records
      • MM03 – Display Material Master
      • MM02 – Change Material Master
      • MEK1/MEK2/MEK3 – Maintain/Change/Display Conditions for Purchasing (if relevant)
    • Tables:
      • KONV – Conditions (Transaction Data)
      • KOMP – Condition Components
      • MARA – General Material Data
      • MVKE – Sales Data for Material
    • Notes:
      • This warning does not stop processing but indicates that the output or report may be incomplete or empty.
      • Always ensure that master data and condition records are synchronized and correctly maintained.

    If you provide the exact transaction or context where this message appears, I can give more tailored advice.

    • Do you have any question about this error?


      Upgrade now to chat with this error.


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