Sum statement.

[former_member225631]

Hi Friends,

I have one field in internal table with type p decimals 2. When sum statement is executed, this field causes short dump with the message "he values are too large for the designated field". How to solve this?

Thanks.

[Former Member]

Debugg the report and check which value are actually sum by report. That's the easy option to get rid of such errors.

if sum = sum + value then check what is value data type and which value it contains at runtime.

[Former Member]

Hi,

Increase the size of the packed decimal data type ..Might be the length is less and value is not fitting into it././

rewards if its solved.

regards

nazeer

[Former Member]

Hi,

Increase the size of the variable where you are storing the result of the sum statement.

Also check for its data type.

Reward if useful.

Thanks and regards,

Prerna

[former_member225631]

data:field type p decimals 2.

At last.

sum.

write itab-field.

endat.

I changed to type p decimals 14. Still it goes to short dump when sum statement is executed.

[Former Member]

Give the length.

ex: field(20) type p decimals 2.

[former_member225631]

I tried field(16) type p decimals 2, still it gives short dump.

[Former Member]

HI,

Can you write your code and the dump error?.

regards,

nazeer

[Former Member]

hi,

try with float instead of packed decimals.

reward if useful

ravi

[former_member225631]

"the values are too large for the designated field".

( first i have mentioned.)

[Former Member]

when you are getting the dump by declaring the type p decimals 2 then try to calculate the sum in acharacter field.

data : tot(30).

sort itab by <your itab field(s)>.

loop at itab.

tot = tot + itab-amt.

at end of <your control break field>

write : / tot.

clear tot.

endat.

endloop.

it may fulfill your requirement.

regards

shiba dutta

[former_member225631]

Hi Mr. Shibu it is working fine. Rewarded points. Thanks