Changing the decimal format during data input/upload

Former Member — Thu, 08 Feb 2007 08:32:59 GMT

Hi,

We use a custom program to read data from a text file and execute a transaction for creation of SC.

In case the decimal notation is 1,123,567.89 the upload is working fine and we are able to create the shoping cart.

But,some users have decimal format 1.123.567,89

In this case there is an error thrown. Is there some way to resolve this.

<b>This issue started coming after we changed the upload FM from WS_UPLOAD to GUI_UPLOAD.</b>

Is there a way to convert the decimal format once the data is uploaded or during the upload to 1,123,567.89?

Thanks,

Srivatsan

Re: Changing the decimal format during data input/upload

Former Member — Thu, 08 Feb 2007 08:40:20 GMT

use USR01 table and change the type as per the fm

DCPFM

' ' 1.234.567,89

X 1,234,567.89

Y 1 234 567,89

Regards

Shiva