Data Mismatch: Plant level stock and Serial Number collection

[Former Member]

Hi,

I am working with stock in SM.

I want the plant level stock and the serial number collection for the serialised material. The value coming for the plant stock is 20 (Eg. MATNR = 50004050) and the corresponding serial number collection is 27. But the values in plant stock and in the serial number collection should be one and the same.

For getting the plant stock I'm using the MARA and MARC table. For getting the serial number collection I'm using EQUI and EQBS table.

When I increase the stock using the transaction MB1C and movement type 561, I'm giving the serial numbers for the material. The issued serial numbers are coming in the serial number collection correctly but the stock at the plant level is not getting updated properly. Please let me know from where I can get same stock.

Thanks in Advance,

Mohan

[Former Member]

This could happen, if the status of serial number is wrongly updated to ESTO. From where are you taking serial numbers?Physically what is right the qty showing plant stock or the qty showing serial number? May be you go and check the history of the serial number to see if it is really available in stock.

Also it can be serial number is optional so though the stock is reduced but serial number is not captured while issuing so the stock at plant level is less but serial number is more,

If this is the case, reconciallation directly from tables will be difficult.

Regards

Sangeeta

Edited by: Sangeeta Khurana on May 4, 2011 12:34 AM

[former_member218067]

Hi,

Check table SERI

Thanks

Diwakar