topic Re: value with thousand separator in Application Development and Automation Discussions

value with thousand separator

Former Member — Mon, 04 Feb 2008 11:53:18 GMT

hi,

i have variable1 like bsid-wrbtr but when stored in variable1 it only stores for example, 12345.80 and not 12,345.80.

may i know how to add the thousand separator into this variable1 where i subsequently move to a text type variable2. this text type variable2 will store value 12,345.80 and not 12345.80.

thanks

Re: value with thousand separator

Former Member — Mon, 04 Feb 2008 11:55:47 GMT

when u move CURR /QUAN fields to text variables, u will not get commas.

If u need it in print, use ALV thousand separator options

Narendra

Re: value with thousand separator

Former Member — Mon, 04 Feb 2008 11:57:37 GMT

Hi,

check your defalut user paramters

on the menu bar

system~~>User profile~~> own data

In that click on defaults and check Decimal notation

Regards,

Satish

Re: value with thousand separator

Former Member — Mon, 04 Feb 2008 11:58:03 GMT

Hi,

use this

data: val type bsik-wrbtr value '1434323.00'.

write:/ val.

if the output is 1434323.00

then change the settings in you user menu

system- user profile=- own data

defaults

Decimal Notation check here

regards,

Venkatesh

Re: value with thousand separator

rainer_hbenthal — Mon, 04 Feb 2008 11:58:49 GMT


write  bsid-wrbtr  into stringvar

where stringvar is a char or streing variable. Depending on your usersettings (transaction su3) the amount is formatted.

Re: value with thousand separator

Former Member — Mon, 04 Feb 2008 11:58:52 GMT

Use the WRITE statament to move the amount from currency field to char field:

WRITE VARIABLE1 CURRENCY <CURRENCY CODE> TO VARIABLE2.

Max

Re: value with thousand separator

Former Member — Mon, 04 Feb 2008 12:01:50 GMT

Hi,

System Internally stores the data in 1234.00 you will not find any comma for thousand separators. This separator will depend on the user profile. To check whether you have thousand separator or not.

Go to SU01 --> Input user name --> display --> Click on Default tab there you will find the Decimal notation.

And currency display notation will be changed from currency to currency. For that you need to write statement with currency.

Thanks,

Sriram Ponna.

Edited by: Sriram Ponna on Feb 4, 2008 5:32 PM

Re: value with thousand separator

Former Member — Mon, 04 Feb 2008 12:13:59 GMT

Ok..Try like this...


DATA l_amount TYPE bsid-wrbtr VALUE '12345.80'.

DATA l_char_amount(16).

WRITE l_amount TO l_char_amount.

WRITE :/ l_amount.
WRITE :/ l_char_amount.

Re: value with thousand separator

Former Member — Fri, 01 Aug 2008 07:30:03 GMT

Hi,

i was looking for a solution for this and thanx Perez C , ur solution has worked fine for me.thanx again.

Re: value with thousand separator

Former Member — Thu, 22 Dec 2011 07:54:09 GMT

Excellent!