Skip to Content
0
Former Member
Apr 09, 2013 at 05:56 PM

performance query

61 Views

Hi folks

I have the below code and i am getting performance issue on below code.

Please suggest

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.

Please suggest.

Regards

Ravi

Attachments