topic Re: unicode checking in Application Development and Automation Discussions

unicode checking

Former Member — Thu, 23 Nov 2006 06:15:14 GMT

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

Re: unicode checking

Former Member — Thu, 23 Nov 2006 06:18:24 GMT

Put into the internal table first .

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

Re: unicode checking

Former Member — Thu, 23 Nov 2006 06:23:30 GMT

Hi Ravi

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

Kind Regards

Eswar

Re: unicode checking

Former Member — Thu, 23 Nov 2006 06:29:02 GMT

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.