schrizophrenia
13/11/09, 18:22:18
Hola que tal.
Les comento q yo hago la siguiente consyulta, y me trae los datos correctos pero tarda demasiado alguien sabe como podria agilizarla?
gracias!!!
LOOP AT it_aux_bkpf INTO wa_aux_bkpf.
SELECT belnr bukrs gjahr buzei lifnr dmbtr shkzg budat bldat
FROM bsik
APPENDING CORRESPONDING FIELDS OF TABLE it_bsik
WHERE belnr = wa_aux_bkpf-belnr AND
bukrs = p_bukrs AND
gjahr = p_gjahr AND
buzei = '1' AND
lifnr IN s_lifnr AND
hkont IN s_cuenta.
IF sy-subrc <> 0.
SELECT belnr bukrs gjahr buzei lifnr dmbtr shkzg budat bldat
FROM bsak
APPENDING CORRESPONDING FIELDS OF TABLE it_bsak
WHERE belnr = wa_aux_bkpf-belnr AND
bukrs = p_bukrs AND
gjahr = p_gjahr AND
buzei = '1' AND
lifnr IN s_lifnr AND
hkont IN s_cuenta.
ENDIF.
Les comento q yo hago la siguiente consyulta, y me trae los datos correctos pero tarda demasiado alguien sabe como podria agilizarla?
gracias!!!
LOOP AT it_aux_bkpf INTO wa_aux_bkpf.
SELECT belnr bukrs gjahr buzei lifnr dmbtr shkzg budat bldat
FROM bsik
APPENDING CORRESPONDING FIELDS OF TABLE it_bsik
WHERE belnr = wa_aux_bkpf-belnr AND
bukrs = p_bukrs AND
gjahr = p_gjahr AND
buzei = '1' AND
lifnr IN s_lifnr AND
hkont IN s_cuenta.
IF sy-subrc <> 0.
SELECT belnr bukrs gjahr buzei lifnr dmbtr shkzg budat bldat
FROM bsak
APPENDING CORRESPONDING FIELDS OF TABLE it_bsak
WHERE belnr = wa_aux_bkpf-belnr AND
bukrs = p_bukrs AND
gjahr = p_gjahr AND
buzei = '1' AND
lifnr IN s_lifnr AND
hkont IN s_cuenta.
ENDIF.