Skip to Content

Material Valuation - MBEW & MBEWH

Hi!

I want to reconcile the inventory value per closing of 2019-04-30.
I have the tables MBEW, MBHEW, MARA & MAKT (extracted 2019-05-30).

I know that MBEW is the inventory value per 2019-05-30 (date of extraction) and for MBEWH I can get the history of the valuation.

The problem is that I want to reconcile with the inventory value on the balance sheet for 2019-04-30, how can I do this? Since the MBHEW doesn't take notice of scrapped articles etc. if I take the latest valuation of all articles. Is there any way to do this?

Thanks in advance!

Victor

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jun 12, 2019 at 07:57 AM

    I solved it myself.

    By first extracting all rows in MBEW with a value less than or equal to the year (LFGJA) and period (LFMON) I want to reconcile. After this I extracted all the rows with a value after this year and period and joining these articles with MBEWH and take the latest valuation from the history value (also less than or equal to the year (LFGJA) and period (LFMON) I want to reconcile) and combining these two, then it reconciles with the inventory value in general ledger.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 11, 2019 at 02:45 PM

    Hi,

    I would suggest you to use the standard MB5B report to check the values based on posting date.

    Regarding the valuation tables, the history tables are updated with first movement after a period closure. Hence its not mandatory to have history records for all the periods and it will be difficult to reconcile based on table. For more information, you may refer the blog: Material Stock and Valuation History tables – how to read them


    Regards,

    Prasoon

    Add a comment
    10|10000 characters needed characters exceeded