Skip to Content
-2

How to get materials price history?

Jul 14, 2017 at 09:33 PM

150

avatar image

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

10 |10000 characters needed characters left 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.

0
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Raymond Giuseppi
Aug 01, 2017 at 06:51 AM
0

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?

Show 1 Share
10 |10000 characters needed characters left 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

0
Tan Michael 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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Tan,

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

Regards,

Luis

0
jalil mousavi Jul 15, 2017 at 07:11 AM
0

HI

Whats your means about price?

1. standard price

2. map

3.sales price

4.purchasing price?

???

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Jalil,

I mean purchasing price...

Regards,

Luis

0

hi Luis,

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

regards,

Jalil.

0

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

0