topic type casting with decimals in Application Development and Automation Discussions

type casting with decimals

Former Member — Wed, 06 Jun 2007 22:12:50 GMT

I have three data objects

mglme length 13, decimal 3 type quan

kbetr length 11, decimal 2 type curr

netwr length 15, decimal 2 type curr

I need to do kbetr = netwr / mglme

But I never get the right value because of the difference in data lengths

for e.g. netwr = 150.00 and mglme = 10.000 returns kbetr = .015

Any help on how to solve this. Thanks

Re: type casting with decimals

Former Member — Wed, 06 Jun 2007 22:44:24 GMT

Hi Megan,

Round off the decimals of all the fields before you do the division.

Check this thread for round off of decimals.

Hope it solves your problem.

Thanks

Aneesh.

Re: type casting with decimals

Former Member — Thu, 07 Jun 2007 00:00:12 GMT

I have three data objects

mglme length 13, decimal 3 type quan

kbetr length 11, decimal 2 type curr

netwr length 15, decimal 2 type curr

declare three variables temporary.

data : lv_kbetr like vbak-netwr.

data : lv_mglme like vbak-netwr.

data : lv_netwr like vbak-netwr.

clear : lv_kbetr,

lv_mglme,

lv_netwr.

move : kbetr to lv_kbetr,

mglme to lv_mglme,

netwr to lv_netwr.

lv_kbetr = lv_netwr / lv_mglme.

move lv_kbetr to kbetr.

Now see the results.

Re: type casting with decimals

Former Member — Thu, 07 Jun 2007 01:15:35 GMT

data : var1 type p decimals 3,

var2 type p decimals 2.

curr and quan are database data type so you can not reffer them in your abap program the abap type is type p.

regards

shiba dutta

Re: type casting with decimals

former_member186741 — Thu, 07 Jun 2007 01:45:52 GMT

I don't believe this is happening becasue of the differences in the data lengths. I think it is because you are dealing with currency fields without referencing the involved currency. Some currencies, eg japanese yen, don't have decimal places, for all I know some may have more than 2. SAP gets round this by defining the attributes of each currency. The currency related variables can only be adjusted to the appropriate number of decimal places when they refer to the currency involved. If no currency reference is provided how can SAP work out how many decimal places you want to work with?

FOR EXAMPLE, create this simple program and you'll see what I mean.

REPORT ZNRW_CURRENCY .

parameters: P_curr1 type t001-waers default 'JPY',

p_curr2 type t001-waers default 'USD'.

DATA W_VALUE TYPE marc-VKUMC VALUE 1.

WRITE:/ W_VALUE CURRENCY P_CURR1,P_CURR1.

WRITE:/ W_VALUE CURRENCY P_CURR2,P_CURR2.