Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Macro to Copy Average Demand into Safety Stock Key Figure

Hi Experts,

I need your help for creation of a macro to meet a requirement, stated below:

We are releasing Demand on daily bucket for a period of 3 months. We would like to maintain safety stock only for the period of 21st date fo the month to 30th day ( for each months, within the storage bucket). For doing this I need to calculate average demand of the month based on the Forecast of 20th of the month. My requirements are:

Step 1: Read the Forecast value for 20th day of the Month

Step 2: Calculate Average demand based on the Demand of 20th day

Step 3: Populate Average demand in the Safety Stock fey figure from 21st to 30th of the month. For other days safety Stock key figure value shall be populated according to the Product Master value.

I have created following Macro, but it is not serving my requirement. Could you please tell me where I am going wrong:

Former Member
Not what you were looking for? View more on this topic or Ask a question