Hi Experts,
I am working on a BI Integrated Planning project. Product cost will be calculated in CO-PC. During cost roll-up system can pick material prices from any of 5 fields i.e. Standard price, Future Price and Planned price 1,2,3. I have a requirement to update the current material prices from purchase info records to one of the planned prices fields.
My initial solution was as follows:
1. To rely on the users to download the PIR or contract prices into Excel
2. Apply % uplift to the prices in Excel
3. Then use an ABAP to update the uplifted prices to the material master future or planned price fields.
However my client is not happy with this solution.
Another option I am looking at is:
1. Extract the prices from the PIR's into BW and then download to Excel s
2. Apply % uplift to the prices in Excel
3. Then use an ABAP to update uplifted prices to the material master future or planned price fields.
Is this feasible? If yes, how can I get the prices into BW.
Thanks in advance,
Milind