Skip to Content
-2

How to get materials price history?

Hi,

I need to get the materials (MATNR) price history. I know about the MBEWH table, but that shows only the data by periods. I need to retrieve all the changes made to a particular material.

I thought about using the CDPOS table, but I'm afraid that I can't find the proper table/field combination.

Thanks in advance,

Luis

Add comment
10|10000 characters needed characters exceeded

  • You might want to clarify what you are looking for exactly. At first you mentioned MBEWH, which is a standard price history. Of course, it's only by period because that's how standard price is maintained. Then you're saying you want to see "changes". But that's the whole other set of data (= change documents, which are not available everywhere, as Raymond correctly noted). Then in another comment you're saying you need purchasing price. But that's the whole other story and different set of information. Kindly be more specific.

    Also reach to a functional consultant for more information on the business requirements. You can usually find the source tables using SQL trace and a transaction where data in question is displayed. But it's not clear in this case what you're looking for.

  • Get RSS Feed

3 Answers

  • Aug 01, 2017 at 06:51 AM

    You could try with:

    • Object Class: MATERIAL
    • Tabname: MBEW
    • Fields: STPRS, VERPR, etc.

    But, you will not get change documents for every field/transaction (read for example 1871430 - "Display Changes" transaction MM04 not updated with changes to fields VPRSV , LBKUM and SALK3 of table MBEW)

    Else did you look for the report created by note 2198317 - Analysis report for moving average price changes: MBMAPCHANGES?

    Add comment
    10|10000 characters needed characters exceeded

    • Raymond,

      Sorry for the late response (I thought I had already responded). I already asked for the note 2198317. Will get it a look as soon as I can get my hands on it.

      Thanks,

      Luis

  • Aug 01, 2017 at 07:27 AM
    -3

    Hi,

    You can check with these tables: a999 and konp

    then just include makt for material descriptions

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 15, 2017 at 07:11 AM

    HI

    Whats your means about price?

    1. standard price

    2. map

    3.sales price

    4.purchasing price?

    ???

    Add comment
    10|10000 characters needed characters exceeded