topic Re: Issue with SELECT with AFRU table in Application Development and Automation Discussions

Issue with SELECT with AFRU table

Former Member — Thu, 16 Oct 2008 15:12:22 GMT

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

Re: Issue with SELECT with AFRU table

Former Member — Thu, 16 Oct 2008 15:15:22 GMT

i dobut your where condition on budat.

remove that condition and see...

Re: Issue with SELECT with AFRU table

Former Member — Thu, 16 Oct 2008 15:24:28 GMT

Hi,

Before pass the value in select query use the fm CONVERSION_EXIT_ALPHA_INPUT and pass the value pernr and get same value..

loop at itab.

CONVERSION_EXIT_ALPHA_INPUT

input = pernr

output = pernr.

.....

....

endloop.

regds,

Paras

Re: Issue with SELECT with AFRU table

Former Member — Thu, 16 Oct 2008 15:24:31 GMT

Maybe you want to append rather than modify the internal table.

rob

Re: Issue with SELECT with AFRU table

vamshi_mohan — Thu, 16 Oct 2008 15:29:00 GMT

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.

Regards.

Vamshi

Re: Issue with SELECT with AFRU table

Former Member — Thu, 16 Oct 2008 15:47:04 GMT

Look at your values for it_catsf to see if they are missing leading zeroes. SE11 will try to be helpful sometimes and accept values a select statement would miss.