cancel
Showing results for 
Search instead for 
Did you mean: 

Table to track Moving Average price history

Former Member
0 Kudos

Hi ,

Is there any T Code / Table available to track Moving Average price.I wanted to track Date wise / Receipt wise moving Average price for material.

Need yr help in this regard

Regards

Shrey

Accepted Solutions (0)

Answers (7)

Answers (7)

pankaj_singh9
Active Contributor

Hi,

Refer tables;

MBEW - Material Valuation
MBEWH - Material Valuation: History

Former Member
0 Kudos

This message was moderated.

Former Member
0 Kudos

thx

BijayBarik
Active Contributor
0 Kudos

Hi,

Find the history details of MAP in Table S031 SE11 T.CODE.

Regards,

Biju K

Former Member
0 Kudos

Thx for your reply , but thru MEBWH , i can see period wise MAP.

But i have a requirement to track RECEIPT WISE MAP.

Where i can see that.

REGARDS

SHREY

JL23
Active Contributor
0 Kudos

receipt wise MAP is just not stored in any table.

You can develope an own table and report to copy the MAP daily (or by receipt event) to this table.

Or you use a mix of MR51 and Excel.

Run MR51, add coloumn for entry date, sort it in sequence of entry.

download it to Excel.

Add a first line with quantity and value from last periods record from table MBEW(H) and calculate the price.

Then you can start calculating the MAP for each and every line.

Former Member
0 Kudos

Hi,

there is no such table for checking the MAP changes. You can do is go to MMR and in the Accounting view and MAP field just click and go to menu bar at top and environment and go to changes. This will show the details as to when the changes have been maed in MAP.

Hope this helps.

Regards,

Prasanna

Award pls if helpful

Former Member
0 Kudos

if u run MM60 u will find out the price (moving average/standard) at same time.

check table -field: MBEW-VERPR

regards,

indranil