06-04-2006 1:22 PM
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 ...."
06-04-2006 1:32 PM
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.
06-04-2006 1:32 PM
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.
06-04-2006 1:38 PM
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