Application Development 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: 

value with thousand separator

Former Member
0 Kudos
4,081

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

9 REPLIES 9

Former Member
0 Kudos
518

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

Former Member
0 Kudos
517

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

Former Member
0 Kudos
517

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

rainer_hbenthal
Active Contributor
0 Kudos
517

write  bsid-wrbtr  into stringvar

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

Former Member
0 Kudos
517

Hi

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

WRITE VARIABLE1 CURRENCY <CURRENCY CODE> TO VARIABLE2.

Max

Former Member
0 Kudos
517

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

Former Member
0 Kudos
517

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.

0 Kudos
517

Hi,

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

0 Kudos
517

Excellent!