Symptom
- When uploading an Excel file (.xlsx) with decimal values via the Fiori app "Upload Business Configuration" (F4638), decimal values are incorrectly converted during the upload process.
- Example: A source value of 8,40 (German decimal notation) is converted to 84,00 in the simulation/preview step.
- Values without decimal places are uploaded correctly.
- When entering the same decimal values manually into the custom table, the values are stored correctly.
- The issue occurs for users whose SAP user settings use the German decimal notation (1.234.567,89 — dot as thousands separator, comma as decimal separator).
See App Maintain Business Users
Read more...
Environment
- Fiori app “Upload Business Configuration” (F4638)
Keywords
upload business configuration, f4638, decimal separator, comma decimal, dot decimal, number format, regional settings, locale, excel text format, misinterpreted decimals, data preview, simulation, fiori app, business configuration sets, parsing , KBA , BC-CUS-TOL-BCD , Business Configuration Sets , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview