how to get inbound delivery number according to materail document number

[Former Member]

Our business scenario:

1) ME21N, to create NB purchasing document

2) VL31N, to create inbound delivery based on NB purchasing document

3) MIGO, to receive the material to storage location based on inbound delivery, then materail document number will be generaated.

My question is that how shall I find the original inbound delivery based on the materail document number? Thanks very much.

King qi

2008-08-21

[former_member614205 · Accepted solution]

Go to EKBE table for GR document and get the field ETENS (Sequential number of vendor confirmation).

Go to EKES table and select the record based on EBELN, EBELP and ETENS to get the corresponding delivery number

[Former Member]

There is no direct report where you can get inbound delivery number according to material document.

You have join table using SAP query.Use MSEG & LIPS with common field of purchase order / item number EBELN/EBELP

to create SAP query.

Let me know this solution works...Sanjay

[Former Member]

Hi,

PO is the reference for this right.

You have confirmations tab on which inbound delivery number is there for LA and then Purchase order history tab with the GR no. ( material document no)

Best regards,

Sridhar

[Former Member]

Sridhar,

Yes, you can find inbound delivery in confirmation tab, and GR material document in PO history, but still can not find the matching relattionship between inbound delivery and GR material document.

For example

PO inbound delivery/qty GR material document/qty

450000690 6900001/100 5000001/40

6900001/100 5000004/60

6900003/80 5000008/70

this is my simulation for the matching relattionship between inbound delivery and GR material document.

in fact, this will be more complex in real world, my question is to get the original inbound delivery based on the GR materail document number.

thanks.

[pankaj_singh9]

Hi,

You can use following Tables and join to get data;

EKES - Vendor Confirmations (PO No & IBD No)

EKBE - History per Purchasing Document (PO No & GR No)

Otherwise you can get Inbound Delivery No from "Reference" field (MKPF-XBLNR) for a Goods Receipt from MKPF Table. And then get PO No for GR No from MSEG Table. Join MSEG and MKPF Tables to get details.

[Former Member]

Use the same range for Inbound Delivery and Material Document , use VN01 & OMW9 for Inbound and material document , be careful to star P.O and Inbound Delivery at the same number and time.

[Former Member]

go to MSEG table usign se16 and enter your mateiral document number

here you will find the delivery number

[Former Member]

Charlie

I have tried this table before, there is no inbound delivery document number. Please double confrim it. thanks.

[former_member182489]

go to FB03 , give the mat doc number and enter , u will get the inbound delivery number

award