Issue with SELECT with AFRU table
I have used below syntax for retrieving data from AFRU table.
loop at it_catsf.
select single ismnw from AFRU
where pernr = it_catsf-pernr
and aufnr = it_catsf-network
and vornr = it_catsf-activity
and budat between p_date1 and p_date2.
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?
Just debug and see if the p_date1 and p_date2 are of similar TYPE to budat and also that the date value should be in the same way. i.e., if budat is of type sy-datum, then the input should be of form yyyymmdd. If it they mismatch, use CONVERSION_EXIT_ALPHA_INPUT.
Just let me know if the issue is resolved and how.