select - endselect

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

check whether ur condition is satisfing ur record or not.

regards,

bharat.

[Former Member]

hi

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

[Former Member]

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

[Former Member]

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.