10 Replies Latest reply: Sep 3, 2009 3:49 PM by Rob Burbank RSS

ABAP Open SQL - aggregate functions

kevin hatch
Currently Being Moderated

Hi,

 

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:

 

http://it.toolbox.com/blogs/sap-on-db2/abap-open-sql-limitations-31495

 

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.

 

Thanks.

Actions