Query issue

[Former Member]

I have a query and it works great. However, when I total a column in the ALV (after the Query is executed) it gives me an overflow error. How can I correct this issue?

Regards,

Davis

Edited by: Davis on Oct 20, 2008 6:23 PM

[Former Member]

Try changing the output length of the field you are summing up and it must work.

[Former Member]

I tried that and it didn't work. I changed it from 6 to 30; I would suspect that 30 would be plenty big.

Any other ideas?

Regards,

Davis

[Former Member]

I am just hoping that somebody has an idea.

Thanks,

Davis

[former_member194669]

Is any character values in the column?

a®

[former_member598013]

Hi Davis,

check out the field declaration. this might cause you a problem.

Thanks,

Chidanand

[Former Member]

This does cause the problem; I need to change it somehow. The issue is that the field is p0007-wostd. It is the number of hours worked (output length of 6 with decimals). When you try to total this column the value will sometimes (most of the time) be larger than 6 thus the overflow. I need to avoid this overflow issue by increasing the output length somehow.

I tried manually increasing it in the Basic List screen (on the left hand side) but that didn't help.

Thanks,

Davis