Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

MIN function not working against virtual table

Hi folks,

When querying a very simple SQL from dev server to prod server via a virtual table it seems the MIN function is not working.  Are there limits to what functions can be used via virtual table or could it be due to the fact that our dev is rev 82 and our prod is rev 68?  For example the following should return a valid date (ie: in this case 20140803)

select ebeln, ebelp, min(eindt) from "VIRTUAL_REMOTE_SCHEMA"."VIRTUAL_TABLE_EKET"

                               where ebeln = '123456789'

                               group by ebeln, ebelp

Instead of a valid date (20140803) it returns the number 20.  Yet if I run this same exact SQL directly in the production server it returns the correct valid date 20140803.  Or if I remove the MIN function completely I get a list of 18 different dates for this same EBELN, EBELP purchase order and indeed I see the date 20140803 in the list.

Thanks,

-Patrick

Tags:
Not what you were looking for? View more on this topic or Ask a question