How To Fix K8706 - Table T685A contains inconsistent records for application CQ

SAP Error Message - Details

• Message type: E = Error

• Message class: K8 - CO Planning: Messages for Function Group KAPP

• Message number: 706

• Message text: Table T685A contains inconsistent records for application CQ

What causes this issue?

Table T685A contains inconsistent records for application CQ.

How to fix this error?

Use transaction VK01 to check the condition types for application "CQ"
and usage "A".
"Control data 1":
The condition class must be "B", the calculation type "C" and the
condition category "I". The "Item condition" field must be selected.
"Changes which can be made"
The "Amount/percent" field must be selected
All other fields must be empty.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message K8706 - Table T685A contains inconsistent records for application CQ ?

  The SAP error message K8706 indicates that there are inconsistent records in the table T685A for the application area CQ (which typically relates to the Controlling module). This inconsistency can arise from various reasons, such as data corruption, incomplete configuration, or issues during data migration.
  Cause:
  
  Data Corruption: The records in the T685A table may have been corrupted due to system errors or improper data handling.
  Incomplete Configuration: If the configuration for the controlling area or related settings is not completed correctly, it can lead to inconsistencies.
  Transport Issues: If changes were transported from one system to another (e.g., from development to production) and not all necessary objects were included, it could lead to inconsistencies.
  Manual Changes: Direct changes to the database or incorrect manual entries can also cause inconsistencies.
  
  Solution:
  
  Check Configuration: Review the configuration settings for the controlling area and ensure that all necessary entries are correctly set up in the T685A table.
  Consistency Check: Use transaction code KKAO (or similar) to perform a consistency check on the controlling area. This can help identify and rectify inconsistencies.
  Recreate Entries: If specific entries in T685A are found to be inconsistent, you may need to delete and recreate them. Ensure you have a backup before making changes.
  Transport Requests: If the issue arose after a transport, check the transport logs to ensure all necessary objects were included and correctly transported.
  SAP Notes: Check the SAP Support Portal for any relevant SAP Notes that may address this specific error. There may be patches or updates that resolve known issues.
  Consult Documentation: Review SAP documentation for the Controlling module to ensure that all necessary steps have been followed in the configuration process.
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with relevant transaction codes such as KKAO, OKKP, and OKB9 for controlling area settings.
  SAP Support: If the issue persists, consider reaching out to SAP Support for assistance. They can provide guidance based on the specific details of your system and configuration.
  Backup: Always ensure that you have a backup of your data before making any changes to the database or configuration settings.
  
  By following these steps, you should be able to identify and resolve the inconsistency in the T685A table for application CQ.