SAP Knowledge Base Article - Public

3391870 - Values Being Shown As E+ When File Is Exported via Data Workbench

Symptom

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

You have exported Data via Data Workbench but field values are showing up as 'numberE+number' (ex. 3.74E+7)

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Open the Data Workbench Work Center.
  2. Open the 'Export' view.
  3. Select Parameters and start the task.
  4. Go to DWB 'Monitor' view.
  5. Download the file.
  6. Check values.


Cause

This is related to Excel formatting: numbers with more than 11 characters will show up as E+number.

Resolution

You can change the type to 'Number' and the full value will show up.

Keywords

Wrong; Number; Character; DataWorkbench; Data; Work; Bench; E+; Exporting; .csv; .xlsx;  , KBA , LOD-CRM-INT-DWB , Data Workbench , How To

Product

SAP Cloud for Customer core applications 2308

Attachments

DWB KBA 2.png
DWB KBA.png