Skip to Content
Former Member
Jan 16, 2006 at 10:41 PM

Reporting on Master data Good ?


Hello BW Experts,

We have a scenario to report customer balances and payments. The feed is from a non-sap system. Changes(delta) comes to BW every weekend. There are about 1 M customers. We have customer master and also a zcustamt ODS. A report is needed to view the customers for a couple of company codes with the balances and payments.

we have 2 possible solutions

1) create the report on the zcustomer infobject

2) use the ODS to report

Wondering how efficient is to report on Infobject when we have 1M customers. In case we go for ODS. Then we are creating copy of the same data and we have to make sure that these are not inconsistent.

What would be the best way to model this scenario?