1
Setup Macros for Planning Book YDP_PB_MASS_JOB and
Data View YDP_DV_FCST
Procedure
1
Access the activity, use one of the following navigation options:
SAP SCM menu
Advanced Planning and Optimization Demand
Planning Environment Current settings Macro
Workbench
Transaction code
/SAPAPO/ADVM
Choosethe row of planning book: YDP_PB_MASS_JOB and data view YPD_DV_FCST
Macro: Initial val: calc to corr hist sales
Use
Calculate key figure Corrected Sales History, It equals to Historical Sales Override if this key figure is not
initial, otherwise, it equals Historical Sales without additional demand minus Historical Sales Correction.
Procedure
1
Right-click the macro node below the planning table and choose Create New Macro
Add macro. In the APO Macro Builder dialog box, enter a descriptive text for the macro,
Initial val: calc to corr hist sales. Choose Continue.
Right-click the macro and choose Add macro Element Step.
In the APO Macro Builder dialog box, in the descriptive text section, enter a name for the macro step,
for example, First Step, choose Past in Processing Area, and choose Continue.
Right-click the macro step and choose Add Element (Result Level) Add control
statement.
In the APO Macro Builder dialog box, choose IF. Choose Continue.
Right-click the result row you have just created and choose
Add Element (Result Level) Append Condition.
In the APO Macro Builder dialog box, input Description Sales override = Initial, and choose
Continue.
Right-click the operator/function you have just created and choose
Add Element (Argument Level) Add Operator/Function. In the APO Macro Builder
dialog box, choose IS_INITIAL(. Choose Continue.
Right-click the operator/function you have just created and choose
Add Element (Argument Level) Planning Table Element Append argument row.
In the APO Macro Builder dialog box, choose Historical Sales Override in the Row field, and
Row Attributes in Data field in the part of Data Source: Value or Row/Column Attributes.
Choose Continue.
Right-click the argument row you have just created and choose
Add Element (Argument Element) Append Operator/Function.
In the APO Macro Builder dialog box, choose ) = 1. Choose Continue.
10
11
12
13
14
15
16
17
Right-click the condition you have created in step 4 and choose
Add Element (Result Level) Planning Table Element Append result row. In the
APO Macro Builder dialog box choose Corrected Sales History in the Row field. Choose
Adopt.
Right-click the result row you have just created and choose
Add Element (Argument Level) Planning Table Element Add argument row. In
the APO Macro Builder dialog box, choose Historical Sales without additional demand in the
Row field. Choose Continue.
Right-click the operator/function you have just created and choose
Add Element (Argument Element) Append Operator/Function.
In the APO Macro Builder dialog box, choose +.Choose Continue.
Right-click the operator/function you have just created and choose
Add Element (Argument Element) Planning Table Element Append argument
row. In the APO Macro Builder dialog box, choose Historical Sales Correction in the Row
field. Choose Continue.
Right-click the result row you have created in step 8 and choose
Add Element (Result Level) Append Control Statement.
In the APO Macro Builder dialog box, choose ELSE and choose Continue.
Right-click the control statement you have just created and choose
Add Element (Result Level) Planning Table Element Append result row. In the
APO Macro Builder dialog box choose Corrected Sales History in the Row field. Choose
Adopt.
Right-click the result row you have just created and choose
Add Element (Argument Level) Planning Table Element Append argument row.
In the APO Macro Builder dialog box, choose Historical Sales Override in the Row field.
Choose Continue.
Right-click the result row you have created in step 13 and choose
Add Element (Result Level) Append Control Statement.
In the APO Macro Builder dialog box, choose ENDIF and choose Continue.
Select the macro and choose Check to check it. Generate the macro by choosing Generate.
If you want to continue with the configuration, proceed with the next activity to create the
next macro.
If you want to discontinue the configuration at this point, we recommend that you save your
settings.
Result
