Your requirement is to upload Suppliers using Excel Add-in. For example, you want to upload Suppliers for the Country CI - Cote d'Ivoire. During the upload process, you get below mentioned error:
Exception occurred. Contact your system administrator.
Update operation failed: Error during Maintain operation:'/SAP_BYD_CodeList/CodeListItem/DisplayAs[.='CI - Cote d'Ivoire']/../Code' has an invalid token.]]
Reproducing the Issue
- Go to Supplier Base workcenter
- Go to Suppliers view
- Select New -> Suppliers From Microsoft Excel
- Download the Suppliers XML template
- Fill the details
- Upload the file using Excel Add-in
- System throws errors
Some of the characters are not allowed while the data is converted to XML.
The XML mapping property of the Microsoft Excel does not allow the char ( ' ) in the code list. The single quote is also one of such cases.
We have found work around where the Country Name which is displayed in the excel would be different (code will be same), however when it is uploaded into the system the Country Name will be stored as expected.
For example, you may use the List Of Suppliers Template.xlsx which is attached to this document.
We have a blog on the reported issue:
We have added this to our product backlog and will evaluate possible enhancements to address it in one of the future releases.
KBA , AP-BP-BPT , Business Partner Template , How To
|List Of Suppliers Template.xlsx|