on 02-06-2016 4:07 PM
Hello,
I encounter a problem when I use DTW to import exchange rates to fill the ORTT table.
Here is the structure of the CSV comma separated file I upload :
Date | Currency | Value |
---|---|---|
Date | Currency | Value |
06.02.2016 | USD | 2 |
Whenever value has no decimal (example here : 2), the import runs smoothly with no problem.
Date | Currency | Value |
---|---|---|
Date | Currency | Value |
06.02.2016 | USD | 2.2 |
However, when the value has a decimal (example : 2.2), the import fails !
As the company is French the dot (.) is set as the decimal symbol.
Any help and thoughts would be much appreciated.
Regard,
Olivier
Please check SAP note 2214046 for workaround.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for your kind support.
Actually, the issue is not related to the way my regional settings generate my comma separated csv file or tab separated txt file. When I open the file with a notepad, the data is clean.
My real issue is that wherever I put a number with a digit - (.) dot in France - the import fails. I have even tried to use tabulated separated txt file with (,) comma as digit symbol : fails too which makes sense as my sap b1 settings use the (.) dot as the digit symbol.
Thanks all for your help.
After few unsuccessful attempts, I have finally managed to execute the import.
That is the format of the file that was successful :
Date Currency Value
Date Currency Value
09.02.2016 USD 0,896
Basically
I hope this can help anyone willing to import the exchange rates with the DTW.
Regards,
Olivier
try Tab separated file.
Frank
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks again for your message Frank.
Unfortunately, I have just tried your advice, but i have the same problem with '06-02-2016' format : it works if value is a number with no decimal BUT does not work with a number with a decimal (object 65171 error).
Got any other clue ?
Thanks in advance for your help.
Thanks for your answer Nagarajan !
Unfortunately, date YYYYMMDD format does not work at all.
My problem is not the the date format. My problem is the value format that does not seem to accept a value with decimal... It works just fine with values with no decimal (integers) but does not work with values with decimal. I really have no clue of the issue...
Any help most welcomed.
Olivier
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.