query problem

hi folks,

I have an issue related to this query for quite sometime and tried to find what the problem is?

Can anyone help me understand what am I missing

data: begin of itab1 occurs 0,

employee(8) type n,

reason_type(2),

reason_code(2),

return_date like sy-datum,

end of itab1.

data: it_0019 like pa0019 occurs 0 with header line.

select single * from pa0019 into it_0019 where

pernr = itab1-employee and tmart ='z9' and termn = '20050707'

if sy-subrc = 0.

move-corresponding it_0019 to wa_0019.

endif.

I am getting -sy-subrc = 4 and I do see a record in the table for this.

I am not able to understand why it is returning the value as '4'.

It is avery simple query but giving a hard time.

Thanks in advance, would really appreciate it.

SK