Hi,
We have a landscape that is S4 to BW4 (and reporting on Fiori/SAC/A4O) and I was trying to come up with a concrete strategy on when something should be done in S4 vs BW.
I've gone through a lot of online links that talk about this but a few of them are old and others are too vague. So let me ask this again.
The context is:
1. We have S4 and BW4 in scope.
2. The configs are all standard. Assume no customization.
3. No historical data to start with.
4. As data flows in, we need to make sure data archiving strategy is maintained as historical data starts growing.
Now the points I am considering are:
1. Finance and Sales especially have a lot of business content in both ABAP CDS and BW4.
2. Real-time reports can be run out of S4 directly or via connecting S4 CDS to Open ODS in BW
3. Modules like Procurement and manufacturing have a lot of BW content (and some in ABAP CDS)
4. Data archiving in this scenario would be best done in aDSOs in BW.
And for the hard part - deciding what can be built in BW4 vs S4 - My opinion
1. Any data flow with data archiving goes to BW (aDSO archiving)
2. Live data requirements developed in S4. If data from BW is required, build openODS on top of ABA CDS and then join/enrich with BW objects.
3. Data flows with large number transactions would be modeled in BW.
I would like to have your opinion on my thought process and it would be great if you could correct/add on to what I wrote down.
Regards,
Shyam