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