topic Re: select in Application Development and Automation Discussions

select

Former Member — Mon, 21 Apr 2008 11:20:41 GMT

Hi,

Consider the syntax given below.

select lifnr from lfa1 where lifnr =200.

..........

endselect.

suppose if sy-subrc NE 0 then will the loop gets executed atleast once.

Re: select

b_deterd2 — Mon, 21 Apr 2008 11:24:08 GMT

Hi,

No, if there is no LIFNR 200 then the loop will not be entered.

Regards,

bert

Re: select

Former Member — Mon, 21 Apr 2008 11:25:42 GMT

Hi,

If the above condition fails then the loop will not get excecuted .

Reward if Helpfull,

Naresh.

Re: select

prasanth_kasturi — Mon, 21 Apr 2008 11:30:01 GMT

if the condition fails the loop will be skiped

regards

prasanth

Re: select

Former Member — Mon, 21 Apr 2008 11:31:18 GMT

Hi,

If the above condition fails then the loop will not get excecuted .

Reward if Helpfull,

Naresh.

Re: select

Former Member — Mon, 21 Apr 2008 11:31:20 GMT

Hi Frd

No,the LOOP will not execute.because no datas will be in internal table.

Reward Me Point

Pari

Re: select

Former Member — Mon, 21 Apr 2008 11:31:50 GMT

Hi,

If the condition fails loop will never be executed.

Regards.

Re: select

Former Member — Mon, 21 Apr 2008 11:34:04 GMT

hi,

u write select and endselect.. it is loop statement.

The SELECT statement sets sy-subrc to 0 for every pass by value to an ABAP data object. The ENDSELECT statement sets sy-subrc to 0 if at least one row was transferred in the SELECT loop

regards.

chandu.

Re: select

Former Member — Mon, 21 Apr 2008 11:34:25 GMT

IF YOUR SELECT QUERY FAILS THEN SY-SUBRC WILL FAIL SO IT WON'T EXECUTE ONE LOOP ALSO

DIRECTLY IT WILL COME OUT OF THE SELECT - ENDSELECT LOOP