Symptom
PDF of financial statement can't display all columns data when using the app Balance Sheet / Income Statement. In other words, you can see Column “Period Balance”, ”Comparison Balance”, “Absolute Difference”, “Relative Difference” in the app, however, only "Period Balance" can be displayed in the PDF Preview.
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Run app Balance Sheet / Income Statement
- Input parameters via the filter bar and click Go
- Select "All accounts" tab (or "Balance Sheet"/"Profit &Loss") and click "Export to PDF" button
- A popup window is shown. Select "Show G/L accounts" and "OK"
- You can check the PDF Preview
Cause
Your table layout settings, unlike your app filter bar settings, are not applied to the PDF preview. The function of the PDF creation is not to print what the user has configured in the table in the app. The function here is that a pixel-perfect template is filled with the data, which the user has requested via the filter bar. That means that the filter settings have an impact on what is shown in the PDF, but the table layout is not taken into account. During the creation, the user can only decide, whether the accounts should be part of the PDF or not.
Resolution
This is a standard behavior. If you are more interested in the plain data instead of a predefined PDF, you should use the app “Balance Sheet/Income Statement – Multidimensional”(App ID F3084), where you can export the data to EXCEL.
Keywords
PDF, app Balance Sheet / Income Statement, "Period Balance", "Comparison Balance", "Absolute Difference", "Relative Difference", "Balance Sheet/Income Statement – Multidimensional", EXCEL. , KBA , FI-GL-IS , Information System , FI-FIO-GL , Fiori UI for General Ledger Accounting , FI-GL-IS-2CL , Information System (Public Cloud) , How To