SAP Knowledge Base Article - Public

1681171 - Product ID is Same for all the Products Which Were Exported to Microsoft Excel

Symptom

You have exported the Products into the Microsoft Excel but the all the Products have same ID.

Reproducing the Issue

  1. Go to Product Data work center.
  2. Select Materials view.
  3. Select the list of Materials.
  4. Select Export button and choose To Microsoft Excel.

Cause

The issue is not with the SAP delivered template. The issue is due to the user modified template. The issue has occurred because the formula (for the Product ID column) is wrong

Resolution

Replace the modified/customized excel with SAP delivered template. 

  1. Go to Application and User Management work center.
  2. Select Business Flexibility view.
  3. Select Office Template Maintenance sub view.
  4. Highlight the Row List of materials with Template Group as Materials - Work list, <language>  and Template Type Microsoft Excel (Export).
  5. Select Upload button and choose Replace Existing Language Variant.
  6. Select Browse button and select the excel attached.
  7.  Select Ok button.

Now you can able to export the Materials without any issues.

Keywords

KBA , AP-CI , Customer Invoice Processing , Product Enhancement

Product

SAP BUSINESS BYDESIGN 1611 ; SAP BUSINESS BYDESIGN 1705 ; SAP Business ByDesign 1308 ; SAP Business ByDesign 1311 ; SAP Business ByDesign 1402 ; SAP Business ByDesign 1405 ; SAP Business ByDesign 1408 ; SAP Business ByDesign 1411 ; SAP Business ByDesign 1502 ; SAP Business ByDesign 1505 ; SAP Business ByDesign 1508 ; SAP Business ByDesign 1511 ; SAP Business ByDesign 1602 ; SAP Business ByDesign 1605 ; SAP Business ByDesign 1608 ; SAP Business ByDesign 1702