unicode checking

[Former Member]

Iam checking for unicode compatability ......... iam getting

"Aggregate functions and the addition DISTINCT are not supported in field lists on pooled and cluster tables " error for below select command ........... how can i resolve this

SELECT DISTINCT vbelv posnv INTO CORRESPONDING FIELDS OF TABLE it_vbfa

FROM vbfa

WHERE erdat EQ gv_datum

AND vbtyp_v IN ('C', 'I')

AND bwart IN ('Y21', 'Y22').

[Former Member]

Put into the internal table first .

under the loop, you can filter the desired data as per matching the conditions.

[Former Member]

Hi Ravi

No errors found when checked on my system(UNICODE) for given statement.

Kind Regards

Eswar

[Former Member]

VBFA is tansporant table. ( VBFA is not Pooled/ clusted Table)

in my system for this select query we are not getting the unicode error.

this problem you may get for some other selects.

Check once again

thanks

Sekhar.