SAP Knowledge Base Article - Preview

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

Symptom

  • 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.


Read more...

Environment

SAP S/4HANA 2023
CDS Embedded Analytics

Product

SAP S/4HANA Foundation 2022

Keywords

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-ODP , Query Runtime for Operational Data Provisioning , BW-RUI-FPM , FPM Analytical GUIBB , BW-BEX-OT-DBIF , Interface to Database , BI-RA-AO-XLA , Excel Addin , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.