10-08-2007 6:01 AM
Hi I need thousand seprator
For my report
I am getting 123456.789
i need as 123,456.789
10-08-2007 9:57 AM
10-08-2007 6:04 AM
Goto System -> User Profile -> Default Tab => Change Decimal notation as required.
Please give me reward point If it is useful
Thanks
Murali Poli
10-08-2007 6:13 AM
hi,
Declare a character field for storing the value .
use WRITE numfield TO charfield.
This will add the thousand separator on its own.
cheers
L
10-08-2007 8:42 AM
Hi,
Check the below code.
DATA: v_amount TYPE p DECIMALS 3 VALUE '123456.789'.
DATA: v_amount_char1(20),
v_amount_deci(20),
v_length TYPE i,
v_tot_length TYPE i,
v_main_number(20).
MOVE v_amount TO v_amount_char1.
SPLIT v_amount_char1 AT '.' INTO v_amount_char1 v_amount_deci.
CONDENSE: v_amount_deci, v_amount_char1.
v_tot_length = strlen( v_amount_char1 ).
IF v_tot_length > 3.
v_length = v_tot_length - 3.
v_tot_length = v_tot_length - 1.
CONCATENATE v_amount_char1+0(v_length) ','
v_amount_char1+v_length(v_tot_length) '.'
v_amount_deci INTO v_main_number.
WRITE:/ v_main_number.
ELSE.
CONDENSE v_amount_char1.
CONCATENATE v_amount_char1 '.' v_amount_deci INTO v_main_number.
WRITE:/ v_main_number.
ENDIF.
10-08-2007 9:57 AM
10-08-2007 10:20 AM
Hi,
We can change by using transaction code oy01. In that transaction code change the Dec pt.format ( Date format and Decimal character).
thanks®ards
venkat
Please reward if it is helpful.