Skip to Content
author's profile photo Former Member
Former Member

Mass update of the Planned price field in Material Master

Hi,

I need to update a few hundred of the future prices for packaging materials prior to the Cost Run for 2008. I would like to be able to upload an excel file with material numbers and prices to update the Planned Price 1 field in the costing view in Material Master as well as the date from which it is valid. Is there a way to do this?

Thanks

Regards,

Alina

Add comment
10|10000 characters needed characters exceeded

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 09, 2007 at 01:24 PM

    you could try an LSMW or a CATT script.

    Normally a project has its own upload program to change master data or transactional data.

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 09, 2007 at 03:11 PM

    Try MM17 for mass change. But this may not be good for xl upload.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 09, 2007 at 04:16 PM

    Transactions MASS and MM17 do not allow updating of Planned Price fields.

    CATT or custom upload are the choices. If updating Planned price is part of the process, have a program written. Which ever you use, watch the formatting of the validity data.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 11, 2007 at 01:42 PM

    Thanks, guys - I'll just try to talk to our system guys then.

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 06, 2015 at 08:10 AM

    Hi All,

    You can use the Program "R2RMMR_MATERIAL_CHG_MASSUPDATE" (Tcode: R2RMM126)

    To upload the Planned Price 1 in Material Master. No need to create LSMW for the same.

    Maintain the upload file in .txt (i.e. Notepad) format, the fields should be tabulator and the date should be in YYYYMMDD format.

    Regards,

    Sangharsh Navada


    R2RMM126.JPG (88.3 kB)
    Add comment
    10|10000 characters needed characters exceeded