Double aggregation using ABAP

[Former Member]

Hi

How to translate such sql code to ABAP code:

Select field_1 count( * ) from

( Select field_1 field_2 ... field_n sum( * )

from table

group by field_1 field_2 ... field_n )

group by field_1.

Regards

Adam

[Former Member]

SORRY Inappropriate reply Pls IGNORE

Edited by: Saravanan Rajan on Oct 15, 2008 1:58 PM

[Former Member]

Hi,

This is concept of derived table of SQL in which result of inner select query is used as a source table by outer select query.

You can use inner select query to fill your internal table and then process your internal table to get the desired output.

Regards,

Vishal

[Former Member]

Hi

Give example how to process internal table.

Regards

Adam

[Former Member]

Check this out. This is handled by SUBQUERY.

http://help.sap.com/saphelp_nw04/helpdata/en/dc/dc7614099b11d295320000e8353423/content.htm

-Aman