When you try to upload a new material using Excel Add-in, system throws below error messages:
Error 1: Lower case or special characters not permitted in field ProductCategoryInternalID of node XYZ.
Error 2: An error occurred during save process
Reproducing the Issue
- Open MS-Excel file (for New material) which is downloaded from Material view of Product Data work center.
- In the excel, Go to SAP tab.
- Select Logon.
- Enter the user credentials and select ok.
- After enter the details of the materials, select Save Data to button.
Excel throws above error messages
The cause for the issue is due to the fact that Planning Group Description is entered in the field Planning Group ID.
The Planning Group ID shoud be Upper Case and should be same as in the ByD System
You can enter the correct Planning Group ID and Save the data, which will save sucessfully.
KBA , SRD-MD-PRD-PRD , Product , Product Enhancement