Check Inner join

Can you please check below select statement because there are double records reasoning somethings . Shall I need to change order of joins ?

SELECT mara_{matnr mara}prdha marc_{maabc mara}meins

makt_{maktx marc}trame mard~labst

mbew_{stprs mbew}peinh

INTO CORRESPONDING FIELDS OF gt_mara_itab

FROM mara

INNER JOIN makt

ON makt_{matnr = mara}matnr

AND makt~spras = sy-langu

INNER JOIN marc

ON marc_{matnr = mara}matnr

INNER JOIN mard

ON mard_{matnr = mara}matnr

AND mard_{werks = marc}werks

LEFT OUTER JOIN mbew

ON mbew_{matnr = marc}matnr

AND mbew_{bwkey = marc}werks.

WHERE mara~matnr IN smal_tab

AND mara~mtart IN s_mtart

AND mara~matkl IN s_matkl

AND marc~werks IN s_pplant

AND mard~lgort NOT IN gr_lgort

AND mara~lvorm = space

AND marc~lvorm = space

AND mard~lvorm = space.