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.