#1
|
|||
|
|||
Performance en select
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!!! |
Herramientas | Buscar en Tema |
Desplegado | |
|
|