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

Close

How To Fix WRF_CONS101 - No entries found for plant &1 in table MKOL


SAP Error Message - Details

  • Message type: E = Error

  • Message class: WRF_CONS - Retail Fashion: Consignment Processing Stock Transfers

  • Message number: 101

  • Message text: No entries found for plant &1 in table MKOL

  • 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 WRF_CONS101 - No entries found for plant &1 in table MKOL ?

    Certainly! Here's a detailed explanation for the SAP error message:


    SAP Error Message:

    WRF_CONS101 No entries found for plant &1 in table MKOL


    Meaning / Cause:

    This error occurs when the system tries to find entries for a specific plant in the MKOL table but does not find any. The MKOL table in SAP contains consumption data for fixed assets (Asset Consumption). The plant (&1) mentioned in the error message does not have any corresponding entries in this table.

    Possible causes include:

    • The plant has not been assigned or linked properly to asset consumption data.
    • Asset consumption data for the plant has not been created or posted yet.
    • The system is trying to read consumption data for a plant that is not relevant or not maintained in the asset accounting module.
    • Custom or standard reports/programs are trying to access consumption data for a plant that does not exist in MKOL.

    Where is MKOL used?

    • MKOL stores consumption data for fixed assets.
    • It is used in asset accounting, especially in processes related to asset consumption, depreciation, and reporting.
    • Programs or reports that analyze asset consumption by plant will query this table.

    Solution / How to fix:

    1. Check if the plant exists and is correctly maintained:

      • Verify the plant number &1 in transaction OX10 (Define Plants).
      • Ensure the plant is active and correctly assigned in the system.
    2. Check asset consumption postings:

      • Verify if asset consumption postings exist for the plant.
      • Use transaction AW01N or AR01 to check asset postings.
      • If no consumption data exists, you may need to post asset consumption or depreciation for the plant.
    3. Check Customizing for Asset Accounting:

      • Verify if the plant is assigned to the correct company code and asset accounting area.
      • Use transaction OAA3 (Assign company code to asset accounting area).
      • Ensure that the plant is relevant for asset accounting.
    4. Data consistency check:

      • Run consistency checks for asset accounting (transaction AS91, AS92, or AS93).
      • Check for missing or inconsistent data in asset master records related to the plant.
    5. If the error occurs in a custom report or program:

      • Review the logic to ensure it only queries MKOL for plants that have asset consumption data.
      • Add error handling or checks before querying MKOL.
    6. If the plant should not have asset consumption data:

      • Modify the program/report or process to exclude this plant from MKOL queries.

    Additional Notes:

    • Table MKOL is a cluster table (part of asset accounting cluster data), so direct table access is limited. Use standard SAP transactions or reports to analyze data.
    • This error is often encountered during custom developments or reports that analyze asset consumption by plant.
    • If the problem persists, check OSS notes or SAP support for any known issues related to your SAP version.

    Summary:

    Aspect Details
    Error WRF_CONS101 No entries found for plant &1 in table MKOL
    Cause No asset consumption data exists for the specified plant in MKOL
    Solution Verify plant assignment, post asset consumption, check asset accounting customizing, adjust reports or programs
    Related Tables MKOL (asset consumption data), ANLA (asset master), T001W (plants)
    Transactions OX10, AW01N, AR01, OAA3, AS91-AS93

    If you provide more context (e.g., when the error occurs, which transaction or program), I can help with more specific guidance.

    • 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 simplifies finding the accurate answers to SAP message errors. I now use every week. A must have tool for anyone working with SAP! Highly recommended!
Rate 1
Kent Bettisworth
Executive SAP Consultant