Question:
Hi,
We are loading some custom data from R3 to BW and there is no history in R3.. We would like to track all the changed to these tables in BW.
I know we can use time dependent master data for this .. which is what we are going to use..
but i was wondering if there are other ways to do this.. like looking at the change log in the ODS or something..
Please share your experiences
Thanks
Answer:
Dear chalasani
I agree that the time dependent master data is the best available solution.
Based on your question, I assume you are planning to bring custom master data in to BW.
Your other option was to use ODS Change Log table to track these changes.
In 3.0 you can load the master data in to ODS, but I never suggest using Change Log for reporting. If the data volume is small and it is very critical you can do so.
The other best option to write some kind of ABAP in R/3 itself. I don't know whether that is a option for you.
Thanks
Damodar
Answer:
Thanks for your thoughts.. i have thought of all of those and doing it in R3 is not an option and that is why we are looking at BW to do that.