topic Re: Problem with amounts in Internal Table in Application Development and Automation Discussions

Problem with amounts in Internal Table

Former Member — Mon, 29 Jan 2007 20:26:23 GMT

I have 2 internal tables with header line . I am doing the following operation.

itab2-amt = itab2-amt + itab-amt .

itab2-amt1 = itab2-amt1 + itab-amt1.

amt and amt1 are defined as 9 characters each .

In Debug mode itab amt and amt 1 show as 1110.34 and 2222.22 .

But when I do the above operation

itab2-amt = 111034

itab2-amt1 = 222222

Please advise .

Thanks ,

Hari

Re: Problem with amounts in Internal Table

Former Member — Mon, 29 Jan 2007 20:28:53 GMT

See if the check box for fixed point arithmetic is chosen in the program attruibutes section.

Regards,

Ravi

Re: Problem with amounts in Internal Table

Former Member — Mon, 29 Jan 2007 20:52:14 GMT

I checked it looks good . But why is that in one internal table it is different from the other .

Thanks ,

Hari

Re: Problem with amounts in Internal Table

Former Member — Mon, 29 Jan 2007 21:27:50 GMT

Hi,

Do not perform arithmetic operations on character fields.

Check if the field is referring to NUMC, if yes try to define as a packed decimal and do the operations.

After all your operations are done, and you want it to be stored into a character data type, you may move it to another variable.

Regards

Subramanian

Re: Problem with amounts in Internal Table

Former Member — Mon, 29 Jan 2007 21:55:58 GMT

Hi Hari,

If both the fields of internal tables are character types then it should be working fine. You can do arithmetic operations also on characters fields. Can you copy paste your code containig internal table declaration aslo.

Ashven

Re: Problem with amounts in Internal Table

Former Member — Mon, 29 Jan 2007 22:10:52 GMT

Because in the first table, the character value is assigned literally ('1110.34'). But as soon as you perform a caclulation with fixed point arithmetic turned off, it treats all numbers as integers.So the results are ijntegers.

Press F1 on the fixed point arithmetic checkbox in the attributes.

And Subramanian is correct. It's best not to do arithmetic on character fields. At best, performance is compromised; at worst, it can dump.

Rob

Message was edited by:

Rob Burbank

Re: Problem with amounts in Internal Table

Former Member — Tue, 30 Jan 2007 01:53:30 GMT

hi hari,

why dont u declare amt fields in both the itabs as type WRBTR

e.g. amt1 type wrbtr.

or you can use currency option to format the amount field in your write statement.

e.g. write itab-amt currency USD.

cheers,

vikram

pls reward for helpful replies!!

Re: Problem with amounts in Internal Table

Former Member — Tue, 30 Jan 2007 04:14:42 GMT

I THINK YOU DINT ASSIGN YOUR AMT FIELD AS

DATA : AMT TYPE P DECIMALS 2.

OR ASSIGN LIKE ANY CURRENCY FIELD.

I THINK YOU ASSIGNED IT AS NUMERIC SO THE PROBLEM IS THERE PLS CORRECT ME IF I AM WRONG.

REGARDS

SHIBA DUTTA

Re: Problem with amounts in Internal Table

Former Member — Tue, 30 Jan 2007 05:01:10 GMT

Hi,

Kinldy check the Check box for Fixed Point arthemetic.

It is availble in the attributes of the program.

REgards

Nagaraju

Re: Problem with amounts in Internal Table

Former Member — Tue, 30 Jan 2007 05:18:46 GMT

Hi,

You try to declare AMT.

Ex.

DATA: amt TYPE i DECIMALS 2

Reward if useful