07-14-2017 10:33 PM
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
07-15-2017 8:11 AM
HI
Whats your means about price?
1. standard price
2. map
3.sales price
4.purchasing price?
???
07-17-2017 3:41 PM
08-01-2017 6:54 AM
hi Luis,
if your means is PO purchase price , u can use tcode : ME1P for purchasing price history.
regards,
Jalil.
08-15-2017 10:19 PM
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...
08-01-2017 7:51 AM
You could try with:
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?
08-16-2017 1:53 PM
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
08-01-2017 8:27 AM
Hi,
You can check with these tables: a999 and konp
then just include makt for material descriptions
08-15-2017 10:21 PM
Tan,
Thanks for your post (Sorry about the late reply). Cannot find the a999 table (at least with SE16n).
Regards,
Luis
08-02-2017 9:28 PM
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.