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

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

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

https://peritossolutions.com/sap/s-4-hana/sap-fiori-s-4-hana-rows-and-column-limit/