Mass changes from one field to another field.

We can change a field value from mass changes with the given value..

But some business logic needs one field value should be same as a another field.

Here with the help of some coding we can carry mass changes from one field to another field.

Jürgen Sir replied in this thread the exact procedure, which helps me a lot to make the document, its almost help me 90% to make this document.

A lots of thanks to Jürgen Sir.

Lets discuss about requirement and step by step procedure.

Suppose we have two fields in material master.

1. Reorder Point (MARC-MINBE)

2. Maximum Lot Size (MARC-BSTMA).

We have some value in field Maximum Lot Size (MARC-BSTMA)..

Here we can see we have a value only field Maximum Lot Size (MARC-BSTMA), bur we haven’t any value in Reorder Point (MARC-MINBE)

Now we have enter the value to Reorder Point (MARC-MINBE) field. But the condition will be that Value should be same as field Maximum Lot Size (MARC-BSTMA) with respective material.

It means for material TUPUCOZ5215, BSTMA value is 500, so the field value of MINBE will be also 500 for this material.

And also for material TUPUCOZ5216, BSTMA value is 600, so the field value of MINBE will be also 600 for this material.

Here we can change the value for field MINBE as respective to field BSTMA.

Use t-code MASS (you can use MM17 directly for material mass changes)

Use the Object Type as BUS1001

You can see the initial screen

Click on the tab Fields, and select the field MARC-MINBE and MARC-BSTMA

Now press Execute.

Give your all material with respective plant.

Then press execute.

You can see the initial screen appear for mass changes.

We can see our two fields Reorder Point and Maximum Lot size.

We can see we have some value in field Maximum Lot Size.

Now we have to fill out the field Reorder Point as copy from Maximum Lot Size with respective material.

Now Move your mouse pointer to Reorder Point, then click on Enter Formula/FORM Routines.

Press the option as shown in above figure or you can also find this from Application menu as shown as below screen.

Now you can see a pop-up will come which will be like below screen.

As we have to change the value for field Reorder Point, so we have to write a code for this field.

Now click on the ABAP which is right side of Reorder point.

Now the screen will be like below.

Its a ABAP FORM routine.

We have to just add our own logic here..

As we have to fetch the field value from field Maximum Lot Size (MARC-BSTMA), So we have write as like below screen shot.

As you can see I have just entered a line where X value will be as per value of BSTMA.

Don’t forget to give the dot (.)at the last of this line.

Then just press Ctrl+S or you can select Save from table as below screen shot.

After press save, you will see the back screen as shown below

Then press continue or enter.

You can see a text will come on the Reorder point field.

Now our coding part is done.

Now you have to deselect the Maximum Lot Size field. If you continue without deselect this field, then the field value for Maximum Lot Size will remove.

Now press the option – Carry Out Mass Changes.

(Note : Press only one time on Carry Out Mass Changes, if you press twice on this option, then the value will remove)

Now we can see the result.

Our Reorder Point replaced with the same value as Maximum lot Size with respective material.

Now we can save our data.

Press or you can press Ctrl+S.

Now you can see a success message like as below

Now our all data saved.

Lets check the MARC table and the value for Reorder Point and as well as Maximum Lot Size.

Here we can see our Reorder Point (MINBE) changed as per Maximum lot Size (BATMA) as per respective material.

Its not only for material master..

It will applicable for all mass changes.

Thanks and Regards

Dev Patra

Assigned Tags

You must be Logged on to comment or reply to a post.

Hi Dev,

Helpful document !! Thanks for sharing.

Regards,

Krish

Cool document  - thanks for sharing... I see you can do even more things like " IF field X is blank then field Y is 'ABC' etc. Might be usefully when doing some specific mass changes.

Nice document.

I do think that most people will have issues doing this on a production system as you would need S_DEVELOP access and most companies do not allow this directly in production.

You could have mentioned that you just learned it this week from my reply  to a discussion, while you had replied last week in a discussion that it is not possible. 😆

Dibyendu Patra
Blog Post Author

I always made a mistake in coding part, so that my mass changes wasn't working every time.

Yesterday evening I thought, it should be a document for step by step procedure.

Anyway I have mentioned that in this document.

And about this discussion, Yes, that was my mistake, Even I didn't know that we can also remove characteristics from mass changes with coding..

Nice document Dev.. I have 1 query. can i close around 1000 PR line item in mass tcode.

Regards

Sanjeet Kumar

Dibyendu Patra
Blog Post Author

If you want to set deletion flag, then MEMASSRQ doesn't support to set deletion flag.

You have to do LSMW for t-code ME52.

Regards

Dev

Thanks Dev, nice document.

Regards

Sanjeet

Good Doc Dev, Some thing New Learn't abt Mass Changes... 🙂 🙂 🙂 i tried it works thanks for Jürgen L Sir

Dibyendu Patra
Blog Post Author

Hey shiva

Thanks for like my document...

I have learned the nice things from SCN....

Thanks a lot to SCN owner and Jurgen Sir also....

Hi DEV keep it up

HI Dev,

Really good doc and it's useful. Instead of selecting two fields ( Reorder Point (MARC-MINBE),  Maximum Lot Size (MARC-BSTMA) ), we can choose only the field (MINBE here ) which we have to change/update. So, no need to deselect the other field which we don't want to update. Whether my understanding is correct? Will it working fine?

Thanks

Dibyendu Patra
Blog Post Author

Yes it will working absolutely fine..

I have used this just to shows that the quantity is coming same from BSTMA.

No need to select this field.

Just your coding part has to be right for the fetching field.

Hi Dev,

Nice Document, I tried as per the logic provided by you, Thanks a lot

Fantastic clue thanks to Dëv Päträ and Jürgen L

Rgds

MBN

Dibyendu Patra
Blog Post Author

Yes.. Jurgen Sir helps me a lot to write this document.

He is my ideal.

I tried its in reverse, Reorder point to Max lot size and its works.

Thanks for sharing 🙂

Credit goes to you Dëv , You are doing well.

keep up the good work.

Good work !

Appreciable effort 🙂

R,

Amala

Hi Dev,

Very useful document.

Informative.

Thank you.

Thanks for sharing this info.

Very Useful.

Hello, I'm trying to update material description DE by copying from EN. Is it possible to use this nice tool?