Skip to Content
0
Former Member
Dec 31, 2007 at 12:43 PM

Select Single Performance......

47 Views

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.