How do we handle the data replication from S/4HANA public cloud to BW on-premise? Is there a standard way to do this?
Also, are the data sources created under RSO2 replaced by creation of custom CDS views?
Have you already checked Best Practice 35D? https://me.sap.com/processnavigator/SolS/EARL_SolS-013/2308/SolP/35D?region=US
"Accelerate your virtual data model data extraction and replication to SAP BW/4HANA, SAP BW on SAP HANA, or other target applications from SAP S/4HANA Cloud using the Operational Data Provisioning (ODP) framework, supporting the delta mechanism for change data capture (CDC).
I hope this helps