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 · Accepted solution]

Dear,

I can give you some idea about this...Like you are doing this manually so stuff to choose for you is MB5B where you are extracting data based on plant level OR company code level and comparing that from data (extracting from BW) within BW.

I am sure when you are comparing then there must be some KPI's OR key figures that you are comparing one from another. You might want to have some kind of Z....report to achieve this...using ABAP.

- List out common fields which you want to have in Z...report like plant, company code, material, storage location, etc..and key figures on which you are comparing..like total unrestricted quantity total OR etc to do the reconciliation.

- Create one Z. program in BW....program must proceed with some selections like which parameters to choose in order to pick data to reconcile..You might want to add a parameter for request no., so pick data based on request no. from respective DSO OR based on free selection like based on material OR based on plant OR company code and then go for same selection to pick data from ECC.

- You would need to write some RFC function modules to communicate with ECC and fetch same set of data from ECC. Data will be fetched from respective tables which push data to MB5B.

- Now once you have set of records both from ECC and BW within BW. You can write logic to compare one vs other for all key figures that you want in Z... program.

I can also think of a virtual cube which will fetch data from ECC and will compare from Cube in BW where your inventory data is sitting with the help of MPRO (bring both cubes one from ECC and one in BW in MPRO) and comapre...? Try to see some blogs online and this will give you some hint as how to achieve this.

Thanks & Regards,

M

[mahereddy13 · Accepted solution]

Did anyone implemented this solution successfully.please let me know the steps.