SAP Knowledge Base Article - Public

3454522 - Standard Export to Excel Function Export Duplicate Value

Symptom

When calling the standard export function to export the custom BO to Excel, there are duplicate values shown in the exported file.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Customer BO screen.
  2. Click on export -> to MS Excel.
  3. Open the downloaded file.
  4. The values in field A and filed B are duplicated, while in the frontend, the data is shown correctly.

Cause

This is the designed system behavior due to the field name of field A and B are part of each other so that the system cannot mapping the data correctly.

Resolution

For compound fields A and B, if the UI Names both contains the same value, the system will fail to mapping the value. For example, if the UI Name of field A is Price/content and the UI Name of field B is PriceUnit/content, the same value will be exported to excel since both names contains the value Price.

In this case, change the name of any of these fields so that they are not part of each other. Then the issue will be resolved. For example, Price can be changed to Price1 and then PriceUnit/content will not contain Price1 and the correct mapping will be done.

See Also

Custom BO, Export to Excel, UI Name, Duplicated Value

Keywords

KBA , SRD-CC-OIN-XL , Excel Integration , Problem

Product

SAP Business ByDesign all versions