Symptom
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."
Environment
Employee Central
Reproducing the Issue
Dowload the CSV file with amout and compare with the target employee under Employee Profile
- Go to Admin Center
- Go to Import and Export Data
- Choose the file that have amount information configured
- Download via Monitor Job
- Compare the values in the Excel file with the Employee Profile
Sample:
- CSV file format
- Employee Profile
Resolution
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.
Keywords
Employee Central, CSV, Excel File, Comma , KBA , LOD-SF-EC-MDF , MDF & EC2MDF Migration , How To