SAP Knowledge Base Article - Public

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

Symptom

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.

Environment

SAP S/4HANA Cloud

Reproducing the Issue

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

2. Click Go

Export

3. Export

Excel

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

Cause

Standard Design

Resolution

1. When exporting to Excel use Export As

Export as

2. Select Split cells with Multiple Values.

split cells

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

Excel split

Keywords

 concatenate, concatenation, split cells, excel, export, Trial Balance, currency symbol, F0996 , KBA , FI-FIO-GL-IS , Reporting Apps , How To

Product

SAP S/4HANA Cloud all versions