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