este es un inner join con varias tablas!!
SELECT
MARA~MATNR MARA~BISMT MARA~MATKL MARA~MEINS
MARA~MTART MAKT~MAKTX MARC~WERKS MBEW~BWKEY
MBEW~LPLPR MBEW~STPRS MBEW~VERPR MBEW~VPLPR
MBEW~ZPLPR MBEW~PEINH MARC~LOSGR MARA~FERTH
INTO TABLE TI_DATA
FROM MARA
INNER JOIN MAKT
ON MAKT~MATNR = MARA~MATNR
INNER JOIN MARC
ON MARC~MATNR = MAKT~MATNR
INNER JOIN MBEW
ON MBEW~MATNR = MARC~MATNR
AND MBEW~BWKEY = MARC~WERKS
WHERE MARA~MATNR IN S_MATNR
AND MARA~MTART IN S_MTART
AND MAKT~MAKTX IN S_MAKTX
AND MARC~WERKS IN S_WERKS
AND MBEW~STPRS IN S_STPRS
AND MBEW~VERPR IN S_VERPR.
|