Skip to Content
0
Former Member
Dec 04, 2009 at 06:23 AM

Inner joins on the tables VAKPA , VBAP and KNA1

220 Views

HI ,

I have one performance issue.please see the below select query..In order to improve the performance i need to change this select query with out changing the functionality.Can any one of you please suggest me .

SELECT vakpakunde vakpaparvw kna1kunnr kna1name1 kna1~ktokd

vbapvbeln vbapposnr vbaparktx vbapzzclass

vbapmvgr2 vbapmvgr3 vbapmvgr5 vbapzzcanvas_year

vbapmatnr vbapmatkl

FROM vakpa

INNER JOIN vbap ON

vakpavbeln = vbapvbeln

INNER JOIN kna1 ON

vakpakunnr = kna1kunnr

INTO CORRESPONDING FIELDS OF TABLE gt_vbap

WHERE vakpa~kunde IN so_kunnr

AND vakpa~parvw = 'AG'

AND vakpa~vkorg IN so_vkorg

AND ( vbap~zzad_line_status = 'PR' OR

vbap~zzad_line_status = 'RE' )

AND vbap~mvgr5 IN r_ctf

AND vbap~matkl IN so_matkl

AND vbap~matnr IN so_matnr

AND vbap~zzcanvas_year IN so_year.

ENDIF.