How To Fix CNV_20700236 - Inconsistent new value(s) - doesn't follow required settings

SAP Error Message - Details

• Message type: E = Error

• Message class: CNV_20700 - Material number conversion

• Message number: 236

• Message text: Inconsistent new value(s) - doesn't follow required settings

What causes this issue?

You are performing a material number conversion in the system and also
wants to reset(cancel) the lexicographic indicator.
<ZH>Caution</>
In transaction OMSL(Material Number Format), it is only possible to set
or reset (cancel) lexicographic indicator if no numeric material numbers
have been used yet in the system since they would no longer be
interpretable after setting or resetting this indicator.
Currently, new value is numeric in the mapping and this type of value is
not allowed to switch uncheck the lexicographic indicator

System Response

Scenarios:
Only alphanumeric exists: If all the materials are alphanumeric in the
system then the lexicographic indicator can be unchecked in the material
number format customization (transaction: OMSL) and then required
conversion should be using scenario Mapping Table OR Mapping Table and
Number Range
Numeric material exists:
If target new value for all of them is alphanumeric then do the
conversion in the system with scenario Mapping Table or Lexicographic +
Mapping Table, then the lexicographic indicator can be unchecked in the
material number format customization (transaction: OMSL)
If target new value for any of them numeric then open an incident in
component CA-LT-CNV.

How to fix this error?

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

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 CNV_20700236 - Inconsistent new value(s) - doesn't follow required settings ?

  The SAP error message CNV_20700236 typically indicates that there is an inconsistency in the data being processed, particularly when it comes to the new values not adhering to the required settings or constraints defined in the system. This error often arises during data migration or conversion processes, especially when using SAP's data migration tools.
  Cause:
  
  
  Data Inconsistency: The new values being introduced do not meet the validation rules or constraints set in the target system. This could be due to:
  
  Incorrect data formats.
  Values that exceed defined limits (e.g., numeric ranges).
  Missing mandatory fields.
  Values that do not exist in the reference tables.
  
  
  
  Configuration Issues: The settings in the target system may not be aligned with the incoming data. This could include:
  
  Incorrectly configured field settings.
  Mismatched data types between source and target systems.
  
  
  
  Business Rules Violations: The new values may violate specific business rules that have been implemented in the target system.
  
  
  Solution:
  
  
  Data Validation: Review the data being migrated to ensure that it adheres to the required formats and constraints. This may involve:
  
  Checking for mandatory fields and ensuring they are populated.
  Validating that numeric values fall within acceptable ranges.
  Ensuring that any reference values exist in the target system.
  
  
  
  Adjust Configuration: If the issue is due to configuration settings, you may need to:
  
  Review and adjust the field settings in the target system to align with the incoming data.
  Ensure that any necessary configuration changes are made to accommodate the new values.
  
  
  
  Error Logs: Check the detailed error logs provided by the migration tool. These logs can give you specific information about which values are causing the inconsistency.
  
  
  Testing: After making adjustments, conduct thorough testing to ensure that the data migration process works as expected without triggering the error.
  
  
  Consult Documentation: Refer to SAP documentation or notes related to the specific migration tool you are using, as they may provide additional insights or updates regarding known issues and their resolutions.
  
  
  Related Information:
  
  SAP Notes: Look for relevant SAP Notes that may address this specific error or provide guidance on data migration best practices.
  Community Forums: Engage with SAP community forums or support channels where other users may have encountered and resolved similar issues.
  Data Migration Tools: Familiarize yourself with the specific data migration tools being used (e.g., SAP S/4HANA Migration Cockpit, SAP Data Services) as they may have specific guidelines for handling data inconsistencies.
  
  By following these steps, you should be able to identify the root cause of the error and implement a solution to resolve it.