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