hi everybody,
How can I improve query performance?
data: begin of lt_itab1,
vkorg like vbak-vkorg,
vtweg like vbak-vtweg,
vbeln like vbak-vbeln,
posnr like vbap-posnr,
matnr like vbap-matnr,
kunnr like vbak-kunnr,
name1 like kna1-name1,
fatmust like vbpa-kunnr,
name2 like kna1-name1,
vgbel like vbak-vgbel,
edatu like vbep-edatu,
aufnr like caufv-aufnr,
fatno like vbrp-vbeln,
atwrt1 like cawn-atwrt,
atwtb1 like cawnt-atwtb,
atwrt2 like cawn-atwrt,
atwtb2 like cawnt-atwtb,
atwrt3 like cawn-atwrt,
atwtb3 like cawnt-atwtb.
data: end of lt_itab1.
data: begin of itab1 occurs 0,
chk type c,
cuobj like vbap-cuobj,
atbez1 like cabnt-atbez,
atinn1 like cabn-atinn,
atnam1 like cabn-atnam,
atbez2 like cabnt-atbez,
atinn2 like cabn-atinn,
atnam2 like cabn-atnam,
atwrt2a like cawn-atwrt,
atbez3 like cabnt-atbez,
atinn3 like cabn-atinn,
atnam3 like cabn-atnam,
atwrt4 like cawn-atwrt,
atwtb4 like cawnt-atwtb.
include structure lt_itab1.
data: end of itab1.
select vbak~vkorg
vbak~vtweg
vbep~vbeln
vbep~posnr
vbak~kunnr
kna1~name1
vbpa~kunnr as fatmust
vbak~vgbel
vbap~matnr
vbep~edatu
vbap~cuobj
vbrp~vbeln as fatno
into corresponding fields of table itab1
from vbak
inner join vbap on vbap~vbeln = vbak~vbeln
inner join vbep on vbep~vbeln = vbap~vbeln
and vbep~posnr = vbap~posnr
inner join kna1 on kna1~kunnr = vbak~kunnr
left outer join vbpa on vbak~vbeln = vbpa~vbeln
and vbpa~posnr = 0
and vbpa~parvw = 'RE'
left outer join vbrp on vbap~vbeln = vbrp~aubel
and vbap~posnr = vbrp~aupos
where vbak~vbeln in p_vbeln
and vbak~kunnr in p_kunnr
and vbak~vbtyp = 'C'
and vbap~posnr in p_posnr
and vbap~abgru eq space
and vbep~edatu in p_edatu.
