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