Decimal separator issue in .dat file - OCC tool

[ashish25bp]

Hi Experts,

I am facing an issue while converting .dat file in OCC tool.

I have UTF 8 unicode .txt file which we usually convert in OCC tool to prepare .dat file.

This file has several property values for example:

• Acute Oral toxity value 1.67mg/kg (decimal separator as dot)
• Acute Dermal Toxity value 2,700mg/kg (decimal separator as coma)

My settings in OCC tool for DN is " . " (dot)

Now when the .dat file is generated it converts 2,700mg/kg as 2.700mg/kg . It should have not converted to "dot" I assume and should remain "coma" only.

Where as the 1.67mg/kg remains unchanged.

Since this is done in offline mode the SAP user profile my not be impacting.

Can anyone please suggest on this.

Thanks In advance

Ashish

[christoph_bergemann · Accepted solution]

Hello Ashish

the handling of "floating point" data in combination with "UOM" is not easy. We have on the top to consider the settings in "Sap Gui".

Let us start with basics... and then ceck options.

a.) floating point data with UOM is save in "one format" only in the data base

b.) The "look and feel" of such data is steered by user settings in SAP Gui (so for some user the "comma" should show as a "dot" and vice versa

c.) I believe you could try this

1.) seperate the data in your "OCC Load" file. The "Dot" data in one file and the "comma" data in a different one

Check then you settings in SAP Gui.

If you would like to load "dot" data: the SAP Gui settings should fit; if you would like to load "comma" data: the same

I would assume the "online OCC" mode can then do a "proper" load..

Yes it is a a "two step" process... but you shoul try it

C.B.

[ashish25bp]

Thank you Christoph for suggestion,

Based on the above discussion I got a hint and a workaround. I did earlier checked the user setting but I was relating that with the .dat file generated. But then I realized that while loading in SAP it is actually putting coma/dot based in the user setting Decimal Notation for eg. 1,234,567.89

In this case If I have to load 2,700mg/kg it is actually a thousand separator. So I just removed the coma "," from the load file and generated .dat as 2700mg/kg. Thus it got loaded as 2,700mg/kg based on my user setting Decimal Notation.