Hi All,
I need to capture data in the following format I have data of Deliveries Qty by Plant & Material Type in DeliveredQty. The DeliveredQty is the delivqty as of a given date. I need to based on the DeliveredQty calculate the DelivQtyMonth. So if the DelivQty as of today (3rd July) is 1000 EA for 3 days in the current month. The user will provide as input the remaining working days in the month and the number of days in the month elapsed.
I need to calculate the DelvQtyMonth as follows = DeliveredQty + DeliveredQty/DaysElapsed * DaysRemaining
The user wants to enter the DaysElapsed and the DaysRemaining in variables.
Then I need to display the data in the following format:
Plant MaterialType DeliveredQty DelvQtyMonth ManualDelvQty
All data is display only columns except for ManualDelvQty which I should provide for user to input data to this column.
So far I have done the following:
I have created a realtime plan cube with plant materialtype DeliveredQty in it a planning area, planning level, package and a manual planning layot on top of this planning area.
Can you kindly share your inputs how I can implement the DelvQtyMonth which is calcuated based on a variable at run time and ManualDelvQty.
How can I implement the above scenario in BW BPS for capturing the above data.
I have data for plant materialtype Delivqty for a given fiscal year period in the actuals delivery cube. How can I copy this into the plan cube within BW BPS.
Also, how do I implement the variables for DaysElapsed and DaysRemaining for the user to input values to it in BW BPS.
Your help is greatly appreciated.
Thanks
Karen