[mystic_soul]

Hola gente! como va? necesito la ayuda de ustedes urgente!!
Tengo que darle performance a estos select.. se puede?

Este es uno..

SELECT b~werks c~vkorg c~vtweg a~pkunag a~pkunre a~spmon a~matnr
c~fkart b~pstyv a~fkimg b~wavwr c~waerk b~kzwi3 b~kzwi1
a~sptag b~vbeln b~posnr
INTO TABLE it_s900
FROM s900 AS a
INNER JOIN vbrp AS b
ON a~vbeln = b~vbeln
AND a~posnr = b~posnr
INNER JOIN vbrk AS c
ON b~vbeln = c~vbeln
FOR ALL ENTRIES IN it_ausp
WHERE a~matnr EQ it_ausp-matnr
AND a~pkunag IN s_pkunag
AND a~pkunre IN s_pkunre
AND a~fkart IN s_fkart
AND a~waerk EQ p_waers
AND a~sptag IN s_sptag
AND b~pstyv IN s_pstyv
AND c~vkorg IN s_vkorg
AND c~vtweg IN s_vtweg
AND c~bukrs EQ p_bukrs.

SORT it_s900 BY werks vkorg vtweg pkunag pkunre
spmon matnr fkart pstyv.

*****************
Este es el otro...

SELECT a~matnr a~mfrnr INTO TABLE it_mara
FROM ( mara AS a
INNER JOIN mvke AS b
ON a~matnr = b~matnr )
WHERE a~matnr IN s_matnr " Material
AND a~spart IN s_spart " Sector - Linea de Negocios
AND a~extwg IN s_extwg " Autor
AND a~mfrnr IN s_mfrnr " Editor
AND a~profl IN s_profl " Tema
AND b~mvgr3 IN s_mvgr3 " Sello Editorial
AND b~vkorg IN s_vkorg " Organizacion de Ventas
AND b~vtweg IN s_vtweg. " Canal de distribución

SORT it_mara BY matnr.

Desde ya se los voy a agradecer!!!