Hola de nuevo, yo tambien te dejo uno con varias tablas .... ahi hay algo nuevo como una especie de etiqueta que se le coloca a una tabla .... mara AS a, afko AS b .... a y b harian el papel de mara y afko respectivamente para este ejem.
SELECT b~aufnr b~rsnum b~werks d~lgort a~rspos
a~matnr a~charg a~bdmng a~meins e~lgpla AS lgpla_d
INTO CORRESPONDING FIELDS OF TABLE gt_aufnr
FROM resb AS a INNER JOIN caufv AS b ON a~rsnum = b~rsnum
AND a~aufnr = b~aufnr
INNER JOIN rkpf AS c ON a~rsnum = c~rsnum
INNER JOIN afpo AS d ON a~aufnr = d~aufnr
INNER JOIN mlgt AS e ON a~matnr = e~matnr
INNER JOIN mara AS f ON a~matnr = f~matnr
WHERE b~aufnr IN s_aufnr
AND b~auart IN s_auart
AND b~gstrs IN s_gstrs
AND b~werks IN s_werks
AND d~lgort EQ p_lgort
AND d~posnr EQ c_posnr
AND a~kzear EQ space
AND a~charg NE space
AND a~bdmng NE space
AND e~lgnum EQ c_lgnum
AND e~lgtyp EQ c_100
AND f~mtart IN ('CONC','MPCL','BULK').
Espero tambien te sirva ...
