ABAP Open SQL - aggregate functions
Does ABAP Open SQL support aggregate functions? (e.g. SUM, AVG)
When you hit F1 on "select", the ABAP Keyword Documentation opens up. Under "Open SQL" in the documentation is information on "SELECT - aggregate". So the SAP Keyword Documentation states that aggregate functions are possible in Open SQL.
But this guy (who seems amply qualified) says that open SQL in ABAP does not support aggregate functions such as sum:
Who is right? If ABAP does support aggregate functions, can I have a complete select statement using SUM and GROUP BY as an example?
I have written a select statement using SUM and GROUP BY but the resulting internal table is empty.
Check the program in se38
Try with SUM or AVG instead of MIN or MAX in that code
Edited by: Sonal Patel on Sep 3, 2009 6:34 PM