Symptom
In the App Balance Sheet / Income Statement - Multidimensional, there is a column of GL account which shows value as COA/GL Account in a single column and user wants 2 different columns for it. In one Column COA should flow and another column GL Account should flow.
"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
- Enter the mandatory fields in the filter section to generate the multidimensional report.
- From the dimensions section include the field G/L Account to row axis.
- The G/L Account row axis is representing as COA/GL ACCOUNT and Description.
Resolution
Remove the compound value for the row G/L Account by following the below given steps.
- Select the G/L Account row.
- Press the Display button to get the drop down.
- From the dropdown menu select Non-Compound ID and Description.
- Now from the dimensions tab include chart of accounts to row axis.
(Non-compound ID and Description is selected so it is appearing as faded).
Keywords
W0161, Balance Sheet/ Income Statement, COA/GL Account, single column, row, 2 different column, row, S4_PC , KBA , FI-FIO-GL-IS , Reporting Apps , FI-FIO-GL-IS-2CL , Reporting Apps (Public Cloud) , How To