on 01-24-2016 3:01 PM
Hi,
How can I bucket the sales order as per the requested delivery date or commit date in DP planning book.
Any suggestions/alternatives in this regard would be helpful.
Thanks
Vijay
Hi Vijay,
You can extract the sales data into infocube, where you fill 0CALYEAR, 0CALMONTH, or 0CALDAY according to the periodicity you want to load the data into DP (e.g., if you want to load sales data into DP in weekly period, you fill the infocube's 0CALWEEK characteristic according to requested delivery date or commit date).
Then you can use /sapapo/tscube to load the data into DP time series.
BR, Ada
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Vijay,
I don't really understand your question. In DP, you are generally not very interested in each sales order, you are interested in summary data. If you really want reporting by individual Sales Orders, you should rethink whether DP is the best tool for the job.
In some implementations I have seen, there is a Key Figure for Quantity by Request date, and another Key figure for Quantity by Commit Date. The periodicity of the Storage Bucket Profile determines how the data is aggregated in time ("bucketed").
Best Regards,
DB49
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
4 | |
3 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.