Report for Reconciliation of serial number -Need Table help

[Former Member]

Hi all,

I am working on Report to get info on "Reconciliation of serial number"

The business flow is as below: (Transaction MIGO)

1. Receipt of Gas Cylinder u2013 (Mvt type 501M)

2. Transfer Cylinder to Production dept.- (Mvt type 311M)

3. Transfer empty Cylinder to Empty storage location after utilization u2013 (Mvt type 312M)

4. Empty Cylinder return to Vendor u2013 (Mvt type 502M)

I want to know No. of days between step 1. Gas Cylinder receipt (Mvt 501M) and step 4. Return of empty Cylinder to Vendor (Mvt 502M) based on selection --> Material, Serial No, Vendor, Plant

I have analyzed few Tables:

1. MKPF -> (Material movement Dates)

2. MSEG -> (Plant, Storage location)

3. EQUI -> (Equipment, Material and Serial Number link)

But unable to find out link between MSEG and EQUI.... Can you please help me to find out link?

(P.S.: I have checked IQ09 transaction as well but not getting required information.)

[Former Member · Accepted solution]

Hello

Look on the tables OBJK and SER03 . Here you should have the link to EQUI via field OBJK-OBKNR, OBJK-EQUNR and MSEG via fields SER03-OBKNR, SER03-MBLNR, SER03-MJAHR, SER03-ZEILE

Edited by: Piotr Dudzik on May 25, 2010 4:58 PM

[Former Member · Accepted solution]

Hi Dudzik,

Thanks a lot.