SAP Knowledge Base Article - Public

2017959 - No Option to Mass Upload Materials Including Quantity Conversions via Excel

Symptom

You want to perform a mass upload of materials including Quantity Conversions. But the available excel file to upload materials does not contain any fields related to Quantity Conversions.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Product Data work center.
  2. Go to Materials view.
  3. To download the excel, select the New button.
  4. In the drop down menu, select Material from Microsoft Excel®.
  5. Open the ListOfMaterials file.
  6. Fields related to Quantity Conversions are not available.

Cause

SAP Business ByDesign does not provide any standard excel option to upload the Quantity Conversions of materials.

Resolution

Alternatively, you may use the migration tool to migrate materials including Quantity Conversions information:

  1. Go to Business Configuration work center.
  2. Go to Overview activity.
  3. Find and select the Migration of Materials activity.
  4. Select Migrate Materials using the Migration tool.
  5. In the upper right corner, select You Can Also.
  6. Select Download Migration Template.
  7. Open the template.
  8. Find the tab Quantity Conversions.

Keywords

not find, missing, migration, not found, mapping, save back, not possible, not able, conversions, Quantity , Corresponding Quantity , KBA , materials , migration , quantity conversion , SRD-MD-PRD-PRD , Product , How To

Product

SAP Business ByDesign all versions