topic Re: Error while creating query in Adhoc report in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/error-while-creating-query-in-adhoc-report/m-p/7370081#M1542891 <HTML><HEAD></HEAD><BODY><P>can somebody help on this</P><P></P><P>Regards,</P><P>narasimha</P></BODY></HTML> Wed, 27 Oct 2010 07:00:28 GMT Former Member 2010-10-27T07:00:28Z Error while creating query in Adhoc report https://community.sap.com/t5/application-development-and-automation-discussions/error-while-creating-query-in-adhoc-report/m-p/7370080#M1542890 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>when i am creating query using tables bseg,bkpf and kna1(logical database BRF) and vbrk,i am getting error as "query Specifications cannot be used to generate list" in SQ01.I linked BRF logical database with vbrk by using condition vbrk-vbeln = bkpf-awkey.</P><P></P><P>is my condition is wrong in linking VBRK to BRF logical database.please guide me how to solve this.</P><P></P><P>If my joining is wrong means why i didnt get error in SQ02.??</P><P></P><P>Required fields are:Invoice number(vbrk),invoice category(vbrk),invoice date(vbrk),account document number(bkpf),company code(bkpf),G/L account(bseg),currency(bseg),state(kna1),invoice amount(vbrk).</P><P></P><P>Do i picked fields from wrong tables?/</P><P></P><P>Thanks&amp;Regards,</P><P>narasimha.</P></BODY></HTML> Wed, 27 Oct 2010 05:28:14 GMT https://community.sap.com/t5/application-development-and-automation-discussions/error-while-creating-query-in-adhoc-report/m-p/7370080#M1542890 Former Member 2010-10-27T05:28:14Z Re: Error while creating query in Adhoc report https://community.sap.com/t5/application-development-and-automation-discussions/error-while-creating-query-in-adhoc-report/m-p/7370081#M1542891 <HTML><HEAD></HEAD><BODY><P>can somebody help on this</P><P></P><P>Regards,</P><P>narasimha</P></BODY></HTML> Wed, 27 Oct 2010 07:00:28 GMT https://community.sap.com/t5/application-development-and-automation-discussions/error-while-creating-query-in-adhoc-report/m-p/7370081#M1542891 Former Member 2010-10-27T07:00:28Z