SAP Knowledge Base Article - Public

3270774 - Error "Quantity type LENGTH not valid; it must be a characteristic quantity type" while Updating UOM Characteristics of Materials using Mass Data Maintenance

Symptom

You are trying to update the UOM Characteristics of Materials using the Mass Data Maintenance, however you get the error as "Quantity type LENGTH not valid; it must be a characteristic quantity type".

Environment

 SAP Business ByDesign

Reproducing the Issue

  1. Go to Mass Data Maintenance work center
  2. Upload the updated .csv file
  3. Click on Validate Data "Data Validation finished successfully. No Invalid data found"
  4. When you click on Execute Data Import, it throws the errors as "Quantity type LENGTH not valid; it must be a characteristic quantity type" as shown below:Erorr in MDM.jpg

Cause

Quantity Type Characteristics for the dimensions are as follows:

Length - dimensional length

Width - breadth

Hight - height

In your csv file instead of dimnsional length you could have maintaed it as length, due to this the error message is displayed.

Resolution

Request you to correct the Quantity Type Characteristics from Length/length to dimensional length.

MDM error update.jpg

FYI:

To verify and to see which Quantity Type Characteristics is correct you can follow the below steps:

  1. Go to Product Portfolio work center
  2. Open By Materials under Products view
  3. Select 1 Material ex: "ABC"
  4. Click on Edit the "ABC" Material
  5. Click on View All
  6. Navigate to the UOM Characteristics tab under General tab
  7. Enter the desired Value for Length, Width & Hight and measures accordinglyUOM.jpg
  8. Click on Save 

Now,

  1. Navigate to the Mass Data Maintenance work center 
  2. Click on Export Materials link
  3. Enter the Material ID as "ABC"
  4. Click on Go
  5. Navigate to the UOM Characteristics 
  6. You will see the Quantity Type Characteristics for the updated Length, Width & Hight accordingly as shownUOM1.jpg

Keywords

UOM, LENGTH not valid, Mass Data Maintenance , Material, Quantity Type, dimensional length. , KBA , uom, length not valid , quantity type, dimensional length , SRD-CC-MIG-DMC , Migration: Tool , SRD-CC-MIG-CNT , Migration: Content , Problem

Product

SAP BUSINESS BYDESIGN 1611 ; SAP BUSINESS BYDESIGN 1705 ; SAP BUSINESS BYDESIGN 1708 ; SAP BUSINESS BYDESIGN 2111 ; SAP BUSINESS BYDESIGN 2302 ; SAP Business ByDesign 1.0 ; SAP Business ByDesign 1302 ; SAP Business ByDesign 1305 ; 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 ; SAP Business ByDesign 1711 ; SAP Business ByDesign 1802 ; SAP Business ByDesign 1805 ; SAP Business ByDesign 1808 ; SAP Business ByDesign 1811 ; SAP Business ByDesign 1902 ; SAP Business ByDesign 1905 ; SAP Business ByDesign 1908 ; SAP Business ByDesign 1911 ; SAP Business ByDesign 2002 ; SAP Business ByDesign 2005 ; SAP Business ByDesign 2008 ; SAP Business ByDesign 2011 ; SAP Business ByDesign 2022 ; SAP Business ByDesign 2102 ; SAP Business ByDesign 2105 ; SAP Business ByDesign 2108 ; SAP Business ByDesign 2205 ; SAP Business ByDesign 2208 ; SAP Business ByDesign 2211 ; SAP Business ByDesign feature pack 2.0 ; SAP Business ByDesign feature pack 2.5 ; SAP Business ByDesign feature pack 2.6 ; SAP Business ByDesign feature pack 3.0 ; SAP Business ByDesign feature pack 3.5 ; SAP Business ByDesign feature pack 4.0