topic Re: problem with currency in Application Development and Automation Discussions

problem with currency

Former Member — Fri, 01 Sep 2006 08:51:29 GMT

hi to all

i had the problem with currency .iam taking from mhnd-dmshb it is working fine for all european countries but when it is for non europe it is giving a problem.

for example iam taking the value as 5,000.00.when coming to dmshb it is becoming 5.000,00 in reverse and when i use amount stringconvert it is giving error e203 more than 2 decimals

can plz suugest me solution

Hi kishan, when the data is retrieved from the MHND-DMSHB for Amount, this is dependent on the country of the customer. For example, when the customer country is CA or US, the amount comes as for eg. 5,500.00 and if the customer country is NL or FR, then the amount comes as 5.500,00. This is what causing the problem when the data enters the function module. Is there any solution wherein we can the amount remains 5.500,00 irrespective of the country of the customer?

Thanks in advance,

Kiran Kumar

thanks in advance

Message was edited by: kiran kumar

Re: problem with currency

Former Member — Fri, 01 Sep 2006 08:53:20 GMT

kiran.

for europian countries like france decimal use by,(comma)

and ,(comma) use like decimal.

it just reverse...

Re: problem with currency

Former Member — Fri, 01 Sep 2006 09:04:44 GMT

hi,

The thousands separator and decimal separtor depends on the country. To specify a format, we can use Set country statement.

SET COUNTRY 'US'.

Then, thousands separator will be ',' and decimal separator will be '.'.

If you specify any european country, thousands separator will be '.', and decimlas separator will be ','.

you can even change the specification in the settings of a user. tcode -> SU01.

Regards,

Sailaja.

Re: problem with currency

Former Member — Fri, 01 Sep 2006 09:08:33 GMT

hi shilaja when the field is in data base it is 5.000,00but it is populated to program from mhnd-dmshb it is showing as 5,000.00 and when i pass this to functional module it is giving more than two decimals.

READ TABLE IT_IN WITH KEY 'MHND-DMSHB'.

CHECK SY-SUBRC = 0.

WRITE IT_IN-VALUE TO AMOUNT.

here it is changing and my local currency is eur.

plz suggest the solution

Re: problem with currency

Former Member — Fri, 01 Sep 2006 09:18:52 GMT

Hi kiran,

GOto...su01. in the default tab u can change the Decimal Notation.

Try it.