topic Double aggregation using ABAP in Application Development and Automation Discussions

Double aggregation using ABAP

Former Member — Wed, 15 Oct 2008 11:50:26 GMT

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 — Wed, 15 Oct 2008 11:58:14 GMT

SORRY Inappropriate reply Pls IGNORE

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

Former Member — Wed, 15 Oct 2008 12:02:53 GMT

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 — Wed, 15 Oct 2008 13:31:32 GMT

Give example how to process internal table.

Regards

Adam

Former Member — Wed, 15 Oct 2008 13:38:22 GMT

Check this out. This is handled by SUBQUERY.

-Aman