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