Moving average price history Change

[Former Member]

Hi

Scenario -  Iam doing material (XYZ01) to material ( XYZ21) in 309 movement , at that time MAP of material (XYZ21) will be changed based on material (XYZ01) MAP rate as per standard SAP .

Requirement : After this 309 movement , MAP of XYZ21 should be modified to previous price one which is before 309 movement  and same should happend in MR21 in background .

Example :

And can you let me know , in which table we can see the all price history changes other than MBEW and MBEWH.

Regards

Mohan

[yang_bai · Accepted solution]

Hi Mohan,

You can use table CKMI1 to check the changing history of the MAP.

Firstly goto table MBEW and get make note of the number under field "MBEW-KALN1".
Then goto table CKMI1 and enter the above value in KALNR, remove the maximum number and execute.

In the result list, you can sort by DATUM and UZEIT in ascending order.
After that, you can see the VERPR for the MAP before each posting, then you can see the change.

Regards,

Yang

[Former Member · Accepted solution]

Hi Yang

Thank you for your inputs , I can found prices changes .

Can I know what is the Standard BAPI name to post price change document which is related to standard transaction MR21.

Regards

MohanKishore

[yang_bai · Accepted solution]

Hi Mohan,

Thank you for your mark!

The standard BAPI you can use to post price change document is BAPI_MATVAL_PRICE_CHANGE. Further more, there are also BAPI_PROJECTSTOCK_PRICE_CHANGE and BAPI_SALEORDSTCK_PRICE_CHANGE can be

used.

Hope this can help.

Best regards,
Yang

[Former Member · Accepted solution]

Hi Yang,

Thanks for solution it is perfectly working. Many time consultants told us that simulation of MAP is not available in system. You have shown us way forward. Thanks a million from bottom of heart.

I this respect I have another questions:

1. If price control is "S" in material master still system calculate the MAP?

2. IF we know MAP is wrong for a particular material having price control "S", how to correct the same.

Regards

CMA Pradeep Deshpande

[rafael_zaragatzky · Accepted solution]

Hi Pradeep,

I am also very grateful to Yang Bai for the tip.

To answer your questions:

1. Yes, MAP is updated as if the material was valuated as V.

2. You can just change the MAP in trs MM02. I am not sure however if the field "stock value based on MAP" is updated too. You may test.

BR

Raf

[Former Member · Accepted solution]

Hi Pradeep and Yang,

Iam testing Bapi " BAPI_MATVAL_PRICE_CHANGE " , Is valuation type is mandatory field here ?? and can you please tell me what fields need to be entered here ( below picture) , Iam not getting output .

where should we mention new price in above fields ??

Regards

Mohan

[Prasoon]

Hi,

   If you can enter the total amount of the receiving material (Qty x MAP of receiving Material), in the field "Amount in LC field in MB1B, then the MAP of the receiving material will remain the same.

   Please test the scenario, check the accounting entries and revert back. If the field is not available in the screen, maintain the field as option in OMBW transaction for 309 movement.

   But I doubt the feasibility while the transaction is entered by the user. You can go for development to calculate the value automatically and populate in the field.

Regards,

AKPT

[former_member183424]

No possible.. System will always change the MAP for receiving material at the time of transfer posting.

System will update the exact coming value for the receiving material and accordingly system will change the MAP for receiving material. System will not effect the MAP for supplying material.

That is the posting logic of MAP materials.