Data Quality Comparison Report across Systems(MDM and BW)
I have a requirement of generating a Data comparison report in Excel using BODS. I need to extract data from SAP MDM and SAP BW and do a comparison on the record basis. For example.I take a material 100 record from MDM and same Material 100 record from SAP BW. I have to compare field by field values between these 2 systems.If there is any contingency,I have provide that record as output in Excel.
I think i need to create a batch job in BODS to run this requirement. Could you please tell me the approach of comparing the records in BODS and give the output of the record in Excel.
I really appreciate your help.