topic Re: Decimal Separator and Thousands Separator in Application Development and Automation Discussions

Decimal Separator and Thousands Separator

Former Member — Fri, 19 Sep 2008 08:16:12 GMT

Hi Experts,

Is there any FM can get the current user's decimal separator and thousands separator?

Thanks a lot!

Re: Decimal Separator and Thousands Separator

Former Member — Fri, 19 Sep 2008 08:22:34 GMT

Hi ,

check table USR01-DCPFM

regards

Prabhu

Re: Decimal Separator and Thousands Separator

Former Member — Fri, 19 Sep 2008 08:34:36 GMT

Check out the tcode SU01

Specify the username

In Decimals tab..you can see the separators.

Regards,

Prashant

Re: Decimal Separator and Thousands Separator

Former Member — Fri, 19 Sep 2008 08:48:34 GMT

Hi Luke,

Try the following FM;

CALL FUNCTION '/OSP/GET_DECIMAL_NOTATION'
  EXPORTING
    i_uname                   = 'SAPUSER'
 IMPORTING
*   ET_RETURN                 =
   EV_DECIMAL_NOTATION       = lv_dec_not
   EV_TEXT                   = lv_text .

When i executed;

lv_dec_not returned 'X' and

lv_text returned 1,234,567.89

Regards

Karthik D

Edited by: Karthik D on Sep 19, 2008 2:18 PM

Re: Decimal Separator and Thousands Separator

Former Member — Fri, 19 Sep 2008 08:53:01 GMT

USR01-DCPFM permit value '', 'X', 'Y', which represents 3 type of number format. Are these fromat fixed or they can be configured to diffrenet format?

If it is the later case, I still want a SAP standard FM to get the separator other than hard coded the logic in program. Because the format might change.

Re: Decimal Separator and Thousands Separator

Former Member — Wed, 24 Sep 2008 09:07:19 GMT

Hi Karthik,

Sorry for the late response. I think this FM should solve my problem. Points were given to you:-) Thanks a lot!