Issue with SELECT with AFRU table

Hi All,

I have used below syntax for retrieving data from AFRU table.

loop at it_catsf.

select single ismnw from AFRU

into it_catsf-ismnw

where pernr = it_catsf-pernr

and aufnr = it_catsf-network

and vornr = it_catsf-activity

and budat between p_date1 and p_date2.

modify it_catsf.

endloop.

I am unable to get the data even though data is present in the database table.

If i pass same values in SE11 screen, the data can be viewed...!!!

How to resolve this issue?

Regards

Pavan