SAP Knowledge Base Article - Public

3391870 - Values Displayed in Scientific Notation (E+) When Exported via Data Workbench

Symptom

Data is exported via Data Workbench, but some field values appear in scientific notation (e.g., 3.74E+07). 



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

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Open the Data Workbench work center.

  2. Go to the Export view.

  3. Select the parameters and start the task.

  4. Navigate to the Monitor view in Data Workbench.

  5. Download the file.

  6. Check the values.

Cause

In Excel, numbers with more than 11 digits may be automatically displayed in scientific notation (e.g., 1.23E+11).

Resolution

The cell format can be changed to Number to display the full value.

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

Pasted image.png
Pasted image.png
Pasted image.png
Pasted image.png
DWB KBA 2.png
DWB KBA.png
DWB KBA 2.png
Pasted image.png
DWB KBA.png
Pasted image.png