We have an "SAP S/4HANA On-Premise" connection in SAP DataSphere with the DP Agent and we want to use the standard ABAP CDS View "CSDBILDOCITMBDX1" for Billing and Delta capabilities.
This CDS View has 3.919 records:
But when we create a remote table in SAP DataSphere and we "Load New Snapshot" we are only capable of fetch 800 records instead of 3.919:
Is there any system configuration or any limitation in SAP DataSphere in order to fetch all the data from an ABAP CDS View?
Best regards and thanks in advance! 🙂
I've fully replicated C_BILLINGDOCITEMBASICDEX_1 - CSDBILDOCITMBDX1 as remote table in Datasphere for just out of curiosity. I've seen that all data replicated fully. Remote Tables - Replicated (Snapshot) using HANA Smart Data Access (SDA). There might be some limitations around SDA but I could not find any!
You may try firstly using Data Integration Monitor - Data Replication - Start Replication - instead of running Load New Snapshot directly from Data Builder. Also you may Remove Replicated Data before trying again.
I'm sure you might already tested some other CDS Views from S/4HANA but you can test other CDS Views and see if the same limitations can be observed.
Hope it helps.