topic Re: Batch input - decimal value - comma or point in Application Development and Automation Discussions

Batch input - decimal value - comma or point

Former Member — Mon, 31 Mar 2008 06:11:46 GMT

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

Former Member — Mon, 31 Mar 2008 06:23:46 GMT

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.

asik_shameem — Mon, 31 Mar 2008 06:31:23 GMT

Hi,

You can use the keyword TRANSLATE.

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

TRANSLATE  lv_amount USING c_pointc.

Former Member — Mon, 31 Mar 2008 07:10:20 GMT

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.