Table information required

[Former Member]

Hi,

I have two field stprs (standard price),(last price change) in my MBEW table in r/3.

stprs is the standard cost of material.

I want to get the history prices of a material. But MBEW always has current price (stprs) of material and doesnot store history price.

So I would like to know if there is any <b>TABLE</b> which actually stores the history prices of material.

i.e materials, startdate, end date, price.

Regards,

Dutta

[Former Member · Accepted solution]

Hi Dutta,

Pls find below the tables for material valuation:

MBEW-Material Valuation

MBEWH-Material Valuation: History

Also other tables of interest are :

EBEW-Sales Order Stock Valuation

EBEWH-Valuation of Sales Order Stock: History

OBEW-Valuated Stock with Subcontractor

QBEW-Project Stock Valuation

QBEWH-Valuation of Project Stock: History

Std SAP transaction MB5L for stock valuation uses these tables.

Cheers,

Vikram

Pls reward for helpful replies!!

[ferry_lianto]

Hi Dutta,

Please check table <b>MBEWH</b>.

Regards,

Ferry Lianto

[RichHeilman]

Please check MBEWH, or for sales order stock, try EBEWH.

Regards,

Rich Heilman

[Former Member]

Thanks for the quick reply..

Let me check and then i'll get back to you'll

[Former Member]

Please check MBEWH table...

Cheers