Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to get materials price history?

luis_rod
Participant
0 Kudos

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

9 REPLIES 9

0 Kudos

HI

Whats your means about price?

1. standard price

2. map

3.sales price

4.purchasing price?

???

0 Kudos

Jalil,

I mean purchasing price...

Regards,

Luis

0 Kudos

hi Luis,

if your means is PO purchase price , u can use tcode : ME1P for purchasing price history.

regards,

Jalil.

0 Kudos

Jalil,

(Sorry about the late reply, got sidetracked with another project). I was searching for the tables where the info is stored.

Thanks anyhow for your help...

raymond_giuseppi
Active Contributor

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 SA...)

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

0 Kudos

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

tan_michael
Active Participant
0 Kudos

Hi,

You can check with these tables: a999 and konp

then just include makt for material descriptions

0 Kudos

Tan,

Thanks for your post (Sorry about the late reply). Cannot find the a999 table (at least with SE16n).

Regards,

Luis

Jelena
Active Contributor
0 Kudos

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.