InfoSet defined incorrectly

[Former Member]

Hi,

We have a query that runs off an InfoSet that returns no data when running the query. Attempting to display data on the underlying InfoSet also returns no records. Attempting to display data on the underlying InfoProviders that make up the InfoSet returns data.

I deduce that the InfoSet (which I did not construct) is defined incorrectly. Please confirm how to tackle the issue of determining where the problem with the InfoSet is.

[Former Member]

Hi keith,

what  are the infoproviders you are using and those join conditions?. In your bex query you have any filters?.Could be that filter characterstick is not available in all  infoproviders of Infoset.

Regards,

Rajesh

[mohd_abdullah]

Hi,

Check whether the join condition is maitained properly or not .

If it is a inner join then a record can only be in the selected result set if there are entries in both joined tables.   

And if it is Left outer join then if there is no corresponding record in the right table, the record is part of the result set (fields belonging to the right table have initial values)

Below url may help

http://help.sap.com/saphelp_erp2004/helpdata/en/f1/713c3b35703079e10000000a114084/content.htm?frames...

Regards .