Skip to Content
0
Former Member
Dec 03, 2011 at 07:56 PM

Select statement Performence issue

224 Views

Hi I am having performence issues with below code and select statement, please help me.

TYPES : BEGIN OF T_EXIDV,

EXIDV TYPE EXIDV,

END OF T_EXIDV.

TYPES : BEGIN OF T_VEKP,

VENUM TYPE VENUM,

EXIDV TYPE EXIDV,

END OF T_VEKP.

DATA : IT_EXIDV TYPE TABLE OF T_EXIDV.

DATA : IT_VEKP TYPE TABLE OF T_VEKP.

*Get all HU's in LQUA table

SELECT LENUM FROM LQUA INTO TABLE IT_EXIDV.

IF SY-SUBRC = 0.

SORT IT_EXIDV BY EXIDV.

*Delete adjacent duplicates

DELETE ADJACENT DUPLICATES FROM IT_EXIDV.

DELETE TABLE IT_EXIDV WITH TABLE KEY EXIDV = ''.

*Get all entries from VEKP table

SELECT VENUM EXIDV FROM VEKP INTO TABLE IT_VEKP

FOR ALL ENTRIES IN IT_EXIDV

WHERE EXIDV = IT_EXIDV-EXIDV.

In above select statement (highlighted in bold) is taking very very long time to get input into table IT_VEKP. Well IT_EXIDV internal table has 200,000 records.

Thanks

SB