ERR IN SELECT

[Former Member]

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 ...."

[nishanthbhandar]

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.

[Former Member]

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