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

ABAP Open SQL - aggregate functions

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.

replied

Hi

Check the program in se38

demo_select_group_by

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
Not what you were looking for? View more on this topic or Ask a question