Home‎ > ‎SAP PP / PPPI‎ > ‎SAP MRP‎ > ‎SAP SOP‎ > ‎

SAP SOP Creation of Macros for Planning Type

Study Material Contributed by Ulhas Kavle - Senior SAP Consultant

Macros in Flexible Planning


You can add mathematically formulas on the data pulled in from the information structure to arrive at the final values of a certain key figures through the use of macros. As an example, one can write macros for arriving at the production quantities as equal to the sales quantities or X % more or less than the production quantities. It should also be noted that the macros can only be written for the key figures. Normally macros are written to calculate/change the values of key figures, for example key figures like the production quantities, days’ supply, target days supply.


Macros can be run automatically in the planning table; for which they are used as “default macros”, “initial macros” and “final macros”. The Default macros are called during entry in the planning table, the Initial Macros are called at the start of planning in the planning table and the Final Macros are called at the end of planning in the planning table.


In level by level planning, SAP uses macros for aggregation and disaggregation functionalities, since they are not triggered automatically as in consistent planning methods.


Note – Creation of Macros is not a mandatory step, you can prefer not to have events at all in your planning situation.


Some of the standard SOP macros are shown in the screens below. You could use the same logic for deriving values for key figures such as production, stock level, and target day’s supply. If you observe the below figure/screenshots, the key figure called sales/day, zero stock level, are included in the planning type to behave as an intermediate variable for deriving the values of some other key figures. Such keys figures can be declared as Auxiliary key figures.


You should create macros in the planning type transaction; choose the path Macros > Create. After the creation of Macros, you can test them by entering values test values in the planning type for the key figures and then execute the macros so as to test them (path Macros > Execute)


Default Macros (S893_00001), as shown below, can be constructed for the planning table {also refer to the Standard SAP macros used in Planning type SOPKAPA (S076)}. The equations in the default macros come in to action real time in the planning table.


If you don’t set the display indicator, then the macros are executed at the point of time, they are supposed to run, though if the “display indicator” is set, you are left with a chance of executing them manually in the planning table, as and when you wish to.


In the example below for consistent planning, the production value is set at 10% more than the sales quantities, i.e., Sales Order Quantity * 1.10 = Production



 Fig – SOP_28


Note: “LO” = Stock of previous period + Receipts – Issues, “/” = divide as value, “*” = multiple as value


Examples of some more macros are shown below:


These below macros can be executed as default, initial or final macros or even they can be executed manually if they are not set in the planning type as default, initial or final macros.


a)      Production = Sales 


Fig – SOP_29


Note: “=V” = Copy From


b)      Production from target stock level


Fig – SOP_30



Note: “L1” = Receipts based on target stock level = Target stock + Stock Previous Period – Issues



c)      Production from target day’s Supply



Fig – SOP_31



Note: “/” = divide as value, “*” = multiple as value


d)     Production from Zero Stock



Fig – SOP_32



Follow the topics for SAP SOP in the sequence Mentioned Below