topic Re: Query issue in Application Development and Automation Discussions

Query issue

Former Member — Mon, 20 Oct 2008 22:23:47 GMT

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

Re: Query issue

Former Member — Mon, 20 Oct 2008 22:46:04 GMT

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

Re: Query issue

Former Member — Mon, 20 Oct 2008 23:26:30 GMT

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

Re: Query issue

Former Member — Tue, 21 Oct 2008 16:19:32 GMT

I am just hoping that somebody has an idea.

Thanks,

Davis

Re: Query issue

Former Member — Tue, 21 Oct 2008 16:23:12 GMT

Hi Davis,

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

Thanks,

Chidanand

Re: Query issue

former_member194669 — Tue, 21 Oct 2008 16:24:03 GMT

Is any character values in the column?

a®

Re: Query issue

Former Member — Tue, 21 Oct 2008 16:37:26 GMT

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