Table to track Moving Average price history

[Former Member]

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

[pankaj_singh9]

Hi,

Refer tables;

MBEW - Material Valuation
MBEWH - Material Valuation: History

[Former Member]

This message was moderated.

[Former Member]

thx

[BijayKumarBarik]

Hi,

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

Regards,

Biju K

[Former Member]

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]

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]

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]

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

check table -field: MBEW-VERPR

regards,

indranil