10-17-2007 9:37 AM
Hi all,
I have this statement:
SELECT SINGLE RUECK MAX( RMZHL ) BUDAT STZHL
INTO K_CONFIRM
FROM AFRU
WHERE AUFNR EQ P_ORDER
AND VORNR EQ P_OPER
GROUP BY RUECK RMZHL BUDAT STZHL.
My requirement is I need to use a work area (not an internal table) and ENDSELECT is not allowed. The result is not selecting the Maximum RMZHL, it will always return the first record.
How can I correctly do this in OO? Thanks in advanc.e
10-17-2007 9:42 AM
If you use GROUP BY in your query then the set functions (MAX,SUM, Count) not possible...
refer:
http://help.sap.com/saphelp_nw70/helpdata/en/be/c7fe3f70cac342e10000000a1550b0/frameset.htm
10-17-2007 10:02 AM