How To Fix /SCMTMS/TCCS670 - Flat amount and rate table cannot exist for calc. sheet &1 item no. &2

SAP Error Message - Details

• Message type: E = Error

• Message class: /SCMTMS/TCCS -

• Message number: 670

• Message text: Flat amount and rate table cannot exist for calc. sheet &1 item no. &2

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 /SCMTMS/TCCS670 - Flat amount and rate table cannot exist for calc. sheet &1 item no. &2 ?

  The SAP error message /SCMTMS/TCCS670 indicates that there is a conflict in the configuration of the calculation sheet in the Transportation Management System (TMS). Specifically, it states that a flat amount and a rate table cannot coexist for the same calculation sheet item.
  Cause:
  This error typically arises when:
  
  Configuration Conflict: The calculation sheet is configured to use both a flat amount and a rate table for the same item, which is not allowed.
  Incorrect Setup: The setup of the calculation sheet may have been done incorrectly, leading to this conflict.
  Data Entry Error: There may have been an error during data entry or configuration where both types of pricing were inadvertently assigned to the same item.
  
  Solution:
  To resolve this error, you can take the following steps:
  
  
  Review Calculation Sheet Configuration:
  
  Go to the configuration of the calculation sheet in TMS.
  Check the item number specified in the error message.
  Ensure that for that specific item, you are either using a flat amount or a rate table, but not both.
  
  
  
  Modify the Calculation Sheet:
  
  If both a flat amount and a rate table are defined for the same item, decide which one you want to keep.
  Remove the conflicting entry (either the flat amount or the rate table) from the calculation sheet.
  
  
  
  Test the Changes:
  
  After making the necessary adjustments, test the calculation sheet to ensure that the error no longer occurs.
  
  
  
  Consult Documentation:
  
  If you are unsure about the configuration, refer to the SAP documentation or help resources for guidance on setting up calculation sheets correctly.
  
  
  
  Seek Help from SAP Support:
  
  If the issue persists after checking the configuration, consider reaching out to SAP support for further assistance.
  
  
  
  Related Information:
  
  Transaction Codes: You may need to use transaction codes like /SCMTMS/TS to access the TMS configuration settings.
  SAP Notes: Check for any relevant SAP Notes that might address this specific error or provide additional insights.
  User Roles: Ensure that you have the necessary permissions to modify the calculation sheets in TMS.
  
  By following these steps, you should be able to resolve the error and ensure that your calculation sheets are configured correctly.