topic Re: Select Distinct Error in Application Development and Automation Discussions

Select Distinct Error

Former Member — Thu, 01 Feb 2007 03:21:06 GMT

I want to retrieve a list of non-duplicate record from table BSEG so i code as below:

DATA: BEGIN OF it_bseg OCCURS 0,

belnr LIKE BSEG-BELNR,

vbund LIKE BSEG-VBUND,

END OF it_bseg.

SELECT DISTINCT BELNR VBUND

APPENDING CORRESPONDING FIELDS OF TABLE it_bseg

FROM BSEG

WHERE KUNNR <> '' OR KUNNR IS NOT NULL

ORDER BY BELNR.

But when i Check the code, it give me an error as below:

" Aggregate functions and the addition DISTINCT are not supported in field lists for pooled and clustered table. "

If i change the code to SELECT DISTINCT * then there is no error.

Why this error happen?

Thank you.

Re: Select Distinct Error

Former Member — Thu, 01 Feb 2007 03:34:58 GMT

as bseg is a cluster table so only you can use distinct * or count( * ) aggregate fn in select clause.

regards

shiba dutta

Re: Select Distinct Error

Former Member — Thu, 01 Feb 2007 03:35:13 GMT

Aaron,

First i would like to know why did you used

APPENDING statement here when there is no ENDSELECT.

Use like below

SELECT DISTINCT BELNR VBUND

into CORESPONDING FIELDS OF TABLE it_bseg

FROM BSEG

WHERE KUNNR <> '' OR KUNNR IS NOT NULL

ORDER BY BELNR.

Now it will work

Pls reward if useful

Re: Select Distinct Error

Former Member — Fri, 02 Feb 2007 01:20:37 GMT

Hi muralikrishna kaipha,

I have tried on your code but it still give me the same error.

How can I check that whether a table is pooled/clustered table or not?

Thankz.

Re: Select Distinct Error

Former Member — Fri, 02 Feb 2007 03:19:17 GMT

in se11 give the name of the table go to display mode it will show you whether it is transp table/cluster/pool table just check before the table name display text will be there.

regards

shiba dutta