Skip to Content
author's profile photo Former Member
Former Member

Table information required

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2006 at 06:47 PM

    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!!

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2006 at 05:51 PM

    Please check MBEWH table...

    Cheers

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 13, 2006 at 05:51 PM

    Hi Dutta,

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

    Regards,

    Ferry Lianto

    Add a comment
    10|10000 characters needed characters exceeded

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.