Symptom
For Report ID PH_CAS_SJ and PH_CAS_PJ, in the downloaded CSV file, if the address contains commas, excel will automatically split the address based on the commas, as shown in the example below. (The yellow part is supposed to be in one cell)
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
SAP S/4HANA Cloud Public Edition
Cause
Due to Excel's mechanism of automatically separating columns by commas, if there are commas in the Address, these parts will inevitably be allocated to different cells.
If simply change the delimiter from a comma (,) to a vertical bar (|) in the App Defined Statutory Reports, it still does not resolve this.
Resolution
Although the default format is TXT, if the customer insists on using CSV, we will recommend the following steps to achieve the correct display.
- Change the delimiter setting from comma (,) to vertical bar (|) in App Define Statutory Reports.
... - Generate the report.
- Change the file name from "PH_CAS_PJ.csv" to "PH_CAS_PJ.txt".
- Open a new Excel and open the file "PH_CAS_PJ.txt".
- Change the delimiter settings in Text Import Wizard.
- Click Don't Convert in the Excel.
- The address will displayed correctly.
See Also
SAP Help Portal Create a Report Category Extension
Keywords
PH, PH_CAS_SJ, PH_CAS_PJ, CSV, Excel, delimiter, comma, vertical bar, |. , KBA , FI-LOC-FI-PH , Philippines , Problem
Product
Attachments
Pasted image.png |
Pasted image.png |
Pasted image.png |