SAP Knowledge Base Article - Public

3602268 - Price List Excel Upload Template does not Fill Product Description Automatically

Symptom

You are using the Excel template to upload price lists in the system. It is expected that when inserting a product ID in the respective column of the template, the description is automatically populated.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Product and Service Portfolio work center.
  2. Enter the Price Lists view.
  3. Select the query depending on the type of price list to be created (Base Price List, Customer Specific Price List, etc.).
  4. Click on the Download button.
  5. Open the Excel template downloaded.
  6. Populate the Product ID column with an existing product from the system

Here it is possible to see that the product description is not automatically populated.

Cause

The Excel upload template does not have a direct connection with the SAP Business ByDesign tenant before the upload action itself.

Considering this, the Excel template is not able to fetch data from the tenant.

Resolution

The system works as expected.

Keywords

Upload, Template, Price , KBA , AP-RC-FF , Forms Flexibility , Problem

Product

SAP Business ByDesign all versions