SAP Fiori S/4 HANA Rows & Columns Limit

Introduction-S/4 Hana Rows And Columns Limit

In this blog, we will discuss SAP Fiori S/4 HANA Rows & Columns. S/4 Hana Fiori Apps have a restriction on the amount of data retrieved from the server. It has a limit on the number of rows and columns being shown on the app. This article discusses how to resolve this issue as a workaround and create an app setting that shows all rows and columns. By default, the setting on any Fiori app is to show.

  • Rows restricted to 10000
  • Columns restricted to 50

If there are apps that require more than 50 columns, it will not be shown, and this article talks about how to find the right way to bring that additional column on the app. Some of the options provided to resolve this issue is as below. Please read on to find more.

  1. Swap the row and Axes.
  2. Download data in Excel which shows all columns and Rows
  3. Manually override the setting on the browser link
  4. Update Target mapping on the tile

Swap The Rows And Columns: SAP Fiori S/4 HANA Rows & Columns

Swap the rows and Columns by selecting settings > Swap Axes

SAP Fiori S/4 HANA Rows & Columns Limit

This would then show the number of columns that were more than 50 as rows however, note that you can now only see upto 50 records

SAP Fiori S/4 HANA Rows & Columns Limit

Download Data In Excel The S/4 Hana Rows And Column Limit

Furthermore, Shows below option where the data can be downloaded to Excel and in download, there is no limit on the number of rows and columns being shown

SAP Fiori S/4 HANA Rows & Columns Limit

Update Browser Link

Moreover, Use the link below updated with rows and columns mentioned as being equal to -1, which helps to show all records in the system.

So the link of your Fiori App should be appended by this text  &XDATALIMIT_ROWS=-1&XDATALIMIT_COLS=-1.

SAP Fiori S/4 HANA Rows & Columns Limit

 

Furthermore, The above workaround would need to be done every time the app is loaded. If you are looking for a fix that works every time the app loads automatically, then use the Custom Tile app to create a new tile that has the same link as the original and append it with the below Hash.

AnalyticQuery-analyze?XQUERY=&XSYSTEM=LOCAL&XDATALIMIT_ROWS=-1&XDATALIMIT_COLS=-1

Additionally, Refer OSS note which talks about the same issue.

2557541 – Configuration of the amount of data to retrieve from server

Conclusion: SAP Fiori S/4 HANA Rows & Columns

So to summarize, follow the steps to understand how to update the URL parameters or create a new tile with the updated URL parameter to fetch all of the data from the server without the restriction of only returning a limited number of rows and columns.

Get In Touch If You Have A Business Query

Related Posts