topic Re: Regarding Decimal in Application Development and Automation Discussions

Regarding Decimal

Former Member — Mon, 23 Jun 2008 08:51:59 GMT

Hi all,

I need to remove decimal places, wats the best way to do that,

Eg: DMBTR = 3900.00, but i just want to display as 3,900

Thanks in advance

Re: Regarding Decimal

Former Member — Mon, 23 Jun 2008 08:54:26 GMT

Hi,

define a variable from type int and move your value inside it before you give it out.

Regards

Nicole

Re: Regarding Decimal

Former Member — Mon, 23 Jun 2008 08:55:59 GMT

Move the values to another varaiable of data type 'I' , it will display the whole numbers.

Thanks,

Ponraj.s.

Re: Regarding Decimal

Former Member — Mon, 23 Jun 2008 08:57:36 GMT

data : v_DMBTR type DMBTR value '3900.00'.

write v_DMBTR decimals 0.

Re: Regarding Decimal

Former Member — Mon, 23 Jun 2008 08:59:17 GMT

hiii

just move values in type ' I '..it will round your values.so output will be without decimal.

reward if useful

thx

twinkal

Re: Regarding Decimal

Former Member — Mon, 23 Jun 2008 08:59:31 GMT

You can use below code :

data : var1 type p decimasl 3 value '100.000'.

data : var2 type i.

var2 = var1.

write : var2.

O/P : 100.

Reward points

Cheers

Snehi

Re: Regarding Decimal

Former Member — Mon, 23 Jun 2008 09:03:12 GMT

data: v_test type p decimals 2 value '3900.00'.

data: out type p .

out = v_test .

write:/ out decimals 0.

Re: Regarding Decimal

Former Member — Mon, 23 Jun 2008 09:03:40 GMT

I did try to do the same , declared variable type int and tried to move the value, but wen i update the amount to internal table again it takes as 3900.00,

I am trying to avoid decimals because IDR dosent support decimal, expected result is 3,900,

but what I am getting is 390,000.

Re: Regarding Decimal

Former Member — Mon, 23 Jun 2008 09:16:19 GMT

if you want to print dmbtr without decimal then try dmbtr(C) , C will remove decimal

Re: Regarding Decimal

Former Member — Mon, 23 Jun 2008 09:32:35 GMT

Hi Soyunee,

Take the value into a character type field using write statement with currency or unit depanding on the type(i think for you it should be CURRENCY )

WRITE VALUE TO L_NETP CURRENCY WAERK.

here Value = 3900.00 and L_NETP is character field of same size as VALUE.

CURRENCY WAERK is the syntax try to put it as it is.

if any problem please let me know

3,900 (For comma) depends on decimal format defind in T005X table.

Thanks & Regards

Ankur

Re: Regarding Decimal

Former Member — Mon, 23 Jun 2008 09:49:21 GMT

This problem is becouse of the veriable you are using for your internal table

it is happening like this

Value in the field of internal table is : 3900.25

now you take this to an integer value it will be 3900

But when you will update this value back to ur internal table it will be 3900.00

Just declear one more internal table with same structure just change that particular field to char or integer type loop on the first table and copy the values to secand table.

delete the first table now you use your secand table in your program for further processing.

Reward points if helpful

Regards

Bikas

Re: Regarding Decimal

Former Member — Mon, 23 Jun 2008 09:50:15 GMT

Hi Ankur,

Here is the code for clear understading,

ORIGINAL

SELECT SINGLE * FROM tcurf WHERE fcurr EQ tbl_i_vbkpf-waers

AND tcurr = tbl_i_vbkpf-hwaer.

IF sy-subrc = 0.

l_kursf = tbl_i_vbkpf-kursf * ( tcurf-tfact ) / ( tcurf-ffact ).

ENDIF.

IF tbl_i_vbkpf-waers NE 'IDR'.

tbl_i_vbsegs-dmbtr = tbl_i_vbsegs-wrbtr * g_tbl_i_vbkpf-kursf * 10.

ENDIF.

Note: Local curreny is always IDR.

with the above coding I am facing issues when the document currency is JPY, the result is multiple of 10 for the original amount coz its multiplied by 10.

MODIFIED

tbl_i_vbsegs-dmbtr = tbl_i_vbsegs-wrbtr * l_kursf.

With this JPY to IDR is fine but the result USD to IDR is multiple of 100.

Can anyone please help me on this.

Re: Regarding Decimal

Former Member — Mon, 23 Jun 2008 10:11:39 GMT

DATA: LV_DEC TYPE P DECIMALS 2,

LV_CHAR TYPE CHAR20,

LV_NUM TYPE CHAR20,

LV_DEC1 TYPE CHAR20.

LV_DEC = '3902.00'.

LV_CHAR = LV_DEC.

SPLIT LV_CHAR AT '.' INTO LV_NUM LV_DEC1.

WRITE: LV_NUM.

Hope this helps...

Reward points if useful,

Janani

Re: Regarding Decimal

Former Member — Mon, 23 Jun 2008 10:27:29 GMT

Hi soyunee,

you are facing this problem probably because you are multiplying value with character value try to do all manupalation ,multiplication,operation with the original type not with the character type you have taken.

and at last convert

WRITE tbl_i_vbsegs-dmbtr TO L_VALUE CURRENCY tbl_i_vbkpf-waers

stil face problem tell me exact place you are using write statement

Thanks & Regards

Ankur