Skip to Content
Former Member
May 25, 2010 at 01:38 PM

Report for Reconciliation of serial number -Need Table help


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.)