Application Development and Automation 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: 
Read only

Batch input - decimal value - comma or point

Former Member
0 Likes
1,708

Hi all,

i have created a program with batch input.

Now i have a field which is a decimal value. Here i have the comma/point problem.

This is because of different configuration of the decimal format in the user settings.

Is there a function module which converts the decimal value into the right decimal format of the logged on user?

I know the fm BAPI_CURRENCY_CONV_TO_EXTERNAL and PP_CATT_CONVERT_DECIMAL_POINT.

But i think thats not the right ones.

regards

3 REPLIES 3
Read only

Former Member
0 Likes
867

Don't bother about the user settings. Just pass the value with out any "," or Thousand separator. Simply pass the value.

example : value is 10,000.00

then pass it 10000.00

conversion will take care automatically according to user settings.

You need to take care of convertion from "10,000.00" to 10000.00

Thats all. Don't make it complicate.

Read only

asik_shameem
Active Contributor
0 Likes
867

Hi,

You can use the keyword TRANSLATE.

DATA:    c_pointc(2) TYPE c VALUE '.,'  .

TRANSLATE  lv_amount USING c_pointc.

Read only

Former Member
0 Likes
867

hi frnd.

u can do it in a very easy method.

eg- if u have to written a value 12.36

u can write it 1236 / 100.

or if u need it for any decimal value in %.

u can write 1.33% of 64.

u can write it as 64 * 133 / 100.