SAP Knowledge Base Article - Public

3010089 - Unable to Upload Sales Order from Microsoft excel with fields TextTypeCode and ContentText


You have added the fields TextTypeCode and ContentText to your excel template and now are receiving an error when there are blank rows for these columns when you try to upload the data via excel.


SAP Business Bydesign

Reproducing the Issue

  1. Download excel template.
  2. Add in two extra columns called TextTypeCode and ContentText.
  3. Bind these to SalesOrder->Item->ItemTextCollection->Text_1->TypeCode->Value and SalesOrder->Item->ItemTextCollection->Text_1->ContentText respectively. 
  4. Enter in all mandatory fields leaving TextTypeCode and ContentText blank. 
  5. Try to save.
  6. You will get 500 internal error


  • The system is sending blank <ItemTextCollection> tags for every row under these columns. 
  • It is not mandatory to always have ItemTextCollection but if it is sent, it must contain and TextTypeCode and ContentText.


  1. In order to send an excel payload without this information, You will need to adjust the slider in the template. To do so you can follow the below steps.

  2. First, unhide all columns by right clicking on the right most column.1.png2.png

  3. If that does not unhide all columns you can also click the arrow in the top left corner to select everything.3.png

  4. Go to the Home tab & click format button. Hover over the Hide & Unhide and select unhide columns.4.png

  5. You should now be able to see the slider under one of the columns for the new sales order.5.png

  6. This slider determines what rows are sent by the excel template. In order to prevent blank rows being sent, move this to the last entered row and column. For example:

  7. 6.png

  8. This prevents empty <ItemTextCollection> tags being sent and will allow the Sales Order to save successfully. Whenever you are saving, make sure that this is in the correct position so blank TextTypeCode and ContentText columns don’t end up being sent, causing the error.


Excel Upload, Sales Order Excel Upload, text type code, text collection , KBA , AP-SLO-SO , Sales Order , Problem


SAP Business ByDesign all versions