Skip to Content
avatar image
Former Member

Moving average price history Change

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

Untitled.png (12.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 09, 2015 at 06:43 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

      pastedImage_0.png (12.8 kB)
      MAP BAPI.png (34.5 kB)
      MAP BAPI.png (11.0 kB)
  • Jan 08, 2015 at 05:46 PM

    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


    pastedImage_0.png (17.6 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Jan 08, 2015 at 08:57 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded