3236786 - How to split the currency symbol and the amount column in the standard FI reports - SAP S/4HANA Cloud Public Edition

Currency amount and symbol are shown in single field when exported from App Trial Balance (App id F0996) to Excel.

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

SAP S/4HANA Cloud Public Edition

1. In App Trial Balance (App id F0996) selection

2. Click Go

3. Export

4. In this example Currency Amount and Symbol are not separated.

Standard Design

1. When exporting to Excel use Export As

2. Select Split cells with Multiple Values.

3. This will lead to the fact that combined columns are separated in Excel

concatenate, concatenation, split cells, excel, export, Trial Balance, currency symbol, F0996, amount, Balance Sheet/Income Statement - Multidimensional, W0161 , KBA , FI-FIO-GL-IS , Reporting Apps , FI-FIO-GL-IS-2CL , Reporting Apps (Public Cloud) , How To