Rows and Column limit on Fiori Apps


Introduction-S/4 Hana Rows And Columns Limit

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. In this article we discuss how to resolve this issue as a workaround and also by creating 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 would not be shown and this article talks about how to find the right way to bring those 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

Swap the rows and Columns by selecting settings > Swap Axes

Graphical user interface Description automatically generated

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

Graphical user interface Description automatically generated

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

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

Graphical user interface Description automatically generated

Update Browser Link

Use the link as 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

Graphical user interface, application, Word Description automatically generated

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

Refer OSS note which talks about the same issue.

2557541 – Configuration of amount of data to retrieve from server

Conclusion

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.

Read the Full and original article posted below

SAP Fiori how to Display More rows and columns