We are working on bringing three tables from R/3. We have created a view on top of two tables (CKIS and CKHS) that is ZCKIS (detail). The other table we are bringing in is ZKEKO (header).
We brought these two tables into two separate cubes in BW. And created a Multi provider on top of that.
When these two tables are executed in R/3 they display the only the raw materials and semi finished goods under a particular Finished goods. How the relation works is the finished goods, semi finished goods and raw materials are in a single field MATNR. So in KEKO they show finished goods. In CKIS they show semi finished goods and raw materials. They Cost Estimate number is like a connection between these two tables.
When we bring all this value in BW it shows all the levels in both the component field and material field because both are pointing to MATNR in the Transfer rules. So using this Cost Estimate number is it possible to create an update or transfer routine so that the finished goods would just pick only the raw materials and semis used in producing that particular raw material. Can anything be done on the Bex reporting side.
IF somebody has experienced the same issue or if you guys have dealt with Product Costing please let us know if there is any other solution for this problem.