the table for purchase order and its material documents

[Former Member]

Hi All,

could anyone tell me which table links a certain purchase order to its material documents?

In particular I need to find for each purchase order the

- good receipt MM documet

and the

- invoice recipt MM document.

Thanks.

G.Rossi

[former_member182673]

EKBE is the purchase order history table. You will find both GR and IR related to PO in this table.

Now if you are looking for a direct link between a GR and Invoice you won't get it, but indirectly through a custom program you can get it by reading the sequence of postings.

[former_member186100]

EKBE  and EKBZ are history tables ,value  field VGABE determines whether

1	Goods Receipt
2	Invoice Receipt
3	Subseq. Debit/Credit