For one of our customers (who's migrating to S/4HANA Cloud), I'm looking into migrating one of their existing on-premise tools to the cloud as a side-by-side extension. The tool combines: material master data (general, plant, sales org, accounting data), purchasing info record data, vendor master data, sales pricing conditions (+/- 8-9 different conditions).
In their on-premise system, I built the tool using ABAP CDS which allows them to select about 80000 records in a matter of seconds and display them on the screen for mass editing / exporting to excel. (each field in the output is filterable from the selection screen in this case, since it's a single CDS entity that's being queried)
For the cloud development I'm looking at CAP for sure as a backend service for the future Fiori app. Given the amount of data and the number of API calls I would need to put together the resulting entity (and the fact that almost every field needs to be filterable), I'm looking for some recommendations.
Some potential solutions I see:
Any advice on how to proceed with this solution? Are there SAP-provided real-time replication solutions available between S/4HANA Cloud and SAP HANA Cloud for this purpose? (I did find some information about HANA Smart Data Integration, but it's not really clear to me if this is an option S/4HANA Cloud and HANA Cloud and if it's possible to replicate e.g. custom views)