topic Re: Sum statement. in Application Development and Automation Discussions

Sum statement.

former_member225631 — Mon, 30 Apr 2007 07:47:50 GMT

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.

Re: Sum statement.

Former Member — Mon, 30 Apr 2007 07:51:15 GMT

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.

Re: Sum statement.

Former Member — Mon, 30 Apr 2007 07:51:39 GMT

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

Re: Sum statement.

Former Member — Mon, 30 Apr 2007 07:54:10 GMT

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

Re: Sum statement.

former_member225631 — Mon, 30 Apr 2007 07:57:04 GMT

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.

Re: Sum statement.

Former Member — Mon, 30 Apr 2007 07:58:48 GMT

Give the length.

ex: field(20) type p decimals 2.

Re: Sum statement.

former_member225631 — Mon, 30 Apr 2007 08:11:54 GMT

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

Re: Sum statement.

Former Member — Mon, 30 Apr 2007 08:14:06 GMT

HI,

Can you write your code and the dump error?.

regards,

nazeer

Re: Sum statement.

former_member225631 — Mon, 30 Apr 2007 08:21:31 GMT

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

( first i have mentioned.)

Re: Sum statement.

Former Member — Mon, 30 Apr 2007 08:24:29 GMT

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

Re: Sum statement.

Former Member — Mon, 30 Apr 2007 08:25:29 GMT

hi,

try with float instead of packed decimals.

reward if useful

ravi

Re: Sum statement.

former_member225631 — Mon, 30 Apr 2007 09:21:28 GMT

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