topic Decimal notation for different user defaults in Application Development and Automation Discussions

Decimal notation for different user defaults

Former Member — Tue, 16 Oct 2007 14:16:58 GMT

Ok , the problem that i am facin is as follows :

I have a input field which is of type decimal .The value in this field is taken and updated to a table using BDC call transaction. Now when the user default setting is 1,234,567.890 the program works fine. For example if I input 3 , then the value entered is 3.000 . Which is correct. If the default setting is changed to 1.234.567,890 , the program automatically adds 3 zeros before the decimal . So if I enter 3 , the value input is 3.000,000 instead of 3,000

Is there a solution for this. I have checked the attributes and the Fixed point arithmatic is checked. I tried both with checked and unchecked...and the problem persists.

Re: Decimal notation for different user defaults

Former Member — Tue, 16 Oct 2007 14:20:02 GMT

Hi,

Move that field to a charecter type field and move the charecter type field to BDC data

to move the field to a charecter type, then use WRITE TO option

Regards

Sudheer

Re: Decimal notation for different user defaults

Former Member — Tue, 16 Oct 2007 15:29:46 GMT

I tried writing it to type C , but the problem persists. Is there any other solution ?

Re: Decimal notation for different user defaults

Former Member — Tue, 16 Oct 2007 15:34:47 GMT

You need to first get the user settings. So you need to get value of DCPFM from table USR01 for that user id.

There are 3 different notations to display amount for user. Check these settings and based upon these settings, pass the amount value to CHAR field. While passing you need to take care of ',' and '.' as based upon user setttings the meaning of ',' and '.' varies.

Hope this helps.

ashish