Skip to Content
0
Former Member
Mar 24, 2009 at 07:14 AM

Joining VBAK and VBAP

5786 Views

Hi Guys,

Can you pls check the query and suggest best approch to improve the performance as its going for dump.

VBAP as 2,22,34,404

VBAK as 25,54,345

and

r_matnr as 96,000 records.

SELECT vbapmatnr SUM( vbapkwmeng )

FROM vbak INNER JOIN vbap ON vbakvbeln = vbapvbeln

INTO TABLE t_xx

WHERE audat BETWEEN w_pstdat AND w_inidat

AND vkorg IN r_vkorg

AND auart IN r_auart

AND vbap~matnr IN r_matnr

AND vbap~werks EQ p_werks

AND vbap~pstyv IN s_pstyv

GROUP BY vbap~matnr.

Regards,

Srinivas M