topic select and loop in Application Development and Automation Discussions

select and loop

Former Member — Sat, 14 Apr 2007 07:23:48 GMT

hi,

can the select run once and go out to loop statement for the subsequent loop?

wa_tab-vbeln and wa_tab-posnr is unique.

thanks

loop at it_tab into wa_tab.

v_tabix = sy-tabix.

select a~kwmeng

b_{vkorg b}vtweg b_{spart b}vbtyp

into (wa_tab-kwmeng, wa_tab-vkorg,

wa_tab-vtweg, wa_tab-spart, wa_tab-vbtyp)

from vbap as a inner join vbak as b

on a_{vbeln = b}vbeln

where a~vbeln = wa_tab-vbeln and

a~posnr = wa_tab-posnr.

modify it_tab from wa_tab index v_tabix transporting

kwmeng vkorg vtweg spart vbtyp.

endselect.

endloop.

former_member632991 — Sat, 14 Apr 2007 07:33:22 GMT

Hi,

u can put condition if v_tabix = 1 then only that select is executed.