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 all versions