link between invoice doc and material doc

[former_member565100]

In MSEG we get the material document and in BKPF we get the Invoice document.Now is there alink how could i know for this material document ,this is the invoice posted.

[former_member565100]

resolved.

[Former Member]

Hi,

You can use EKBE table for the above purpose.

In the table EKBE, enter VGABE = 2 (Invoice Receipts) &

enter the material document no. in LFBNR (Document No. of a Reference Document)

material document item no. in LFPOS (Item of a reference document) &

fiscal year in LFGJA (Fiscal year of a reference document).

Now when you will execute, you will get Invoice document no. in the field BELNR.

Hope this answers your question.

[former_member565100]

If a material doc number is given , i want to know what is the invoice posted for this material doc from a table.

EKBE doesnt give me invoice number if i input mdoc number

[Former Member]

do you enter invoice item based on PO or the mat. document?

[former_member565100]

Thank you all.As m,entioned i have taken Invoice base don PO item number.Resolved.

[Former Member]

An example - PO# 1404011105 and Line item# 1. We have Material doc# 5001121396 in MSEG and accounting document for invoice 5102088564 in BKPF

In MSEG for MBLNR = 5001121396, you will get EBELN - 1404011105 and EBELP = 1

In BSEG for BELNR = 5102088564 for the entry pertaining to GR/IR account (HKONT), you will get EBELN - 1404011105 and EBELP = 1

There is the link attached between PO and POLI#

Regards

Sachin

[Former Member]

Hi

In EKBE table, For the PO and line item, you get both GR(PO history cat. as E) and IR (PO history cat. as Q, R etc) details.You have to match the corresponding GR and IR by the quantity,posting date and price which is present in this table.

Thanks,

Vasanthan

[esther_hernanz]

Hi!

When you create your Purchase Order item, flag the GR-based IV indicator (EKPO-WEBRE). This way you will create a link between your goods receipt and the respective invoice. You will be able to see this link in ME23 or ME23N, in the PO item history, with the view 'GR/IR assignment'.

I hope this helps!

Esther.

[former_member197616]

Hi,

the table MSEG will give the material document number and BESG gives you the accounting document generated.Link between these two is PO.Please check if this suffies your requirement.

[Former Member]

Hi

Goto Tcode SE16

Enter table name EKBE

Execute.

It will show the material document and accounting document against PO.

Check it out.

Regards,

Raman

[former_member581212]

hi,

check RSEG, BSAK, BSIG tables...

Also check BKPF -accounting document header...

Hope it solves your query..

Regards

Priyanka.P