Skip to Content
0
Aug 08, 2016 at 07:49 AM

Integrated report/data on two BPC models

136 Views

dear all,

I have a requirement where I need to integrate data of two BPC models where I dont have any common dimension as of now.

These two models cater different businesses where Product/Material in XX model is represented as Material code in XY model

Product(in XX model) Material code(in XY model)

RTG 300000852

RFF AYYPH

And so on

As these two models cater to differ businesses I need to create a report displaying the qty/amt n one business (XX model) and the same qty/amt should be received by other business(XY model).

Product(in XX model) Qty(XX model) Material code(in XY model) Qty(XY model)

RTG 100 300000852 100

RFF 59 AYYPH 59

Please suggest if I can achieve this by maintaining property Material code in Product & material dimensions in XX model, but again the challenge will be how can I build a dynamic BPC report on these two models.

Also I thought of maintaining a table where I can maintain mapping between Product/material with Material codes and plant codes but in this case again how can I build bpc report showing the integrated data.

Any suggestions please.

Thanks,

Ambika