topic Re: Error in sap query in Application Development and Automation Discussions

Error in sap query

Former Member — Wed, 14 Oct 2009 11:59:27 GMT

Dear Experts ,

I have a query and executing using SQ01 . Here im getting warnings as

The query specifications cannot be used to generate a list, i.e. the query will probably not return the list you desire.

If you still want to execute the query, please use the "Generate" function . -> 'Generate'

Here im not getitng the output i require . then the system says ** Fields from parallel tables within a line Line: 02

Field: Account number of supplier or vendor (LFB1-LIFNR, table LFB1) ;

Field: Account number of supplier or vendor (LFBK-LIFNR, table LFBK)

Same thing comes for Bank country key, bank key , bank account number .

Please heklp as to what is wrong

GauthamV — Wed, 14 Oct 2009 12:03:27 GMT

Did you generate the infoset of your query in SQ02 transaction ?

Former Member — Wed, 14 Oct 2009 12:06:43 GMT

see.. the info set might be changed after the query is designed...

so check in the query, if the fields matches with the fields in infoset..

Former Member — Fri, 08 Oct 2010 13:09:26 GMT

Hello,

I am gettig the Same Error in SAP Query, But i have generated My Infosets & cross checked the Fields with Query.

Plz let me know what could be the Error.

Thanks.