topic Re: select - endselect in Application Development and Automation Discussions

select - endselect

Former Member — Mon, 26 Mar 2007 05:34:34 GMT

Dear all,i have this statment

select * from mkol where matnr eq intab-matnr and lgort in tem.

if.....endif.

endselect.

and it is working fine,but if i use the following statement,then it str8 go to endselect without go thru the if endif block.

select * from mkol where matnr eq intab-matnr and lgort in tem and not lgort in temc and not logrt in tempd.

if....endif.

endselect.

wat has gone wrong? previously i used in other program,it works,but this time it din work...pls help..thanks

Re: select - endselect

Former Member — Mon, 26 Mar 2007 05:37:36 GMT

i think for the 2nd select no data are found so it is not going through the select endselect loop. just check it in debug mode the value of sy-subrc and whether any data is fetching or not?

regards

shiba dutta

Re: select - endselect

Former Member — Mon, 26 Mar 2007 05:39:54 GMT

it din fetch any data,but infact there's one record to be fetched..

Re: select - endselect

Former Member — Mon, 26 Mar 2007 05:46:36 GMT

so it is not oing through the if end if..

just check your where condition..

what are temc tempd are they select-options?

regards

shiba dutta

Re: select - endselect

Former Member — Mon, 26 Mar 2007 05:49:28 GMT

Hi,

check whether ur condition is satisfing ur record or not.

regards,

bharat.

Re: select - endselect

Former Member — Mon, 26 Mar 2007 05:50:56 GMT

this is a thread exactly similar to your case posted yesterday..within select...endselect, if sy-subrc ne 0, it will not chk the conditions as every time, select..endselect begins with sy-subrc 0.

if helpful, reward

Sathish. R

Re: select - endselect

Former Member — Mon, 26 Mar 2007 05:53:47 GMT

dear all,i manage to figure out the problem d..some of the storage location din get hard coded..thanks anyway

Re: select - endselect

Former Member — Mon, 26 Mar 2007 06:01:22 GMT

Joan,

Reason is your select statement returning the SY-SUBRC NE 0.

Try like

select * from mkol where matnr eq intab-matnr

and lgort in tem

and not ( lgort in temc

and logrt in tempd.

if....endif.

endselect.