Starting Situation
You use a flexible function to determine a specific plan quantity can be determined through the template. Example: the material transport from inventory to production site in a new plant is a source of overhead costs, which until now have been calculated only on a percentage basis. The template is to assign an exact measure of overhead cost in this scenario. The process driver for this is the number of pallet movements for a certain production lot size, so the template is to calculate the number based on the production lot size. In this example, remember the larger production components require more pallet movements than smaller ones. Also keep in mind that a pallet movement is necessary even if only one component is required.
The following data is assumed to be created. The information in parentheses is for the data required by IDES.
Procedure
Prerequisites
You have created an algorithm that calculates the number of pallet movements needed. It does the following:
The end result is the number of pallet movements necessary for a component of the BOM.
This algorithm is now entered as the quantity formula of the template.
If the alternative unit of measure has not been maintained, then do this next. This unit of measure must be the same for all components of the BOMs. In the following example, we create it for one component only: namely, material r-4001.
To view the alternative unit of measure in IDES only, then see "Alternative Unit of Measure in IDES".
Entry of Alternative Unit of measures
Results of this Step
The alternative unit of measure has been created. The IDES example indicates the unit PAL (pallets). Column Y indicates the conversion factor "basis units of measure - alternative unit measure", which is the number of pieces per pallet in the example.
In the next step, enter the quantity formula from the algorithm into the column Quantity Plan in the template.
Enter Quantity Formula
If you wish to only view the alternative unit of measure in IDES, see "Alternative Unit of Measure in IDES".
This function totals the necessary pallet movements of all BOM items.
This function rounds up the result to the next whole number.
This function provides you with the required quantity per BOM item; in the IDES example, you are provided with the number of pieces per BOM item (lot size x number of pieces per BOM item).
This function provides you with the factor, which the result "lot size x number of pieces of the BOM components" will be divided by.
Result
The quantity formula is now as follows:
CEIL (BOM_ITEM_REQUIRED_QUANTITY / ALT_QTY_FACTOR_FROM_MATERIAL (MATERIAL_NUMBER = BOM_ITEM_COMPONENTS , ALTERNATIVE_QUANTITY_UNIT = `PALī ).
Viewing The Alternative Unit of Measure in IDES
In column AME you can see the alternative unit of measure (PAL), and in column Y the conversion factor.
Viewing The Quantity Formula in IDES
Here you see the entire quantity formula. Leave the function without saving.
Checking and Testing Templates
You are either on the Create template or Change template screen. To check the syntax of your entries, choose Template -> Check or .
Follow these steps to test the template:
IDES produces these results with the following entries in TOTAL_ORDER_QUANTITY:
Entries in TOTAL_ORDER_QUANTITY |
Results (pallet movements) |
1 |
7 |
10 |
8 |
50 |
14 |
100 |
22 |
1000 |
187 |
The results can be clarified as follows:
Seven components belong to material r-4050. The SAP system uses this calculation for the pallet movements.
Lot size (= Entry in TOTAL_ORDER_QUANTITY) * piece per material r-4050 / factor of the alternative unit of measure (piece per pallet). The result is rounded up to the next whole number. With a 100 piece order of material R-4050, the following results are obtained:
Material number |
Quantity per material r-4050 |
Factor of the alternative unit of measure (= pieces per pallet) |
Pallet movements |
r-4001. |
1 |
200 |
1 |
r-4002. |
4 |
12.000 |
1 |
r-4003. |
1 |
60 |
2 |
r-4004. |
1 |
8 |
13 |
r-4005. |
1 |
160 |
1 |
r-4006. |
1 |
160 |
1 |
r-4007. |
1 |
40 |
3 |
Total pallet movements |
22 |
Template Evaluation
To see more details, double click on the Quantity row. You receive the following information:
Formula/Method: place holder for the name of the function.
Function List: the system informs you that this function works with a flexible function ($1). The parameters of the function are listed (all are "invisible"). The last row shows the results of the calculation: 22 pallet movements.
Result: display total results (22).
Field content: the system shows, for example, the material number you entered.
Template Evaluation - Details
To see the calculation results, use the button Quantity Flexible Function and choose the defaulted function. The system returns the same information as in the above table: Field content shows the "Material number", Function list shows the "Factor of the alternative unit of measure", and Results shows the "Palette movements".