Select not retreiving data

Hello All,

I have a question regarding select statement.

Here is the select code

SELECT belnr

perio

wkgbtr

wogbtr

objnr

gjahr

wrttp

vrgng

parob

parob1

uspob

bukrs

owaer

FROM coep

INTO CORRESPONDING FIELDS OF TABLE gt_coep_recv

WHERE perio IN s_perio

AND gjahr IN s_gjahr

AND bukrs IN s_bukrs

AND kstar LIKE '001124%'

AND objnr LIKE 'LKIRST%'

AND parob LIKE 'LKIRSTP%STCC%'

AND wrttp = '11'

AND vrgng = 'RKL'.

This select return a sy-subrc value of 4 when executed. But when I go the COEP table and try to select data basing on the same conditions, I am able to retrieve data.

Any idea why?

Thanks,

Amy