Skip to Content

Stock in MCHB Table, Not in MMBE

Hello experts,

As observed for material with certain batch stock in lying in QA location in table MCBH,but it cannot seen in MMBE.

when I am tracing for that i have found that it has been dispatched some months ago.

but still showing entry in MCHB table. I have configured one Z report based on MCHB table so it is giving wrong ouputs.

Please give your opinions about this inconsistency in stock update.

Regards

Lalit Pawar

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Jun 28, 2016 at 09:19 AM

    I would put this z-report to side and would first analyze if the stock can be seen in MB52, if the movement in MB51 are consistent and whether the the stock visible in MCHB is correct or wrong if you recalculate the movements for this batch.

    Maybe it is a bug in MMBE which need to be fixed instead of anything in the Z-report.

    I can't really believe that there will be a MCHB record with stock (of course there will be a MCHB record with zero stock until you archive the record) if the goods issue for the complete quantity was done.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 28, 2016 at 08:49 AM

    Hi Lalit,

    Please check whether your Z report considers and filters accordingly to the Current Period (MCHB-LFMON) . The entries in table MCHB will be by fiscal year and current period.

    MMBE shows the realtime stock quantity however i suspect the customised report does not filter by current period.

    Please check and revert.

    Thanks

    Karthik

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Karthik,

      thanks for reply

      The z report does not consider and filter according to current period.

      But i checked in MCHB table for field MCHB-LFMON it is showing same stock value for current period,

      so whether it will work by giving filter according to current period in Z report.

      Regards

      Lalit Pawar

  • Posted on Jun 29, 2016 at 05:34 AM

    Hi,

    In the end i wants to remove stock from MCHB-CVMIN.

    how to achive this note that this stock is not displayed in MMBE.

    Regards

    Lalit

    Add a comment
    10|10000 characters needed characters exceeded

    • Be patient 😉 and wait 2 days, then we have July and the current period becomes previous period and you shouldn't have any issue.

      I won't give any other recommendation without having done a diligent analysis of the case, to know whether it is a real inconsistency (then you should actually open a ticket at SAP Support) or if it was just a handling error. It is not even known if you use the quality module and usage decisions, so any advise out of the blue can make things worse.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.