TIME_OUT Select con inner join

[enrique_a]

Esta select tiene como parametros de entrada
codigo de material y sociedad.
En desarrolo funciono bien pero en productivo
se callo por TIME_OUT

ojala me puedan ayudar.

SELECT MBEW~BWKEY MBEW~BWTAR MBEW~MATNR MBEW~SALK3 MCHA~BWTAR
MCHA~CHARG MCHA~MATNR MCHA~WERKS T001K~BWKEY T001K~BUKRS
MCHB~CHARG MCHB~CLABS MCHB~LGORT MCHB~MATNR MCHB~WERKS
T001W~BWKEY T001W~WERKS
INTO CORRESPONDING FIELDS OF TABLE ti_mbew
FROM ( MBEW
INNER JOIN MCHA
ON MCHA~BWTAR = MBEW~BWTAR
AND MCHA~MATNR = MBEW~MATNR
INNER JOIN T001K
ON T001K~BWKEY = MBEW~BWKEY
INNER JOIN MCHB
ON MCHB~CHARG = MCHA~CHARG
AND MCHB~MATNR = MCHA~MATNR
AND MCHB~WERKS = MCHA~WERKS
INNER JOIN T001W
ON T001W~WERKS = MCHB~WERKS
AND T001W~BWKEY = T001K~BWKEY )
WHERE MCHB~MATNR IN t_matnr
AND T001K~BUKRS IN t_bukrs.