SAP Knowledge Base Article - Public

3457396 - Material Description In Traditional Chinese Cannot Be Uploaded To The Expected Language While Using Excel Add-In Tool


When creating Material with a Material Description in Traditional Chinese using the Excel Add-In tool, the Material Description is getting created in Simplified Chinese. 


SAP Business ByDesign

Reproducing the Issue

  1. Go to Product Data work center -> Materials view.
  2. Click New -> Material from Microsoft Excel and download the template.
  3. Open the template and input the material to create with a Material Description which language code is ZF(Traditional Chinese).
  4. Login system and save the data to system.
  5. Login into system in language ZF(Traditional Chinese).
  6. Go to Product Data work center -> Materials view.
  7. Search for the material just created and open it.
  8. Material Description is not uploaded.
  9. Open Language dropdown list, choose Simplified Chinese (ZH), Material Description is created in Simplified Chinese (ZH).


The excel template for material downloaded from system does not contain a language property.


The language property is missing for the excel template, the same can be added with below steps:

  1. Rename the writeback template file from filename.xlsx to
  2. Now unzip the newly created file.
  3. Go to docProps->custom.xml.
  4. Open custom.xml in any editor and add the below mentioned property [Note: fmtid should be same as others, pid should be in order with others (if the last pid in file is 13 than new one should be 14 or the next number).]
  5. Compress and zip all the files again after saving edited file.
  6. Rename again from to filename.xlsx.
  7. Open the newly generated excel file -> go to File -> Info -> click on Properties -> Advance Properties.
  8. Scroll down to the property name "_SAP_T_LANGU" and change value from EN to desired language code - ZH,ZF, etc. in upper case.
  9. Click OK.
  10. Close and reopen the file.

Property to add: <property fmtid="{D5CDD505-2E9C-101B-9397-08002B2CF9AE}" pid="14" name="_SAP_T_LANGU"><vt:lpwstr>ZF</vt:lpwstr></property>


  1. The steps 1 to 6 would have to be followed one time per file to set the default language, and steps 7 to 9 will have to be repeated if need to change the default language to some other language, otherwise all the steps will be onetime activity for one file.
  2. If download a new template every time, then all the steps would have to be followed.


Material Description, Material, Excel Add-In, Traditional Chinese, Simplified Chinese , KBA , AP-PRD-MAT , Material , Problem


SAP Business ByDesign 2402