Inner join

I need to join MARA and MSEG as inner join on mara-matnr = mseg-matnr.

However matnr is not a key field in mseg.The query is shown below.

from mkpf AS a

inner join mseg as b

on a_{mandt = b}mandt

and a_{mblnr = b}mblnr

and a_{mjahr = b}mjahr

inner join mara as c

on c_{matnr = b}matnr

Is this query alright, specially c_{matnr = b}matnr. Thanks.