Lecture 9 Input Schedules

In this lecture, we will build an input schedule, the Detailed Price Planning Input Schedule, step by step. We will perform the following steps:

·       Create an Aggregation Level

·       Create a Filter

·       Create an Input Ready Query

·       Insert the Query into a BoA workbook and

·       Plan some values

All the other input schedules and their settings can be below.

Configuration Steps for Scenario ‘Input Schedules’:

Aggregated Planning material/ProdHier

Create Filter ZPRM01_01_F02 

Set the following restrictions:

0CUST_GROUP: #

0FISCVARNT: K4

0INCOTERMS: #

0INFOPROV: ZPRC01

0KAPPL: V

0KSCHL: K005, PR00

0MATERIAL: #

0MATL_GROUP: #

0SALES_OFF: #

0SOLD_TO: #

CRECTYP: B

0CURTYPE: Variable, single value, mandatory

0VERSION: Variable, single value, mandatory

0VTYPE: Variable, single value, mandatory

Set other variables as you deem necessary, for example, the final filter can appear as follows:

Create Query ZPRM01_01_Q0003 - Sales Price Planning: Product Hierarchy

Add the filter created above to Characteristic Restrictions

Define Rows and Columns as below:

Activate Hierarchy Display, For Product Hierarchy:

Fiscal Year/period:

Extended Settings to Master Data

Set 0Amount Input Ready:

Set the query to Input Ready

Price Increase by Material Group

This query will allow us to plan/adjust prices on Material Group Level. In the previous step we used a filter to restrict the values to a particular intersection, explicitly using # (unassigned) to represent an aggregated intersection. For Price Increases, we will use a new aggregation level:

Create Aggregation level ZPRM01_03 - Price Inc Planning 

Create Filter ZPRM01_03_F01 - Price Increase on Material Group

Set the following restrictions:

0FISCVARNT: K4

0INCOTERMS: #

0INFOPROV: ZPRC01

0KSCHL: PR00

CRECTYP: A

0VERSION: Variable, single value, mandatory

0VTYPE: Variable, single value, mandatory

Set other variables as you deem necessary, for example, the final filter can appear as follows:

Create Query CPRM01_03_Q0001 - Price Increase by Material Group

Use the filter above as the characteristic restriction.

Set the rows and columns as follows:

Fiscal Year/period and Material Group:

Extended Settings to Master Data

Set price increase to Input Ready

Set Query to Input ready

Plan Material Prices

We will restrict planning of process to materials only in this query. For that, we will also create a new aggregation level.

Create Aggregation level ZPRM01_04 - Plan Material Prices

Create Filter ZPRM01_04_F01- Plan Material Prices

Set the following restrictions:
0FISCVARNT: K4
0INCOTERMS: #
0INFOPROV: ZPRC01
0KAPPL: V
RECTYP: A
0VERSION: Variable, single value, mandatory
0VTYPE: Variable, single value, mandatory

Set other variables as you deem necessary, for example, the final filter can appear as follows:

Create Query CPRM01_04_Q0001 – Plan Material Prices

Use the filter above as the characteristic restriction.

Set the rows and columns as follows:

Fiscal Year/period:

Extended Settings to Master Data

Set 0AMOUNT and LOTSIZE to Input Ready

Set Query to Input ready: