Skip to Content
0

Mass changes to Accounting1 in MM17

May 04, 2017 at 09:10 AM

145

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

7 Answers

Aravind Burra May 04, 2017 at 10:03 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Shyam Kumar May 04, 2017 at 10:04 AM
0

Hi,

You can use LSMW for mass changing of values.

Share
10 |10000 characters needed characters left characters exceeded
Adam Simpson May 04, 2017 at 10:39 AM
0

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,


dxymx.png (81.7 kB)
Show 1 Share
10 |10000 characters needed characters left 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.

0
Adam Simpson May 04, 2017 at 10:40 AM
0

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


kin5z.png (81.7 kB)
Share
10 |10000 characters needed characters left characters exceeded
Mohsin Abbasi May 04, 2017 at 06:51 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Rashid Ali May 05, 2017 at 07:47 AM
0

Hi Adam

go for LSMW, BDC, Script as per your convenient

Best is LSMW

Regards

R

Share
10 |10000 characters needed characters left characters exceeded
Jürgen L
May 05, 2017 at 08:36 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded