3480546 - Fiori App Query Browser/ Web Dynpro Report: Result is limited to 40 000 lines

• When running a CDS report or exporting such report as .xlsx, the result is limited to 40 000 lines (while more data is available in the query).
• When importing data from CDS query into SAC, using Import Data connection - only 40 000 rows are imported (while more data is available in the query).
• When executing CDS query in the backend transaction RSRT - only 40 000 rows of data are shown in the Result Set (while more data is available in the query).
• The similar symptom also happens in Analysis for Office(AO, AfO), which is also documented in KBA 3513186.

SAP S/4HANA 2023
CDS Embedded Analytics

export, .xlsx, 40000, limit, size, result, import connection, importing CDS to SAC, 40000 rows, less data imported, less data exported , KBA , BW-BEX-OT-BICS-PROV , BICS Provider/RSBOLAP , BW-BEX-OT-DBIF , Interface to Database , BI-RA-AO-XLA , Excel Addin , BW-BEX-OT-ODP , Query Runtime for Operational Data Provisioning , BW-RUI-FPM , FPM Analytical GUIBB , Problem