How To Fix FOT_TDT005 - Deactivation: condition record is deleted. Posted documents are affected.

SAP Error Message - Details

• Message type: E = Error

• Message class: FOT_TDT -

• Message number: 005

• Message text: Deactivation: condition record is deleted. Posted documents are affected.

What causes this issue?

Time dependent tax calculation is active. A deactivation of a tax rate
means, that in the pricing tool the corresponding condition record is
deleted.
This means, that documents posted with that condition record are
affected:
For example:
- It is not possible anymore to show the tax rate in document display
- It is not possible to calculate the tax again for example because of
reconciliation purposes. See report RFUMSV00
- It is not possible to cancel the document
- It is not possible to pay or clear the document, when a payment
differents leads to a tax recalculation.

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

System Response

How to fix this error?

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message FOT_TDT005 - Deactivation: condition record is deleted. Posted documents are affected. ?

  The SAP error message FOT_TDT005 indicates that there is an issue with a condition record that has been deleted, which affects posted documents. This typically occurs in the context of financial transactions or pricing conditions where the system expects a valid condition record to be present, but it has been removed.
  Cause:
  
  Deleted Condition Record: The primary cause of this error is that a condition record that was previously used in a transaction has been deleted. This can happen due to data maintenance activities, such as cleaning up old records or incorrect deletions.
  Posted Documents: The error specifically mentions that posted documents are affected, meaning that the deletion of the condition record has implications for documents that have already been processed and recorded in the system.
  Inconsistent Data: The deletion may lead to inconsistencies in the data, as the system expects to find a valid condition record for calculations or validations.
  
  Solution:
  
  Restore the Condition Record: If possible, restore the deleted condition record. This can be done if you have a backup or if the record can be recreated based on the original data.
  Check for Dependencies: Review the dependencies of the condition record. Ensure that any related documents or transactions are updated accordingly to reflect the current state of the condition records.
  Adjust Posted Documents: If the condition record cannot be restored, you may need to adjust the posted documents that are affected. This could involve reversing transactions or making corrections to ensure that the system can process the documents without the deleted condition record.
  Consult SAP Notes: Check for any relevant SAP Notes or updates that may address this specific error. SAP frequently releases patches and notes that can provide guidance on resolving specific issues.
  Contact SAP Support: If the issue persists and cannot be resolved through the above steps, consider reaching out to SAP support for assistance. They can provide more detailed guidance based on your specific system configuration and the nature of the error.
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with transaction codes related to condition records, such as VK11 (Create Condition), VK12 (Change Condition), and VK13 (Display Condition).
  Data Consistency Checks: Regularly perform data consistency checks to identify and resolve issues related to deleted records before they affect posted documents.
  Documentation: Maintain proper documentation of changes made to condition records to track deletions and modifications, which can help in troubleshooting similar issues in the future.
  
  By following these steps, you should be able to address the FOT_TDT005 error and restore the integrity of your SAP system's data.