Error while creating query in Adhoc report

[Former Member]

Hi Experts,

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.

is my condition is wrong in linking VBRK to BRF logical database.please guide me how to solve this.

If my joining is wrong means why i didnt get error in SQ02.??

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).

Do i picked fields from wrong tables?/

Thanks&Regards,

narasimha.

[Former Member]

can somebody help on this

Regards,

narasimha