Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

unicode checking

Former Member
0 Kudos
58

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').

3 REPLIES 3

Former Member
0 Kudos
34

Put into the internal table first .

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

Former Member
0 Kudos
34

Hi Ravi

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

Kind Regards

Eswar

Former Member
0 Kudos
34

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.