Skip to Content
avatar image
Former Member

Mass changes to Accounting1 in MM17

Hello,

I am trying to clear the data out of 'future price' and 'valid from' in the Accounting1 tab in Material Master.

I can't find it in MM17 but I do not have a lot of experience using it.

Any help on avoiding going in one by one will be hugely grateful because i have over 11,000 to change.

Best wishes

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • May 04, 2017 at 10:03 AM

    Hi Adam,

    goto MM17 in that select material valuation MBEW and execute it.

    then enter your materials by selecting Multiple selection and maintain valuation area and execute it.

    In this screen you need to select Select field (top left) in that you need to select your parameters what ever you want to change.

    Maintain the new values and Click on Carry out a mass change.

    Add comment
    10|10000 characters needed characters exceeded

  • May 04, 2017 at 10:04 AM

    Hi,

    You can use LSMW for mass changing of values.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 04, 2017 at 10:39 AM

    Hello Aravind,

    Thank you for your help.

    I have followed your instructions and I can't find the field I need for 'Future Price'.

    Is it possible to add it as a field?

    I have access to change the 'Valid From' field and I can change the value but I can't make it blank.

    Is this possible?

    Best Wishes,

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Adam,

      In New values tab-Valid from field don't mention any date and select it. Select the 'Valid from' from your materials list (below the new values tab) and do carry out a mass change then the valid from field will update with empty.

      We don't have a field Future Price so ask your ABAP consultant to add the field in MBEW table.

  • avatar image
    Former Member
    May 04, 2017 at 10:40 AM

    Hi,

    Thanks for your help.

    I have been able to change the data in 'Valid From' but I am unable to make it blank.

    Is it possible to do?

    I can't find the future price field as seen below.

    Can you create a field is necessary?

    Best Wishes

    Add comment
    10|10000 characters needed characters exceeded

  • May 04, 2017 at 06:51 PM

    Hello Adam,

    To the best of my knowledge unfortunately you can't add any field in MM17. You should go for LSMW as per my recomendation.

    Best Regards

    Mohsin Abbasi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 05, 2017 at 07:47 AM

    Hi Adam

    go for LSMW, BDC, Script as per your convenient

    Best is LSMW

    Regards

    R

    Add comment
    10|10000 characters needed characters exceeded

  • May 05, 2017 at 08:36 AM

    How did you get the values into those fields?

    As this usually happens with a cost estimate there might as well be ways to remove it, e.g. with CKMPRPN

    Add comment
    10|10000 characters needed characters exceeded