CPI-DS Decimal Datatype Separator

[brauncto]

In CPI-DS I have an SAP IBP system as source and an Odata service in an S4 system as target.

Source and target have a field with the datatype Deciaml(18,6). I map the fields, validation is fine, View Design-time Data shows multiple source and target entries mapped correctly, but in the target Odata service in the backend only the entries where the decimal field is null, are receivied. Last log entry in CPI-DS tells the correct selected number of entries, log of Odata service in S4 only shows the correct processing of the entries without decimal values.

Changing the OData's field to datatype VARCHAR/String (with internal field conversion in CPI-DS), makes all entries reach the backend.

The decimal values are shown in CPI-DS with a comma as decimal separator and reach the odata as string also with comma as separator. (In the source system, the value is calculated internally and not possibly wrong user input)

How/Where is the display of decimal fields and its separator defined in CPI-DS?

Can I assume that the decimal values are sent to an Odata service with the wrong decimal separator although they have the exact same data type definition in CPI-DS or did I miss something?

[Kumar_Shubham]

Solution : Login to CI-DS agent server and open control panel-> Change date, time or number format ->

Change the Format in the top to Unites States (English) If this is done then click on Additional Settings -> Change decimal symbol to  '.'  and Digit grouping symbol to ','.

[former_member423067]

Hello Christoph,

if you try saving the data to a file. Default Decimal format while extracting from IBP would be with a dot. like 39764.000000 . There would be no comma in it.

please check the decimal formatting in the target table datastore. see, if you can modify the way you need it. Hope that would fix your issue.

with regards

Nazeer