How To Fix CNV797 - Data type &3 of the field &1 of the table &2 is not allowed

CNV797 - Overview

• Message type: E = Error

• Message class: CNV - Conversion: Messages for Conversion Services (CNCC)

• Message number: 797

• Message text: Data type &3 of the field &1 of the table &2 is not allowed

What causes this issue?

The values of the field &V1& in the table &V2& are processed by the
aggregate function (selected Aggregate Function: '&V4&'). In these
cases, the field &V1& must be of a numeric type (CURR, DEC, FLTP, INT1,
INT2, INT4, NUMC, PREC or QUAN). However the field &V1& is of type &V3&.

System Response

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

How to fix this error?

Error message extract from SAP system. Copyright SAP SE.

CNV797 - Details

• The SAP error message CNV797 indicates that there is an issue with the data type of a field in a table during a data conversion or migration process. Specifically, it means that the data type of the field is not allowed or is incompatible with the expected data type for that particular operation.
  
  Cause:
  
  Incompatible Data Types: The field in question has a data type that is not supported by the conversion program or the target structure.
  Data Type Mismatch: The source data type does not match the expected data type in the target system or table.
  
  Configuration Issues: There may be configuration settings in the data migration tool that are not aligned with the data types being used.
  Custom Fields: If the field is a custom field, it may not have been properly defined in the target system.
  
  
  Solution:
  
  Check Data Types: Review the data types of the field in both the source and target systems.