Table containing link between material document and serial number.

[Former Member]

Hello.

In connection with a goods receipt for purchase order in transaction MIGO a material that is serial number controlled is being recevied. The transaction allows the user to seach and use a serial number. The user then posts the goods receipt for the purchase order and a material document is created (entry in table MSEG).

With this entry in MSEG as a starting point, I have to find the serial number that the user selected when posting the goods receipt. I have been looking in thse tables EKPO, RESB, RSDBS, AFPO, EBAN, RKPF, MSEG and MKPF, but none of them has the serial number used. Would anyone be of assistance.

Thank you very much.

[Former Member · Accepted solution]

Hi,

2 options:

1. Use tables: MSEG, SER03, OBJK.

Links:

- MSEG & SER03 to read the object number

MSEG-MBLNR = SER03-MBLNR + MSEG-MJAHR = SER03-MJAHR + MSEG-ZEILE = SER03-ZEILE

- SER03 & OBJK to read the serial number

Read OBKNR from SER03 with the above link & pass the same to OBJK table here you can get the serial number (OBJK-SERNR)

2. Use FM - GET_SERNOS_OF_DOCUMENT

Regards,

Vivek

[Former Member · Accepted solution]

Thanks. The function module works just perfectly.

[Former Member · Accepted solution]

This message was moderated.