Automation for Inventory data reconcilation b/w ECC and BW report

[Former Member]

Hi,

I need your help in the below requirement in inventory data reconciliation.

Actually the requirement is to automate the inventory data reconciliation between ECC and BW report.

So at present we used to reconcile the data manually between ECC(Using MB5B tcode based on company code or plant or date etc etc) and BW report using MS Excel by exporting the ECC MB5B data into excel and comparing the BW data using some formulas.

Now we got the request to automate this data reconciliation process. Could you please suggest how to automate the data reconciliation process between ECC data with BW report data.

Thanks a lot in advance.

Phani.

[Former Member]

At a previous customer we had a rather complex inventory model in BW (with snapshots etc). When we doubted the quality of our (delta-)data, we set up a parallel model where we:

• ran the 'stock init' programin ECC at 00:00:01
• dropped the DSO content of DSO X and the PSA of the stock init datasource
• did a full load of this stock init datasource towards this DSO X
• ran a BEx report on a multi that was on this DSO X and our 'real' stock cube. this query was a simple list of plant/material with 3 columns (stock in cube, stock in dso, difference) which helped us identify our issues