cancel
Showing results for 
Search instead for 
Did you mean: 

Change 2nd language Material description for multiple materials

Former Member
0 Kudos

Dear Experts,

Please let me know the options to change 2nd language Material description for multiple materials at once.I have tried in MM17 but seems that need to change one by one. Or is there any way that I can replace the 2nd language materials description with 1st Language material description.

Thanks & Regards,

Ravi

Accepted Solutions (1)

Accepted Solutions (1)

JL23
Active Contributor
0 Kudos

Do you know ABAP coding?

if yes, then you can do it in MM17.

Select your field with the value to be changed, then click the formula button

In the pop-up for the formula hit button ABAP

Now you get an editor to write ABAP coding

make sure that you finally return the correct text to th variable X like

X = mynewtext.

before the endform statement.

This discussion gives you the ABAP code to search and remove a character:

Former Member
0 Kudos

Ok, Jurgen ....let me check with ABAPer....with this link advised by you http://scn.sap.com/thread/1443440

Thanks a lot to all of you guys for prompt response.

Best Regards,

Ravi

Former Member
0 Kudos

Ravi,

I would strongly recommend using ABAP program and not to try LSMW nor Mass change.

The reason i am recommending code as you could easily control the characters sets using coding. However when you try use copy and paste then it is likely ASCI Char will not recognize the characters you see on the screen. for example "^" on the screen it may look like inverted v looking symbol but in the background, system may store that as special Character. i have faced this issue making copy paste in at one of the Chinese client.

Best Regards

Sunil Wawdhane

former_member183424
Active Contributor
0 Kudos

Hi

Former Member
0 Kudos

Hi Dev,

I appreciate you and thanks a lot for your kind feedback Mass changes from one field to another field.,

Best Regards,

Ravi

former_member183424
Active Contributor
0 Kudos

Have you solved your issue?

Answers (3)

Answers (3)

Former Member
0 Kudos

This message was moderated.

Former Member
0 Kudos

Ravi,

LSMW is commonly used to conduct mass changes in Material Master Descriptions.

Best regards,

DB49

Former Member
0 Kudos

Hi DB49,

Yes you are true, is that is the only option available.

Best Regards,

Ravi

Former Member
0 Kudos

Ravi,


Yes you are true, is that the only option available.

Of course not.  For a start, read the other answers.  Also, you can create a custom program.

IMHO LSMW is the simplest solution, requiring the least effort for a non-technical person.

Best Regards,

DB49

JL23
Active Contributor
0 Kudos

I agree to the LSMW solution too for a different reason: In a production environment you will usually not have Development authorization, hence you cannot get to the formula editor. Just wanted to highlight that it is technically possible with MM17

former_member183424
Active Contributor
0 Kudos

Why don't you filter the language key on selection field?

Is there any problem for that?

Just one thing, Is your many material contains same description?

Former Member
0 Kudos

Hi Dev,

Material description contains inverted commas before and after the description "XXXX" (special characters " " " ) in second language, due to that getting inconsistency in the reports while downloading to excel.

Thanks & Regards,

Ravi

former_member183424
Active Contributor
0 Kudos

Okay, then you just remove the commas from the descriptions.

As per my knowledge you can do that via MM17-mass changes.

You can achieve this via LSMW.

Just prepared a excel for all material with correct description..

Then run this via LSMW.

Former Member
0 Kudos

Hi Dev,

Please advise how to proceed with MM17.

Best Regards,

Ravi

former_member183424
Active Contributor
0 Kudos

I am really very sorry for my spelling mistake...

It will be can't... not can...

Former Member
0 Kudos

Ok Dev