Skip to Content
author's profile photo
Former Member

Data Mismatch: Plant level stock and Serial Number collection

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Posted on May 03, 2011 at 04:43 PM

    Hi,

    Check table SERI

    Thanks

    Diwakar

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on May 03, 2011 at 06:49 PM

    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

    Add comment
    10|10000 characters needed characters exceeded