inner join and sum menge (mseg,mkpf)

hi,

select mseg~mblnr mseg~mjahr sum( mseg~menge ) mkpf~budat from mseg inner join mkpf
  ON mseg~MBLNR EQ mkpf~MBLNR and mseg~MJAHR EQ mkpf~MJAHR into corresponding
  fields of table it_mseg1 where matnr eq it_final-idnrk
                             and lifnr in s_lifnr and werks in s_werks
                             and budat in s_budat group by mkpf~mjahr.

The above query is not working.

suggest some ideas.

with regards,

Bathri..