Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Problem with JOIN statement

Hi All,

Does anyone have an idea on what the JOIN statement does below? This is not an inner join, im not sure if it's an outer join because the join type has not been specified.

Thanks in advance.

SELECT head~mblnr

head~budat

item~matnr

item~menge

item~kunnr

item~werks

FROM ( mkpf AS head JOIN mseg AS item

ON headmblnr = itemmblnr AND

headmjahr = itemmjahr ) JOIN mara AS mat

ON itemmatnr = matmatnr

INTO TABLE t_goods_issue

WHERE head~budat IN r_date AND

item~werks IN lr_werks AND

item~bwart IN s_bwart AND

item~matnr IN s_matnr AND

mat~mtart IN s_mtart.

-AJ

Former Member
Not what you were looking for? View more on this topic or Ask a question