Skip to Content
0
Former Member
Jul 17, 2006 at 10:04 AM

slow query

17 Views

Hi,

I have a problem in a query given below , can somebody help me how to optimize the below query so that that could be selected fast as it is giving time-out abap dump

SELECT

a~vbeln

b~posnr

b~matnr

a~vkorg

a~vtweg

a~spart

a~erdat

a~ernam

a~kunnr

a~ctlpc

a~auart

a~kkber

a~sbgrp

b~zzdpdat

b~yywi17

b~kwmeng

b~kzwi1

b~yywi21

b~abgru

b~zzmfrpn

b~zzeddat

FROM vbak AS a INNER JOIN vbap AS b ON avbeln = bvbeln

into TABLE i_vbak_vbap

WHERE a~vbeln IN s_vbeln

AND a~vkorg IN s_vkorg

AND a~vtweg IN s_vtweg

AND a~spart IN s_spart

AND a~auart IN s_auart

AND a~erdat IN s_erdat

AND a~ernam IN s_ernam

AND a~kunnr IN s_kunnr.

thanks in advance