topic Re: solvae this issue in Application Development and Automation Discussions

solvae this issue

Former Member — Wed, 09 Aug 2006 09:08:05 GMT

Field too small when calculating totals in internal table.

In the internal table "\PROG=ZSDR003\DATA=TAB[]", a SUM statement is used to

calculate

totals.

However, the values are too large

for the designated field.

The name of the field is "KURSK".

Re: solvae this issue

naimesh_patel — Wed, 09 Aug 2006 09:09:47 GMT

Change the field type as,

data: l_p(32) type p decimals 2.

Regards,

Naimesh

Re: solvae this issue

Former Member — Wed, 09 Aug 2006 09:14:46 GMT

Sukumar,

If the field size doesn`t fit your requirement, change the corresponding field length and retain its property.

Reward points if helpful.

Regards

Re: solvae this issue

Former Member — Wed, 09 Aug 2006 09:22:30 GMT

hi Sukumar,

The only way to solve this is to increase the field size.

For calculating the total if the size is smaller than you have to use the field of same type with somewhat greater lentht.

suppose if it is the case with weight field with properites 13 and 2 decimal. and the size is smaller for your requirement than for totals, you can use similar field with properties 18 and 2 decimals.

Regards,

Richa

Re: solvae this issue

Former Member — Wed, 09 Aug 2006 09:26:43 GMT

Increase the size of the amount fields in that internal table

Re: solvae this issue

Former Member — Wed, 09 Aug 2006 09:29:12 GMT

TOTAL_AMT(16) TYPE P DECIMALS 5,

KURSK LIKE VBKD-KURSK,

this are the datas declared.

i got a error like

price = price * kursk

total_amt = qty * price

i use sum in at the end of statement

at that time it gives the error

Re: solvae this issue

Former Member — Wed, 09 Aug 2006 09:32:13 GMT

Increse the total amount length to 25 and try

TOTAL_AMT<b>(25)</b> TYPE P DECIMALS 5.

Message was edited by: Chandrasekhar Jagarlamudi

Re: solvae this issue

Former Member — Wed, 09 Aug 2006 09:33:28 GMT

increase the length for total_amt to 20.

Secondly, please check if it is due to the total_amt field or other. Because sum would try and sum all the numeric fields.

Regards

Anurag

Re: solvae this issue

Former Member — Wed, 09 Aug 2006 12:39:20 GMT

Hi Sukumar,

the situation is not quite clear for me.

The field KURSK should contain an exchange rate, so do you really intend to sum it? Do you really want to calculate: sum (amount) * sum (exchange rate) ?

At least the average rate is needed, but it's not calculated by the SUM statement.

Before any change consider if the dump is right, did'nt?