SAP Knowledge Base Article - Public

3305190 - Balance Sheet/ Income Statement- Multidimensional Column design

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

  1. Enter the mandatory fields in the filter section to generate the multidimensional report.
  2. From the dimensions section include the field G/L Account to row axis.
  3. 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.

  1. Select the G/L Account row.
  2. Press the Display button to get the drop down.
  3. From the dropdown menu select Non-Compound ID and Description.
  4. 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

Product

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