Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.


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?



Former Member
Former Member replied

Hi Pavan,

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.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question