topic Re: error while calculating total in alv list in Application Development and Automation Discussions

error while calculating total in alv list

Former Member — Sat, 15 Dec 2007 09:55:13 GMT

hi experts,

I have a an ALV list report with some fields like material no, qty,vendor ,price etc.

when i am trying to use summassion icon for calculating the total of qty.

it is throwing an information message that

" The field Quantity cannot be totalled because of field overflow"

what shall i do for this. why it is happening like this???

regards,

mani

Re: error while calculating total in alv list

Former Member — Sat, 15 Dec 2007 10:25:21 GMT

Hi Mani,

I dont know hw much it is useful to you but i am giving my idea.

Check in your list hw many records or there? and ur saying it is showing error as field overflow may be the total length (no of chacters) size is greater than the actual field length thats why it is showing such kind of error.suppose if your field leng is 13 chacters and after the sum it may increased to 15 chacters thats why it may showing that error.

Try to display only 5-10 records in the alv list and try to do sum and check it is giving the same error or not.

<b>Reward if useful</b>

Regards,

sunil kairam.

Re: error while calculating total in alv list

Former Member — Sat, 15 Dec 2007 13:59:54 GMT

i think it should not go for dump.Please delete the FM from your program and call again,

This is my may work

As i did it many times and please check the field catlog once.

Re: error while calculating total in alv list

Clemenss — Sat, 15 Dec 2007 16:47:27 GMT

Hi manikandan,

you should have related your quantity field to a unit field. This can be done in fieldcatalog or in dictionary structure if you use one for display. Then you have separate sums for each unit key.

The sum of all values will be stored in a field with same technical characteristics as the single value field. So you may declare the quantity field longer. Or sort the tzable by quantities and see one or more too big quantities - Some people love it for testing...

You can filter them and everything is fine.

Regards,

Clemens

Re: error while calculating total in alv list

former_member156446 — Sat, 15 Dec 2007 18:19:28 GMT

colsely look at the field names and the values being based to field catalog...