problem with currency format setting

[Former Member]

hello experts,

i have one currency filed FDES-WRSHB = 25706515.32.

i want this field to be converted into currency format which user have selected.

for ex if user setting for currency in SU01 is 1,23,456.89 then this currency should be converted to 25,706,515.32.

or if default setting is 1.23.456,78 then it should be converted to 25.706.515,32.

please tell me how to achieve this... any FM available?

or tell me how to read these user default setting so i can explicitly convert currency format.

-Shweta

Edited by: shweta chavan on Feb 6, 2009 7:19 AM

[Former Member]

Hi Shweta

Declare a P or I type field and move FDES-WRSHB to that field.

That should do it.

Pushpraj

[Former Member]

just use the write statement ..

data : v_amount(20).

write FDES-WRSHB to v_amount.

[Former Member]

Hi,

Try this .

Take a charater variable .

write currency to this variable,then write it to FDES-WRSHB..

Edited by: Sreesudha Gullapalli on Feb 6, 2009 7:26 AM

[Former Member]

Fetch the value of system variable SY-CTYPE.

if SY-CTYPE = ' '

1.234.567,89

if SY-CTYPE = ' X'

X 1,234,567.89

if SY-CTYPE = 'Y'.

Y 1 234 567,89

[Former Member]

Hi Shweta,

I had the same issue,we dont need to do anything,the display will come automatically in the User format(specified in SU01/SU3).We dont need to use any FM or any coding.

If u chanegd any settings in SU01/SU3 u need to re-login to see the changes,for example the setting were like 1.23.456,78 and u changed to 1,23,456.89 then it will not reflected immediately.U need to log-off and log-in again to see the changes.

Hope this helps.

Thanks & Regards,

Rock.