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

Close

How To Fix W_CB117 - No entry found for tax category &1 and tax classification customer &2


SAP Error Message - Details

  • Message type: E = Error

  • Message class: W_CB -

  • Message number: 117

  • Message text: No entry found for tax category &1 and tax classification customer &2

  • 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_CB117 - No entry found for tax category &1 and tax classification customer &2 ?

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


    SAP Error Message:

    W_CB117 No entry found for tax category &1 and tax classification customer &2


    Meaning / Cause:

    This warning message occurs during tax determination in sales and distribution (SD) or financial accounting (FI) processes. It indicates that the system could not find a valid tax code or tax condition record for the combination of:

    • Tax Category (e.g., domestic, intra-community, export, etc.) represented by &1
    • Tax Classification of the Customer (e.g., tax exempt, reduced rate, standard rate) represented by &2

    In other words, the system is trying to determine the tax for a transaction but cannot find a matching entry in the tax condition tables or tax classification settings for the customer and the tax category involved.


    Common Causes:

    1. Missing or incomplete tax condition records in the pricing procedure or tax condition tables (e.g., condition type MWST).
    2. Customer master data missing or incorrect tax classification in the sales area or accounting view.
    3. Incorrect or missing tax category configuration in the system for the country or region.
    4. Tax determination procedure not properly maintained for the combination of customer tax classification and tax category.
    5. Incorrect or missing tax codes in the transaction or master data.

    Where to Check / Solution:

    1. Check Customer Master Data:

      • Transaction: XD03 (Display Customer)
      • Go to Sales Area Data ? Billing ? Tax Classification
      • Verify that the tax classification is maintained correctly for the customer.
    2. Check Tax Condition Records:

      • Transaction: VK13 (Display Condition Records)
      • Check condition type related to tax (e.g., MWST) for the relevant sales organization, distribution channel, and country.
      • Ensure that condition records exist for the tax category and customer tax classification.
    3. Check Tax Determination Procedure:

      • Transaction: OBYZ (Assign Tax Procedure to Country)
      • Verify that the correct tax procedure is assigned to the country.
      • Transaction: FTXP (Maintain Tax Codes)
      • Check if tax codes are properly maintained for the country and tax category.
    4. Check Tax Category and Tax Classification Mapping:

      • Transaction: OBQ2 (Assign Tax Categories to Tax Classification)
      • Ensure that the tax category &1 is assigned to the customer tax classification &2.
    5. Review Pricing Procedure:

      • Transaction: V/08 (Maintain Pricing Procedures)
      • Check if the tax condition type is included in the pricing procedure.

    Additional Notes:

    • This message is a warning (W), so the system allows the transaction to proceed but flags that tax determination may be incomplete or incorrect.
    • If this warning appears frequently, it may lead to incorrect tax postings or billing documents.
    • Proper tax configuration is critical for compliance with tax laws and correct financial reporting.

    Summary:

    Aspect Details
    Error Message W_CB117 No entry found for tax category &1 and tax classification customer &2
    Cause Missing tax condition record or incorrect tax classification for customer and tax category
    Solution Maintain customer tax classification, tax condition records, tax codes, and tax procedures
    Transactions to Use XD03, VK13, OBYZ, FTXP, OBQ2, V/08

    If you need help with specific configuration steps or further troubleshooting, feel free to ask!

    • 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