Supply KFs at Day Level

[former_member591592]

Hello Experts,

We are working on S&OP project where in we have requirement to see supply planning key figures at Day Level.

as per standard we have supply related KF's at weekly level. how do we achieve supply planning results at day level?

one way i tried is created equivalent key figures ( for net demand,receipts,transport receipts etc) at day level and using dis aggregation operator to split values from week to day level. is there any other way we can do this? also how lead time would be managed in this case, for ex my lead time is 5 days, and as per standard the lead time is expressed as number of periods in base planning level of KF( week in this case). so how can i map my lead time to achieve the result in day level.

Any suggestion on above request will be very helpful.

Thanks for the time.

[ankpatel · Accepted solution]

Hi Matt,

Please check Time Aggregation, but it has some limitations on Customer Transport and Production lead time. Also, I would suggest not to change the Base Planning level of input key figures to Supply, as you don't know what is hardcoded in the backend.

Regards

Ankur

[gurucharanscm]

Hi Matt -

I am re-reading you comments again, you stated you created different key-figures but with day periodicity and kept the original key-figures the way they are - meaning, the standard KFs are kept at week periodicity (their planning level)? I think this is the reason for the lead time not being considered at day level. I presumed you changed the existing key-figures' periodicity.

Thanks,

Regards - Guru

[former_member591592]

thanks Guru, sorry for coming back late. yes i created equivalent new KF at day level without altering the existing ones. but this has the limitation of lead times. since i want system to consider lead time in days so guess i need to change existing supply KF from week to day level. that will consider my lead time in days .

also is it advisable to change standard supply KF from week to day? as i can see there are some calculations which needs to be changed accordingly.

for ex see totalreceipt kf. in its calculation we can see one calculation as TOTALRECEIPT@DAYPRIDLOC= "TOTALRECEIPTS@CALWKPRODLCOC/7. the base planning level of this KF is WKPRODLOC. in above calculation we are getting values at day level BUT how can we see that in excel as our BPL is in week?

Regards,

Matt

[gurucharanscm]

Hi Matt - In the operators app, you should be able to see time profile level. It is here where you should be able to define the periodicyt of the Heuristic. See if you can give 'day' periodicity here (sorry, i am not able to test currently),

However, I think I am pretty sure the lead time will be in 'days' if your lowest periodicity of the planning area is 'Day' irrespective of your level in the operator section (you may choose to have it blank).

Thanks,

Regards - Guru

[former_member591592]

Hi Guru,

In the operator i can see time profile options from week on wards. it has blank option as well.

also when i am currently maintaining lead time in Location Source MDT the system is giving result based on week level.

[gurucharanscm]

Hi Matt - you might have to just change the BPL for each key-figure where you need day periodicity. Meaning, at planning area level, you should have day periodicity as well - if you copied SAP4 planning area, you need to have this periodicity manually. Once this is maintianed, the lead time you maintain in your master data considers the lowest periodicity of your planning area.

Please also note you can assign the time profile in the heuristic forcing the algorithm to run on a specific periodicity. But I am not sure how the lead time behaves in this case - does it still consider the day periodicity or does it consider the level you maintained in your time profile in your Heuristic parameter section - please check and confirm.

Thanks,

Regards - Guru

[former_member591592]

Hi Guru,

Thanks for your reply.

I am using unified PA. all the supply related KF's are at Week level. i created equivalent KF's at DAY level and used dis aggregation operator to get values from Week to Day Level.

i don't understand how we can force heuristic to run at specific periodicity? when i see my S&OP operator profile for heuristic, i can see minimum level as week. can you elaborate on how you can drive hueristic to run at any periodicity?

[Former Member]

Dear Matt,

I have a similar requirement in my project. We change all the planning levels to week from day. Was the better way that I found.

Best regards,

Lorena

[former_member591592]

Thanks Lorena,

is it running as per expectation when changing from Week to Day? did you change all supply related KF to day level?

Regards,

Matt