Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Decimal Separator and Thousands Separator

Former Member
0 Likes
9,613

Hi Experts,

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

Thanks a lot!

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
4,574

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

Hi Experts,

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

Thanks a lot!

5 REPLIES 5
Read only

Former Member
0 Likes
4,574

Hi ,

check table USR01-DCPFM

regards

Prabhu

Read only

0 Likes
4,574

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.

Read only

Former Member
0 Likes
4,574

Check out the tcode SU01

Specify the username

In Decimals tab..you can see the separators.

Regards,

Prashant

Read only

Former Member
0 Likes
4,575

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

Read only

Former Member
0 Likes
4,574

Hi Karthik,

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