Skip to Content
0
Former Member
Jun 22, 2007 at 02:30 AM

Select - Group by

25 Views

Hello ABAPers,

Im quite confuse in using the <b>group by</b> syntax in Select.. Here is my code, kindly correct what is the problem with this with error msg "The group by addition is not valid for pool or cluster tables".

SELECT bukrs

belnr

gjahr

augcp

bschl

wrbtr

pswsl

sgtxt

hkont

kunnr

FROM bseg

INTO TABLE it_bseg

WHERE bukrs EQ p_bukrs

AND augcp EQ p_augcp

GROUP BY hkont.

Please help..Thanks in advance

aVaDuDz