‎2006 Jun 02 3:39 PM
Hi ,
I have a amount field having value "33329.00"
I need to convert it to "33,229.00".
How do i proceed?
Regards
Nishant
‎2006 Jun 02 3:40 PM
Statement WRITE field1 TO field2 will add this formating.
Peter
‎2006 Jun 02 3:41 PM
hi Nishanth,
do this way.
data: f1 type i,
f2 type i.
Write f1 to f3.
Regards,
Santosh
‎2006 Jun 02 3:42 PM
‎2006 Jun 02 3:41 PM
assign this value to any type I or type P variables.
Cheers,
Abdul Hakim
Mark all useful answers..
‎2006 Jun 02 3:42 PM
Hi
Use write statament:
DATA: AMOUNT TYPE WRBTR VALUE '33329.00',
AMOUNT_C(20) TYPE C.
WRITE AMOUNT CURRENCY 'EUR' TO AMOUNT_C.
Max
‎2006 Jun 02 3:42 PM
MOve it to a field of type <b>wrbtr</b>.
It would be automatically converted to the format you want.
data: v_amt_new type wrtbr.
move v_amt to v_amt_new.
write v_amt_new.
Regards,
Ravi
‎2006 Jun 02 3:42 PM
Nishant,
Look at the EDIT MASK option of the WRITE statement.
Regards,
Ravi
‎2006 Jun 02 3:43 PM
‎2006 Jun 02 3:43 PM
Hi
set the thousand seperator in system -> userprofile -> owndata -> deafults