I have the below code and i am getting performance issue on below code.
SELECT bukrs belnr gjahr xblnr awkey FROM bkpf INTO
* TABLE it_bkpf FOR ALL ENTRIES IN it_vbrk WHERE xblnr = it_vbrk-xblnr.
TABLE it_bkpf FOR ALL ENTRIES IN it_vbrk
WHERE bukrs = it_vbrk-bukrs AND
XBLNR = it_vbrk-xblnr and
awkey = it_vbrk-awkey.
it is taking 2 min to excecute this code and some times if data is high it is taking much time and going on dump not able to resolve it.