topic Re: Select - Group by in Application Development and Automation Discussions

Select - Group by

Former Member — Fri, 22 Jun 2007 02:30:31 GMT

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

Re: Select - Group by

jayanthi_jayaraman — Fri, 22 Jun 2007 02:33:13 GMT

Hi,

SInce BSEG is cluster table,you cannot use group by.

Re: Select - Group by

Former Member — Fri, 22 Jun 2007 02:45:09 GMT

HI Jayanthi,

Is there any other tables that I can use to get the following fields?

bukrs belnr gjahr augcp bschl wrbtr pswsl sgtxt hkont kunnr.

Do you have any suggestion how to group by a data in smartforms?

thats why i used groupby in select ...i just think its the solution.

Here is the sample output

currency : USD Bank : HBO

Entry No Document # Customer

1 11188000 Jack Dawson

Please Help

Thanks in advance

aVaDuDz

Re: Select - Group by

former_member194669 — Fri, 22 Jun 2007 02:48:11 GMT

Hi,

check for secondary index tables of BSEG ie BSIS, BSAS, BSID ......

aRs

Re: Select - Group by

jayanthi_jayaraman — Fri, 22 Jun 2007 02:50:20 GMT

Hi,

Use select statement without group by.After that inside loop try using at new hkont.