10-15-2008 12:50 PM
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
10-15-2008 2:38 PM
Check this out. This is handled by SUBQUERY.
http://help.sap.com/saphelp_nw04/helpdata/en/dc/dc7614099b11d295320000e8353423/content.htm
-Aman
10-15-2008 12:58 PM
SORRY Inappropriate reply Pls IGNORE
Edited by: Saravanan Rajan on Oct 15, 2008 1:58 PM
10-15-2008 1:02 PM
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
10-15-2008 2:31 PM
10-15-2008 2:38 PM
Check this out. This is handled by SUBQUERY.
http://help.sap.com/saphelp_nw04/helpdata/en/dc/dc7614099b11d295320000e8353423/content.htm
-Aman