Hola,
Es posible, echa un vistazo al siguiente Select...
SELECT mkal~mdv01
blpk~budat
blpk~werks
blpk~matnr
blpk~verid
blpk~pwerk
sum( blpk~menge )
blpk~meinh
INTO tabla l_t_BF
FROM blpk
inner join mkal on blpk matnr = mkal matnr y
blpk werks = mkal werks y
blpk verid = mkal verid
donde mkal~werks = p_werks y
blpk~budat en s_date
agrupado por
mkal~mdv01
blpk~budat
blpk~werks
blpk~matnr
blpk~verid
blpk~pwerk
blpk~meinh.
Espero que ayude.
Praveen