Skip to Content
0

SAP Data Services: Idoc Processing: amounts get converted from . to ,

Oct 11, 2017 at 10:56 AM

42

avatar image
Former Member

Hi all,

I am posting an amount in an idoc. before posting from SAP Data Services the amount format is 100.00 € and when the idoc reaches SAP ERP the idoc failes, because the amount value is now 100,00 €.

If I manually manipulate the value from 100,00 to 100.00 in transaction WE19 then the idoc gets successfully posted.

I did not find the point where this conversion is applied.

Can anybody help me

Thanks,

Andrzej

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Oct 11, 2017 at 05:53 PM
0

What is the data type of the currency field in Data Services. Is it being changed somewhere in the job?.To debug this issue, execute the job in debug mode and see where the format getting changed or write the records into a .txt and check the currency format.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 12, 2017 at 08:42 AM
0

The data type is decimal(15,2) .

No it is not being changed in the job. I checked it while I replaced the IDOC with an XML file. So I can be sure that we are sending the value with a dot.

Share
10 |10000 characters needed characters left characters exceeded