Skip to Content
0
Former Member
Apr 20, 2009 at 05:48 AM

inner join and sum menge (mseg,mkpf)

89 Views

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..