select and loop

[Former Member]

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]

Hi,

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

like

loop at it_tab into wa_tab.

v_tabix = sy-tabix.

<b>if v_tabix = 1.</b>

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.

<b>endif.</b>

endloop.

Regards,

Sonika

[former_member632991]

Hi,

if ur problem is solved nad thread is closed, then reward points for solved problem and not helpful answer.

Regards,

Sonika