SAP Knowledge Base Article - Public

3562801 - Delimiter issue in the downloaded PH reports - SAP S/4HANA Cloud Public Edition

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.

  1. Change the delimiter setting from comma (,) to vertical bar (|) in App Define Statutory Reports.

    ...



  2. Generate the report.
  3. Change the file name from "PH_CAS_PJ.csv" to "PH_CAS_PJ.txt".
  4. Open a new Excel and open the file "PH_CAS_PJ.txt".




  5. Change the delimiter settings in Text Import Wizard.




  6. Click Don't Convert in the Excel.

  7. 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

SAP S/4HANA Cloud Public Edition all versions

Attachments

Pasted image.png
Pasted image.png
Pasted image.png