Units of Measurement

Measurement Attributes refer to attributes in the Product configuration that display values of certain measurement types, such as Pressure, Temperature, Length etc. When Measurement Attributes are created, their values are expressed in default units (Figures 1, 2). For any measurement type, users can select measurement units of their choice. Based on the user’s selection of the measurement unit, CPQ will convert attribute values to the chosen unit from the default unit. The purpose of this functionality is to display values of Measurement Attributes in units chosen by the user.

Figure 1 - Measurement attribute in configurator

Figure 2 - Measurement attribute in configurator, different default unit

The default unit of measurement is set up per user. The Units of Measurement is available in Setup, under the Product Catalog side bar.

You can enter Units of Measurement by going to Setup and opening Units of Measurement under the Products submenu option (Figure 3).

Figure 3 - Units of Measurement, Add New
  1. System admin can add as many measurement types and measurement units as needed.
  2. Once certain measurement type and its units are added, default unit cannot be changed any more.
  3. If default unit has to be changed, system admin will need to delete existing measurement type and to create it again.
  4. If measurement type that should be deleted is used in some attributes, the system admin will need to delete those attributes first, or change the attribute type, in order to remove the Measurement type and not use it any longer.

Unit Mapping Table

Once the user has added at least one default unit, he or she can download a Unit Mapping Table (Figure 4). This is done in Setup; once the user has exported the converted values, the user is then able to add the table.

Figure 4 – Exporting, Importing conversions

Take a look at the following table to see what the Unit Mapping Table will look if there is no attribute with this unity type. If there are no attributes belonging to a certain measurement type, the Export Unit Mapping Table will be empty. For example, if a system administrator downloads a table containing no attribute whose measurement type is Pressure, the table downloaded will be empty.

Figure 5 – Unit Mapping Table

The Unit Mapping Table format is as follows:

  • The first column is a Default unit.
  • The table will have as many columns as there are added measurement units.
  • The column order is the same as the order in which measurement units are added.
  • The number of rows in the Unit Mapping Table is defined by a number of unique values of measurement attributes.
  • If there are attributes of a certain measurement type in the system, the export unit mapping table will contain the attributes' display value, and no duplicates.

If the administrator already completed the conversion of a certain value, the Export Unit Mapping Table will contain converted values as well (Figure 6).

Figure 6 – Converted values

Note the following when two attributes use the same measurement, which would be Pressure in this case: The display value can be shown with space (25bar) or without space (25 Bar). The format of the display value is defined by the system (or admin user) who creates Units of Measurement attributes. When a Unit of Measurement attribute is loaded in product configuration, attribute display values will be read from the Mapping Table Unit. The attribute values format is as follows: 0.25 Bar and 0.25 bar are the same values, but one value exists in the unit mapping table. The format of the first value entered in the system will be applied to all other attributes with the same values.


New attribute: Attribute A with values 0.25 Bar, 0.35 Bar, 0.45 Bar.

New attribute: Attribute B with the following values, 0.25 bar, 0.35 bar, 0.45 bar, will be displayed the same way in configuration. But in table mappings, values 0.25 Bar, 0.35 Bar and 0.45 Bar will be displayed.

  • 0.25Bar and 0.25bar are the same values, but one value is present in the Mapping Table Unit. The format of the first value which entered in the system will be applied to all other attributes with this value.
  • 0.25bar and 0.25 Bar are the same values, but one value is present in the Mapping Table Unit. the format of first value entered in the system will be applied to all other attributes with this value.

If a new value is being compared to a value entered at the time the administrator completed a conversion for the last time, new values will be added to the column Pressure, but values will not be converted to other units.

An administrator needs to download a Unit Mapping Table, conduct a conversion and put the table back into the system.


0.55Bar and 0.65Bar are new values in attribute Pressure that have not been converted yet in columns Pascal and Psi (Figure 7).

Figure 7 – New values

File Import

To import a Conversions file click the Edit icon of your Unit of Measurement. Then click Browse to choose your file and click Save (Figure 8). The import will be completed automatically once the user uploads the file. Creating measurement types and units have to be completed prior to creating the attribute, Unit of Measurement type.

Figure 8 - File import

Attribute Type - Unit of Measurement

To support a unit of measurement in product configuration, you should create a new attribute type (Figure 9). As soon as Measurement is chosen as an attribute type, a Unit of Measurement field will open up. Here the admin user can select the measurement type.

Figure 9 - Attribute Type

At this point, the admin user can add attribute values and attribute value codes, in the same way as for other attribute types; and add the attribute to the product (Figure 10).

Figure 10 - Attribute values, value codes

Field name: Unit of Measurement

Type of field: Unit of measurement is a drop-down filed. All measurement types that the administrator added to the system will be listed here.

The purpose of this field: In this field, the system administrator defines the kind of measurement as a new attribute. Examples include pressure, flow, temperature, etc. Note that this is a required field.

Display Values the values of a measurement attribute in the unit defined as a default unit. Attribute value example would be 0.25 Bar.

Unit of Measurement fields on the User page

As soon as a new measurement type is added to the system, that measurement type becomes a standard field on the User page (Figure 11) and User setup.

Figure 11 - User Page

Units of Measurement field labels can be translated to the user’s language by adding its key to the dictionary. The content of these fields, however, cannot. The administrator will be able to add a default value to the Units of Measurement fields in User setup. A default value can be added neither through Export/import, Users functionality, nor User API.

Units of Measurement Scopes and Limits


  • When a user edits a saved configuration, Favorites, or a configuration from an existing quote, and if measurement attributes have selected values, the system will show selected value of measurement attributes in unit selected when the Edit action was executed.
  • When a new product is created over API, the Unit of Measurement attribute type will be supported. API will be expanded to support the “Measurement type” along with the attribute type.
  • Creating an attribute type “Unit of Measurement” through Export/Import functionality will be supported. Importing Attributes with Unit of Measurement Type is required when you want to make an attribute determined by a unit of measurement. When you conduct your Attribute Import the Excel file should include a column called Measurement where you will enter your Display Values and your unit of measurement.These values must be entered in the file being exported in order to be able to convert these values from your default value (metres, for example), to another value (kilometres, another example).
  • Making rules with this type of attribute and IronPython scripts will be supported.
  • Attribute “Unit of Measurement” tags - all CPQ attribute tags have to work with this new attribute.
  • Attribute “Unit of Measurement” in Deploy/Send Changes Functionality – entire settings regarding Measurement and the Unit of Measurement will be deployed to a new environment.


  • Attribute “Unit of Measurement” translation - values of measurement attribute cannot be translated to other languages. For example, translating 25,000 Pаscale in English to 25,000 Паскаль in Russian is not supported.
  • Attribute “Unit of Measurement” in Quote - tags in the quote will return the value of the default unit. The converted values in the quote are not supported by the design; only tags in the configurator return converted values.
You are here: SAP Sales Cloud CPQ Online HelpAdmin Page HelpProduct AdministrationProductsUnits of Measurement