topic ERR IN SELECT in Application Development and Automation Discussions

ERR IN SELECT

Former Member — Sun, 04 Jun 2006 12:22:17 GMT

select SUM( KAWRT )

from konv

INTO Z_KAWRT

where knumv = Z_KNUMV

and kschl = Z_KSCHL.

I GET ERR T "AGGREGATE...THE ADDITION distinct ARE NOT SUPPORTED ...."

Re: ERR IN SELECT

nishanthbhandar — Sun, 04 Jun 2006 12:32:12 GMT

KONV is a cluster table and so u cannot use the addition SUM ( fieldname ) with this table. That is why u r getting the error message.If the purpose of your select is to sum up KAWRT then select the required records into an internal table and add them up.

Re: ERR IN SELECT

Former Member — Sun, 04 Jun 2006 12:38:43 GMT

hi Liat tal,

please use this query.

select SUM( KAWRT )

INTO Z_KAWRT

from konv

where knumv = Z_KNUMV

and kschl = Z_KSCHL.

hope this help you.

~John