We are currently in the design phase of brownfield S/4HANA implementation project. The existing Analytics and reporting lanscape does not use standard SAP products, but instead many SAP ECC tables are replicated to a non-SAP data lake using Informatica and continue to be used for DWH and other purposes. We know that many tables are eliminated in S/4HANA, so our goal is to ensure continuity of analytics. We have identified many different scenarios: 1. Table exists in ECC but not in S4 - the alternative table/view provided by SAP; 2. Table exists in ECC but not in S4 - the impact of missing table where alternative table/view is not suggested by SAP. 3. Table exists in S4 but field is missing - the alternative field provided by SAP and etc.
In order to reduce the efforts of integration, DWH and reporting teams as much as possible, we want to replace all eliminated, adjusted tables with CDS views by reusing replacement/compatibility views where possible or creating custom ones. Finally all views will be exposed via OPD framework. What risks do you see when choosing this approach? maybe there are other better alternatives?