MC.5 Valuated Stock Value logic

[sriram_ramesh]

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

[former_member194965]

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.

[sriram_ramesh]

Hi Ananthachari,

Yes right. And S032 gives total stock movement details.

But I need to know what logic is behind MC.5 output for "Valuated stock value" value.

[former_member194965]

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.