SAP Knowledge Base Article - Public

3562801 - Delimiter issue in downloaded PH reports

Symptom

For Report IDs PH_CAS_SJ and PH_CAS_PJ, when downloading the CSV file, Excel automatically splits the address fields where there are commas. As shown in the example below, the yellow section should remain in a single 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 default mechanism of using commas to separate columns, any commas present in the address field will result in the content being split into multiple cells.

Changing the delimiter from a comma (,) to a vertical bar (|) in the app Define Statutory Reports will not fully address this issue.

Resolution

While the default format is TXT, if the customer prefers using CSV, we recommend the following steps to ensure correct display.

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