Skip to Content
Former Member
May 08, 2007 at 07:29 AM

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 amandt = bmandt

and amblnr = bmblnr

and amjahr = bmjahr

inner join mara as c

on cmatnr = bmatnr

Is this query alright, specially cmatnr = bmatnr. Thanks.