2676529 - Wrong amount format on CSV file - Employee Central

Customer exported the pay scale level, but the amount value have a diferent value between CSV file and system value.

Example:In the system the amount appears as "11.111,11" but in the excel file the values is coming as "11111.11"

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

Employee Central

Dowload the CSV file with amout and compare with the target employee under Employee Profile

1. Go to Admin Center
2. Go to Import and Export Data
3. Choose the file that have amount information configured
4. Download via Monitor Job
5. Compare the values in the Excel file with the Employee Profile

Sample:

• CSV file format

• Employee Profile

This is expected behavior since the CSV file use the commas to separate the collums in Excel file, and since the system just generate Excel Files this will be the standard behavior when the values comes with a comma.

Employee Central, CSV, Excel File, Comma , KBA , LOD-SF-EC-MDF , MDF & EC2MDF Migration , How To