cancel
Showing results for 
Search instead for 
Did you mean: 

error while creating query in Adhoc report

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Posted in wrong forum