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

it works

Edited by: Sonal Patel on Sep 3, 2009 6:34 PM

1 View this answer in context