SAP Knowledge Base Article - Public

3300178 - Unit of Measure on Exported Opportunity List to MS Excel Sheet


After exporting Opportunities to Microsoft Excel, the Unit of Mearure (UoM) displayed on the UI is different to that on the Excel.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


SAP Cloud for Customer

Reproducing the Issue


  • You created custom fields that contain a unit of measure and added this to your Opportunity OWL.
  • You expect the uom's description to be exported to MS Excel, however, you find the symbol (as maintained in the Business Configuration Fine Tuning activity) to be exported, instead.
  1. Navigate to the Sales Work Centre
  2. Go to the Opportunity view
  3. Select More > Export to Excel > select language etc. > download.


In the Business Configuration Fine Tuning Activity "Quantities and Units of Measure" you can see that each unit of measure (uom) contains three parts: the code, the symbol and a description/ value.

While the system allows for Code and value (description) to be displayed in the UI for certain fields, such as those that contain a uom, the Excel will always pull the Symbol for uom fields.


This is expected behaviour


Opportunity, Unit of Measurement, Export, Description, Code, Value, Symbol, Quantities and Units of Measure, UI , KBA , LOD-CRM-OPP , Opportunity Management , SRD-CC-OIN-XL , Excel Integration , How To


SAP Cloud for Customer core applications 2211