question on EKBE table

[Former Member]

Hi All,

I am able to retrieve the goods receipt data and the invoice receipt data based on the field trans/event type (if 1 then it is goods receipt record, if 2 then it is an invoice receipt record). Actually all I wanted is ENTERED ON date.

Now I have

PO (po number, po line item) -

---

> Goods receipt Info (material no, entered on date). and

PO (po number, po line item) -

---

> Invoice receipt Info (material no, entered on date).

But how can I get the connection like this....

PO info -

---

> Goods receipt info -

---

> Invoice recipt Info

Please let me know if you have any suggestions.

Points are assured.

Thanks in advance...

[Former Member]

Hi,

the invoice is directly connected to the PO/Item (see R3 table RSEG), not to the GR.

Not sure exactly what you need but if you need the "entered date" or any other info about the invoice header, you'll find it in table RBKP.

hope this helps...

Olivier.

[Former Member]

Hi Olivier,

I need the connection between the GR and IR. I do not need any connection between PO and IR directly.

For a single PO line item we can have multiple GR entries and multiple IR entries in EKBE table. All I need is the number of days between the GR entry date and the IR entry date.

So I am just trying to see if there is any field in any of the tables which can provide a connection betwwen GR and IR entries.

[Former Member]

HI,

check once

Good receipt..

MSEG link to EKBE and MKPF tables

a good receipt on the PO is made that update table MKPF,MSEG...

Invoice receipt updating ..BKPF BSAK tables updated

Goods Receipt tcodes .. MIGO/MB1A

Invoice receipt tcodes: MIRO

hope this help

raj

[Former Member]

Hi,

in EKBE you have actually several records:

- one for the GR itself, identified by filed BEWTP = E

- one or several invoices identified by BEWTP = Q or R for the related invoices...

But as I said, there is no direct connection btw GR and invoice except by the key Purchase Order Document number / Item....

It also will depend on the customizing in your system...

hope this helps...

Olivier.

Message was edited by:

Olivier Cora

[Former Member]

Thanks for the replies....

It looks like a configuration issue on the R/3 side. There should be some reference field populated in the EKBE table which should make the connection between GR and IR data.

So Functional guys are looking into it.