SAP Knowledge Base Article - Preview

3606182 - Columns are Mixed in CSV Format of Philippines DRC Reports

Symptom

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

When download the generated CSV files by the below reports, if the address contains commas:

Philippines Computerized Accounting System - General Ledger (PH_CAS_GL) report

Philippines Computerized Accounting System - Sales Journal (PH_CAS_SJ) report

Philippines Computerized Accounting System - General Journal (PH_CAS_GJ) report

Philippines Computerized Accounting System - Purchase Journal (PH_CAS_PJ) report

Philippines Computerized Accounting System - Cash Disbursement Journal (PH_CAS_CDJ) report

Philippines Computerized Accounting System - Cash Receipt Journal (PH_CAS_CRJ) report

Microsoft 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)


Read more...

Environment

  • SAP S/4HANA 
  • SAP S/4HANA Finance

Product

SAP S/4HANA Finance all versions ; SAP S/4HANA all versions

Keywords

Philippines CAS report, CSV, Excel, delimiter, comma, column; Philippines DRC Reports , KBA , FI-LOC-FI-PH , Philippines , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.