topic Re: thousand seprator in Application Development and Automation Discussions

thousand seprator

Former Member — Mon, 08 Oct 2007 05:01:05 GMT

Hi I need thousand seprator

For my report

I am getting 123456.789

i need as 123,456.789

Re: thousand seprator

Former Member — Mon, 08 Oct 2007 05:04:24 GMT

Goto System -> User Profile -> Default Tab => Change Decimal notation as required.

Please give me reward point If it is useful

Thanks

Murali Poli

Re: thousand seprator

Former Member — Mon, 08 Oct 2007 05:13:55 GMT

hi,

Declare a character field for storing the value .

use WRITE numfield TO charfield.

This will add the thousand separator on its own.

cheers

Re: thousand seprator

Former Member — Mon, 08 Oct 2007 07:42:28 GMT

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.

Re: thousand seprator

Former Member — Mon, 08 Oct 2007 08:57:27 GMT

HI,

check the settings in tcode oy01.

regards

siva

Re: thousand seprator

Former Member — Mon, 08 Oct 2007 09:20:30 GMT

Hi,

We can change by using transaction code oy01. In that transaction code change the Dec pt.format ( Date format and Decimal character).

thanks&regards

venkat

Please reward if it is helpful.