Inner join in inline code
SELECT a~MATNR,a~WERKS,b~bmein,b~bmeng,c~idnrk,c~meins,c~menge
FROM mast as a INNER JOIN stko as b on b~stlnr = a~stlnr
and a~stlal = b~stlal INNER JOIN stpo as c on b~stlty = c~stlty and b~stlnr = c~stlnr INTO TABLE @data(gt_mast)
FOR ALL ENTRIES IN @gt_item
WHERE a~matnr eq @gt_item-matnr
and a~werks eq @gt_item-werks.
Comments
Post a Comment