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.
- Swap the row and Axes
- Download data in excel which shows all columns and Rows
- Manually override the setting on the browser link
- Update Target mapping on the tile
Swap The Rows And Columns
Swap the rows and Columns by selecting settings > Swap Axes
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
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
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
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
Refer OSS note which talks about the same issue.
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