Dump in select query

[Former Member]

Hi Experts ,

The following select query creates a dump called time out error, May be this is taking long time to execute . Please tell me how to fine tune this select query?

select v1_{vbeln v2}matnr

v2_{werks v1}fkdat

v1_{knumv v1}fkart

v1_{sfakn v2}posnr

v2_{vgbel v2}ntgew

v2_{gewei v1}land1

v2_{autyp v1}vbtyp

v1~vkorg

v1~vtweg

v1~spart

into table i_billing

from vbrk as v1 inner join

vbrp as v2 on

v1_{vbeln = v2}vbeln

where v1~vbeln in so_vbeln

and v1~vkorg in so_vkorg

and v1~vtweg in so_vtweg

and v1~spart eq p_spart

and v1~fkart in so_fkart

and v1~fkdat in so_fkdat

and v1~vbeln in so_vbeln

and ( v1~vbtyp eq '5'

or v1~vbtyp eq '6'

or v1~vbtyp eq 'M'

or v1~vbtyp eq 'S'

or v1~vbtyp eq 'N'

or v1~vbtyp eq 'O' )

and ( v2~vgtyp eq 'J'

or v2~vgtyp eq 'T' )

• If is a kit o a dis only get positions

and ( ( v2~zzkit eq '' and

v2~zzdis eq '' )

or ( ( v2~zzkit ne '' or

v2~zzdis ne '' ) and

( v2~uepos <> '000000' ) ) ).

Thanks in advance .

[MichalKrawczyk]

hi,

post it on ABAP forum and not on PI forum

Regards,

Michal Krawczyk