3658722 - Decimal datatype mismatch for currency fields when replicating ODP extractors into SAP Datasphere Replication Flow

When replicating data from an S/4HANA system using ODP extractors into SAP Datasphere using replication flow, errors occur for certain currency fields.

The following error message appears in the replication flow mapping screen: "Enter a valid value for precision and scale".

SAP Datasphere. 

1. In SAP Datasphere, create a Replication Flow using an ODP extractor as the source.
2. Select a source extractor that contains currency fields delivered as DECFLOAT34.
3. Choose an existing SAP HANA Cloud target table where the corresponding fields are defined as DECIMAL (precision, scale).
4. Proceed to the Mapping screen of the Replication Flow.
5. The system displays the message:“Enter a valid value for precision and scale.”

Some currency fields provided by the source ODP extractor are delivered with the datatype DECFLOAT34.
In the target SAP HANA Cloud table, the corresponding fields are defined as DECIMAL (precision, scale). 

Since DECFLOAT34 and DECIMAL are not directly compatible, the Replication Flow UI raises a datatype validation error during mapping.

To resolve the datatype mismatch, ensure consistency between the source and target datatypes:

1. Create a new target table: use the “Copy from source schema” option in Replication Flow so that the target fields inherit the source datatypes automatically.
2. Or adjust the existing target table: update the affected currency fields in the target SAP HANA table to match the datatype delivered by the source (for example, DECFLOAT34).

ODP, Replication Flow, SAP Datasphere, datatype mismatch, currency fields, DECFLOAT34, DECIMAL, precision, scale, schema mapping , KBA , DS-DI-RF-UI , Replication Flow editor, monitoring and deployment , Problem