Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Showing results for 
Search instead for 
Did you mean: 

Material short text transfer using LSMW

Former Member
0 Kudos


We are in the process of loading changes to our material master data using LSMW & load file conaining existing mateial data + changes(delimited .txt file). We do not face any issues with other data except material short text having " ( like :12" valve). We have noticed that after the data trasnfer the existing short text (like: 12" valve) gets changed to ( "12"" valve) - it gets additional " "(at the start & end ). All other short tet data stays ok. Please guide on how to avoid this. It may happen with some other special characters also (like , - although the question right now is for ".

Do we need to add "i" infront of existing text data so that it may not change?

Please guide. We are on ECC6.0.




0 Kudos


in Excel u hav the material desc as " Material Desc " select that column and replace, all

"(double quotes) by #(hash)

and convert it into text file...

in text file u replace

"(double qoutes) by blank space and then replace,

all #(hash) by "(double quotes)



Active Participant
0 Kudos

Hi Rajiv,

This is a common issue while saving the text delimited file thr excel. Excel adds text qualifier(") to each column where it finds any of the qualifiers like ,",:,- and many others. The best way to avoid this problem is to save the data and then open the same file with notepad and replace all " with blank.

This will solve ur problem.


Anil N.

Former Member
0 Kudos

convert your .TXT file with UTF-8 format and load the data....