Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

TABLE JOIN OF BKPF AND LFA1

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

Former Member
Not what you were looking for? View more on this topic or Ask a question