This article talks about CRM Debugging and BOL Programming and...
Read MoreIn 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.
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.
Swap the rows and Columns by selecting settings > Swap Axes
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
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
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.
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
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.
This article talks about CRM Debugging and BOL Programming and...
Read MoreThis blog explains how to Control CRM UI elements to...
Read MoreUnderstand how to create SAP Custom Search help and Understand...
Read More