Issue with SELECT with AFRU table

[Former Member]

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

[Former Member]

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

[Former Member]

i dobut your where condition on budat.

remove that condition and see...

[Former Member]

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

[Former Member]

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

rob

[vamshi_mohan]

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

[Former Member]

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.