I work part-time as a student on a supply chain analytics team (we use SAP ECC R/3) and my boss wants to stop using TXT/CSV batch jobs. Instead, they want to move SAP tables and Z-transaction data directly into a middle layer in SQL Server for reporting in Power BI and Excel. Right now, a colleague is copying the most important raw tables into SQL Server daily using the .NET connector. The issue is that the entire SCM department needs the Z-transactions, which have special business logic built on top of the raw SAP tables. Is it smart and viable to just copy the raw data from SAP into SQL Server and rebuild all the Z-transaction logic there, or is there a better, more efficient approach? submitted by /u/Inventador200_4 [link] [comments]