You have exported the Products into the Microsoft Excel but the all the Products have same ID.
Reproducing the Issue
- Go to Product Data work center.
- Select Materials view.
- Select the list of Materials.
- Select Export button and choose To Microsoft Excel.
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
Replace the modified/customized excel with SAP delivered template.
- Go to Application and User Management work center.
- Select Business Flexibility view.
- Select Office Template Maintenance sub view.
- Highlight the Row List of materials with Template Group as Materials - Work list, <language> and Template Type Microsoft Excel (Export).
- Select Upload button and choose Replace Existing Language Variant.
- Select Browse button and select the excel attached.
- Select Ok button.
Now you can able to export the Materials without any issues.
KBA , AP-RC-BCT , Business Config. Tools (SAP Business ByDesign , Product Enhancement