Hi All,
Here is a query using inner join on four tables for which i have to improve performance,
SELECT vbak~vbeln
vbak~auart
vbak~waerk
vbak~vdatu
vbak~vsbed
vbak~bstnk
vbak~kunnr
vbap~posnr
vbap~matnr
vbap~abgru
vbap~prodh
vbap~netwr
vbap~kwmeng
vbap~vrkme
vbap~brgew
vbap~gewei
vbap~werks
vbap~kzwi1
vbap~kzwi2
vbuk~lfgsk
vbpa~kunnr
vbpa~parvw
INTO
(t_collector-vbeln,
t_collector-auart,
t_collector-waerk,
t_collector-vdatu,
t_collector-vsbed,
t_collector-bstnk,
t_collector-kunnr,
t_collector-posnr,
t_collector-matnr,
t_collector-abgru,
t_collector-prodh,
t_collector-netwr,
t_collector-kwmeng,
t_collector-vrkme,
t_collector-brgew,
t_collector-gewei,
t_collector-werks,
t_collector-kzwi1,
t_collector-kzwi2,
t_collector-lfgsk,
t_collector-kunnr_p,
t_collector-parvw)
FROM vbak AS vbak
INNER JOIN vbuk AS vbuk
ON vbakvbeln = vbukvbeln
INNER JOIN vbap AS vbap
ON vbakvbeln = vbapvbeln
INNER JOIN vbpa AS vbpa
ON vbakvbeln = vbpavbeln
WHERE vbak~vbeln IN so_vbeln AND
vbak~erdat IN so_erdat AND
vbak~vbtyp IN so_vbtyp AND
vbak~vkorg IN so_vkorg AND
vbak~vtweg = pa_vtweg AND
vbak~spart = pa_spart AND
vbak~vdatu IN so_vdatu AND
vbak~vsbed IN so_vsbed AND
vbuk~lfgsk IN so_lfgsk AND
vbpa~kunnr IN so_kunnr AND
vbpa~parvw IN so_parvw.
APPEND t_collector.
ENDSELECT.
Please suggest whether i have to use threee different queries with joins or shall go ahead and use first a join and then seect for all entries follwed by looping....
Please tell me briefly how can i proceed to split this query.
Thanks in advance,
Rama.