3658248 - Custom OData Service Limited to Maximum of 5000 Records Per Fetch

• Custom OData service is limited to a maximum of 5000 records per fetch.
• When retrieving data from a custom OData API, the maximum number of records returned per fetch is limited to 5000.

SAP S/4HANA Cloud Public Edition

It is not possible to retrieve large volumes of records beyond the server-side $top limit of 5000 through a custom API, this limit cannot be increased.

The only viable option is to consume the OData API using pagination parameters such as with $top/$skip/$count parameters or with splitting the data using filters or the pagination concept 

• Using OData's $top, $skip and $count
• 2688637 - How to add filter for the results while consuming a CDS view through OData service - SAP S/4HANA Cloud Public Edition

OData - skip, count issue - CommunityPost

odata service, record fetch limit, $top, $skip, pagination, sap s/4hana public cloud, custom api, cds view, performance optimization, data retrieval, filters, sap business application studio , KBA , CA-UI5-FL-ADP-BAS , SAPUI5 Adaptation Project for SAP BAS , Problem