SAP Knowledge Base Article - Public

2994967 - Error When Updating Price/Discount List via Microsoft Excel Add-In


You are trying to upload an excel file to update a price/discount list, but faces an error.


SAP Business ByDesign

Reproducing the Issue

  1. Go to the Product and Service Portfolio work center.
  2. Select the Discount Lists view.
  3. Select the Discount List.
  4. Download the Microsoft Excel file.
  5. Try to send the data in the Microsoft Excel file.

You face an error.


The excel upload does not work for custom price list/discount list when it contains a Standard Header table with a Custom Item table.

The system is designed to support the following:

  1. Standard Header + Standard Item table
  2. Custom Header + Standard Item table
  3. Custom Header + Custom Item table


This is the expect system behavior.

If you would like to proceed with the custom item table, please create a custom header table and assigned this to the price list/discount list.

See Also

SAP ByDesign Price Determination using Extension Fields.


Price List, Discount List, Excel, Upload, Update, Error, Standard, Custom , KBA , AP-PRC-PC , Calculation , How To


SAP Business ByDesign all versions