Skip to Content
0
Former Member
Jul 30, 2007 at 12:43 PM

TABLE JOIN OF BKPF AND LFA1

2993 Views

I am creating a query and need to join the

Invoice Number (BKPF-BELNER)

Posting Date (BKPF-BUDAT)

Company Number (BKPF-BUKRS)

Supplier Name (LFA1-LIFNR)

Gross Amount (LFA1-WRBTR)

But the BKPF and LFA1 tables does not want to join. Do you know what table I can use to make them join? There must be some link between and invoice and who on the invoice we are paying.

Thanks,

Linda