SAP Knowledge Base Article - Public

1721637 - Error Message: UoM XYZ not Valid; It is not Released, While Uploading Material Through MS Excel


When upload some Materials in the system using MS Excel, excel throws below error message:

UoM XYZ not valid; it is not released

Reproducing the Issue

  1. Go to Product Data work center.
  2. Select Materials view.
  3. Select New button and choose New Material from Microsoft Excel.
  4. Logon to the Excel (Business ByDesign Excel add-in)
  5. Update the Material details in the excel.
  6. Select Save data to.


There are two possible causes for this issue,

  1. The UoM entered by you in the excel is not a valid symbol (ex: Typo error).
  2. The UoM entered by you was created in the system but in Blocked status


Verify whether the UoM symbol entered by you is as same as the one which is available in the system.

To check, whether status of the UoM, follow the below steps:

1. Go to Business Configuration work center.
2. Search for the fine tuning activity Quantities and Units of Measure under Business Configuration Search.
3. Select Create and Maintain Trading Units.
4. Show Blocked.
5. Search for UoM XYZ.

You can see the Activation Status of the respective UoM.

If you want to use this UoM for the Material, then the status of the UoM should be reverted to Active.


KBA , SRD-CC , Cross Components , How To


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