Skip to Content

MC.5 Valuated Stock Value logic

Hi,

I'm doing an inventory report which also has valuated stock value field.

The logic for this field will be same as MC.5 value.

In my Z-report selection, I'm giving material, period, year and plant. And report is displayed material-storage location wise.

I've been searching for the logic in standard. S031 and S032 tables are being used.

But I'm not able to find the exact logic.

Please help me in finding the logic.

Thanks in advance.

SriRam

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Aug 22, 2016 at 07:48 AM

    Hi sriram,

    ->Table S031 which give you monthly stock movement details.And fields MZUBB (Valuated stock quantity receives) and MAGBB (Valuated stock quantity issues)

    ->Table S033 which gives you daily stock movement details.And fields MZUBB (Valuated stock quantity receives) and MAGBB (Valuated stock quantity issues)

    Above mentioned logic only for quantity of the stock.

    Regards,

    E.Ananthachari.

    Add a comment
    10|10000 characters needed characters exceeded

    • Value is calculated with MBEW and MBEWH tables.

      ->If it is a current quarter then quantity will calculate with MBEW(STPRS(Standard price) or VERPR(Moving price)).

      ie. Value = Quantity * MBEW-STPRS

      ->If its a previous quarter means quantity will calculate with MBEWH(STPRS(Standard price) or VERPR(Moving price)).

      ie. Value = Quantity * MBEWH-STPRS.

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.