SAP Knowledge Base Article - Public

3355859 - Concatenation of amount and currency in exported excel for app Trial Balance

Symptom

Amount and Currency are shown in single field for exported excel from app Trial Balance.

"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, fill in selections and click Go.
  2. Export data to excel.

Cause

Standard Design

Resolution

  1. When exporting to Excel use Export As

           

    2. Select Split cells with multiple values.

         

Keywords

Trial Balance, Concatenation, export, excel, amount currency. , KBA , FI-FIO-GL-IS-2CL , Reporting Apps (Public Cloud) , Problem

Product

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions