Table Join

[Former Member]

I am trying to do a report using a table join however i am notable to find a table with both Document Number (FI) and Purchase Order number . I checked table EKKO but the document number column in that table is blank.

Can anyone tell me where i can find the table with that link between FI and MM

I need to find document number (FI) and purchase order in the same table

[iklovski]

Hi,

What do you mean by 'FI document'? PO as itself does not create any FI documents. Or do you mean GRs of this PO? In this case, in BSEG, you will normally have a reference in EBELN field.

Regards,

Eli

[Former Member]

The FI document number i am referring to is when a document is parked it generates a document number which will be unique.

I when into table BSEG but the purchasing document column is blank .

I am trying to find the link between the FI document and the corresponding goods receipt in the Puchase Order

[iklovski]

This field (EBELN) should be filled automatically for FI doucments created by GR logistic documents.