Hi Experts,
I have selected from 4 different tables.
How to inprove performance for following Loop.
What i have done is right and i should do in another way?
LOOP AT itab.
SELECT SINGLE name1 INTO itab-name1
FROM kna1 WHERE kunnr = itab-kunnr.
SELECT SINGLE ort01 INTO itab-ort01
FROM kna1 WHERE kunnr = itab-kunnr.
SELECT SINGLE bstkd INTO itab-bstkd
FROM vbkd WHERE vbeln = itab-vbeln.
SELECT SINGLE edatu INTO itab-edatu
FROM vbep WHERE vbeln = itab-vbeln.
ENDLOOP.
Yusuf.