Inner Joins with Group by in SELECT

halo,

Is it possible to use GROUP BY addn. in select query which is using INNER JOINs?

i need to get sum of a currency field based on key and non-key fields.

code :

select bd~bukrs

bd~kunnr

bd~umskz

bd~zuonr

bd~gjahr

bd~belnr

bd~buzei

bd~bschl

bd~sgtxt

bd~prctr

kb~akont

bd~zterm

bk~xblnr

bk~hwaer

bd~shkzg

bd~mwskz

bd~dmbtr

bd~wrbtr

bk~waers into table gt_bxxx

from ( bsid as bd inner join

bkpf as bk

on bd_{bukrs = bk}bukrs and

bd_{belnr = bk}belnr and

bd_{gjahr = bk}gjahr )

inner join knb1 as kb

on bd_{kunnr = kb}kunnr and

bd_{bukrs = kb}bukrs

where bd~bukrs in s_bukrs

and bd~gjahr in s_gjahr

and bd~kunnr in s_kunnr

and bd~umskz in s_umskz

and bd~belnr in s_belnr

and bd~prctr = space.

I need to sum up the DMBTR field based on BELNR(key field) and SHKZG(non-key field).Please suggest.

Thank you.

Regards,

Swaminathan.