How To Fix CNV20551747 - Deletion criteria cannot be processed as &1 is present in exception table

SAP Error Message - Details

• Message type: E = Error

• Message class: CNV20551 - message for package 20551 (company code delete)

• Message number: 747

• Message text: Deletion criteria cannot be processed as &1 is present in exception table

What causes this issue?

The deletion criteria of the table cannot be changed as the table is
standard SAP table and SAP recommends the deletion criteria of this
table not to be changed.
The table is present in CNV_20551_NOCONS table.

System Response

Error

How to fix this error?

Contact SAP if you want to change the deletion criteria of standard SAP
table.

Procedure for System Administrators

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message CNV20551747 - Deletion criteria cannot be processed as &1 is present in exception table ?

  The SAP error message CNV20551747 indicates that a deletion operation cannot be processed because a specific entry (denoted as &1) is present in an exception table. This typically occurs during data migration or data cleansing processes, particularly when using SAP's data migration tools or during the execution of a data deletion program.
  Cause:
  The error arises when the system detects that there are entries in an exception table that prevent the deletion of certain records. Exception tables are used to store records that should not be deleted due to various reasons, such as dependencies, constraints, or specific business rules that require those records to be retained.
  Solution:
  To resolve this error, you can follow these steps:
  
  
  Identify the Exception Table: Determine which exception table is causing the issue. The error message will usually provide the name of the table or the specific entry that is causing the problem.
  
  
  Review the Data: Check the contents of the exception table to understand why the entry is present. You can use transaction codes like SE11 (Data Dictionary) or SE16 (Data Browser) to view the table's contents.
  
  
  Analyze Dependencies: Investigate the dependencies of the records you are trying to delete. Ensure that there are no active references or relationships that would prevent deletion.
  
  
  Modify Deletion Criteria: If applicable, adjust your deletion criteria to exclude the records that are causing the issue. This may involve changing the selection criteria or modifying the data migration logic.
  
  
  Remove or Update Exception Entries: If it is appropriate and safe to do so, consider removing or updating the entries in the exception table that are preventing the deletion. Be cautious with this step, as it may have implications for data integrity.
  
  
  Consult Documentation: Refer to SAP documentation or notes related to the specific migration or deletion process you are using. There may be specific guidelines or best practices that can help you resolve the issue.
  
  
  Seek Support: If you are unable to resolve the issue on your own, consider reaching out to SAP support or your internal SAP team for assistance. They may have additional insights or tools to help you troubleshoot the problem.
  
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with relevant transaction codes such as SE11, SE16, and others that can help you analyze the data.
  SAP Notes: Check for any SAP Notes related to the error message CNV20551747, as they may provide specific fixes or workarounds.
  Data Migration Tools: If you are using specific SAP data migration tools (like SAP S/4HANA Migration Cockpit), review the documentation for those tools to understand how they handle exceptions and deletions.
  
  By following these steps, you should be able to identify the cause of the error and implement a solution to proceed with your data deletion or migration process.