Skip to Content
0
Former Member
Dec 07, 2006 at 09:38 PM

Optimising Query on VEPO ?

363 Views

Hi,

I am trying to pick EXIDV2 for all the Items based in a delivery from VEPO based on the VENUM of VEKP.

Venum Is a primary Key in VEPO.

Posting the query that I am using in Infoset.

IF VBBE-VBTYP = 'J'.

CLEAR TRKNUM.

SELECT VEKPVENUM VEKPEXIDV2

FROM VEKP

INTO (VENUM, EXIDV2)

WHERE VEKP~VPOBJ = '01'

AND VEKP~VPOBJKEY = VBBE-VBELN.

IF NOT EXIDV2 IS INITIAL.

SELECT VBELN POSNR

FROM VEPO

INTO (VBELNVEPO,POSNR)

WHERE VENUM = VENUM.

IF VBELNVEPO = VBBE-VBELN AND POSNR = VBBE-POSNR.

TRKNUM = EXIDV2.

EXIT.

ENDIF.

ENDIF.

ENDSELECT.

ENDIF.

It takes a long time.when it goes to vepo which causes to execute the query late.

Regards,

Rama