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
- Go to Customer BO screen.
- Click on export -> to MS Excel.
- Open the downloaded file.
- 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