We have a requirement to aggregate the data in Technical week based on more No.of day in a Technical

[Venky038]

HI All,

We have a requirement to aggregate the data in technical week, based on more No.of day in a Technical week data should fall  into that week either TWA or TWb.

The req is to have entire Supply allocation sent and saved into appropriate tech WK, the correct tech WK should be determined by understanding which qtr that week should fall in …if there are more number of days in old QTR , then it should go into Twa.. If there are more days in the New QTR, then it should go into TWb..

Supply planning  KF@PERPRODLOCMKT ,  Planning Level - Daily

Demand Planning KF@PERPRODLOCMKT,  Planning Level - Tech week level.

Regards - Venkatesh

[vincentverheyen]

Hi @Venky038, please review Help Potal > SAP6 Sample Planning Area for Demand > Time Profile > WEEKOFQUARTER and MONTHOFQUARTER:

In case the [...] is split across two [...] it needs to be assigned to the [...] to which more days belong to.

---

Perhaps, this can be inspiration in order for you to define your own custom Time Attribute XYZ, in your Time Profile, you can then maintain the values, by manually (or via an Excel calculation / algorithm) inspecting once in which Technical Week you would like to add the values (you mentioned you are interested in the Technical Week A or B which holds the most days in a ...). After you have determined the appropriate Technical Week via your algorithm, then go ahead and mark/hardcode all the appropriate Technical Weeks for example by maintaining value 1 in your custom Time Attribute XYZ in the Time Profile.

Later, in your Key Figure calculation you can use this Time Attribute in your Key Figure formula. Disaggregation then (or making sure the values are shifted towards the Technical Weeks which have value 1 maintained for your Time Attribute XYZ), you can do, by using a Copy Operator which reads for example on Month or Quarter level, and playing with the Disaggregation settings of the Target Key Figure to only Disaggregate to those values 1 (Note: I always prefer Disaggregation using a Copy Operator, instead of using Disaggregation via Calculated Key Figure split only, since otherwise you end up getting decimals and losing or gaining values, whereas the HANA Disaggregation Engine keeps the totals equal).

Please let me know if it can help, and if not feel free to ask a follow-up question and/or clarify with an exact example and intended outcome.