Sales Order Date in DP Planning Book

[Former Member]

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

[former_member187488]

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

[Former Member]

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