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

problem with currency format setting

Former Member — Fri, 06 Feb 2009 06:19:44 GMT

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

Re: problem with currency format setting

Former Member — Fri, 06 Feb 2009 06:24:04 GMT

Hi Shweta

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

That should do it.

Pushpraj

Re: problem with currency format setting

Former Member — Fri, 06 Feb 2009 06:24:11 GMT

just use the write statement ..

data : v_amount(20).

write FDES-WRSHB to v_amount.

Re: problem with currency format setting

Former Member — Fri, 06 Feb 2009 06:25:30 GMT

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

Re: problem with currency format setting

Former Member — Fri, 06 Feb 2009 06:28:50 GMT

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

Re: problem with currency format setting

Former Member — Fri, 06 Feb 2009 06:32:13 GMT

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.