Skip to main content

Celonis Product Documentation

Updating the Business Logic

The business logic is packaged into formulae (KM KPIs) to reuse in the different parts of the app or inside of other KPIs/formulae to make the setup more concise.

These PQL-statements define the calculations of KPIs, filter statements on your data, and inefficiencies. Hence they are one of the most important parts of the app.

To give you an example, the formula KPI_MATERIAL_CALC_ACTUAL_PURCHASE_LEAD_TIME is used both for evaluating purchase orders as well as for computing related planning parameters (e.g., Recommended Purchase Lead Time, Recommended Safety Stock, etc.). So by adjusting the underlying business logic in that one place, you adjust the business logic for all KPIs and related definitions at once.

This list is not exhaustive and should be checked inside of the Knowledge Model. Make sure to also check nested formulas that might be used within the listed KPIs below. You can identify by the prefix whether it’s defined as KPI or formula.

KPI ID

Formula description

KPI_MATERIAL_CALC_ACTUAL_PURCHASE_LEAD_TIME

Computes actual Purchase Lead Time. Will be used for lead time recommendations if Machine Learning is not used.

KPI_MATERIAL_CALC_ACTUAL_PRODUCTION_LEAD_TIME

Computes actual Production Lead Time.

Will be used for production lead time recommendations.

FORMULA_MATERIAL_CALC_RECOMMENDED_SAFETY_STOCK

Computes a recommendation for safety stock based on King’s formula.

This formula is used if there are past replenishments for a material.

FORMULA_MATERIAL_CALC_RECOMMENDED_SAFETY_STOCK_PLANNED_LEAD_TIME

Computes a recommendation for safety stock based on King’s formula.

This formula is used if there are no past replenishments for a material.

KPI_MATERIAL_BUSINESS_LOGIC_RECOMMENDED_SAFETY_STOCK

Handles which safety stock formula is used for a recommendation and which materials should not get a recommendation (e.g. due to their planning strategy).

FORMULA_MATERIAL_CALC_RECOMMENDED_REORDER_POINT

Computes a recommendation for reorder point.

KPI_MATERIAL_BUSINESS_LOGIC_RECOMMENDED_REORDER_POINT

Handles reorder point is used for a recommendation (value based on formula, median consumption, or 1) and which materials should not get a recommendation (e.g. due to their MRP Type).

In case you update the underlying business logic or used variables, please make sure to also update the documentation for the business users in the Documentation folder.

Note

Recommendations based on Machine Learning are currently only available for Purchase Lead Times.

Adjusting the Knowledge Model in General

In the Knowledge Model, we use variables and formulas to provide better maintainability as well as permit the bulk change of values. During the first setup of the app, you need to check both the variables and formulas. You should start by validating and adjusting the variables and then validating and adjusting the formulas.

  1. To perform the validation, align with your customer’s SAP IT Business Partner and Process Owner. They have knowledge about the data structure and are aware of customizations that might need to be included.

  2. To validate the PQL statements of the variable/ formula, use analysis in the same Data Model, copy and paste the PQL statements into it and validate the results with your SAP IT Business Partner.

  3. If required, adjust the variable/formula in the Knowledge Model by:

    1. Copying relevant code in View mode.

    2. Entering Edit mode and pasting your selection.

    3. Adjusting the formula/KPI according to your preferences/needs.

Note

Links to the formula /KPI from dependent areas, such as filters for tasks and views, flags for inefficiencies, or KPI definitions, are automatically updated. This does not hold for changes made in the dependent Knowledge Model. If a customization is also to be used in other Inventory Management apps, the change must be transitioned to the Master Knowledge Model in the IM Starter Kit.

Although it uses many new studio components, all calculations (such as Filters, KPIs, Variables, Charts, and Tables) are still based on PQL within the Knowledge Model. If you get any error messages, you can narrow them down to the respective PQL-statement and test your code in an analysis or view to check if you have any syntax errors.

Calculating Past and Future Consumption

All past consumptions are taken from the Inventory Management Activity Table (CEL_IM_ACTIVITIES). Please refer to the documentation of the Inventory Management Connector to learn more about which goods movements are considered as consumption.

These past consumptions are combined with future consumptions from:

  • Reservations (dependent requirements)

  • Sales Orders

  • Independent Requirements

The consumption is then used for computing recommendations on both Safety Stock and Reorder Point based on this logic.

Since the required values are stored in different tables in the Inventory Management Data Model, they are combined in the Knowledge Model via a PQL operator called UNION_ALL.

Note

You can identify any object using UNION_ALL via their Knowledge Model ID - each KPI, variable, or filter using this operator has “_UNION_” in its ID.

To avoid any duplicated logic, there is a combined “Stock Requirements List” containing not just the consumption tables listed above.

The entire logic is built from:

  • Planned Orders

  • Purchase Requisitions

  • Purchase Orders

  • Production Orders

  • Material Movements

  • Reservations

  • Sales Orders

  • Independent Requirements

without the need for them to have a common JOIN path in the data model.

Any value computed in this UNION_ALL space can be retrieved using the operator “UNION_ALL_PULLBACK”. For the out-of-the-box KPIs, this pullback is executed such that any result can be retrieved via the Inventory Management Activity Table (_CEL_IM_ACTIVIITES). The results are then uniquely assigned to a single Material-Plant combination by using PU_FIRST to the MARC table.

For more information on what to look out for when working with or expanding this logic, consider the FAQ section of this guide.

Warning

Values for future consumption will be similar to what you see in your MD04 in SAP but it is not the goal to achieve a complete match.

This can be caused by multiple reasons such as (non-exhaustive):

  • Change in situation since the latest data load

  • Customizations of your SAP system

Leveraging Machine Learning for Purchase Lead Times

Note

Out of the box, the app computes recommendations for Purchase Lead Times using the average or median. Leveraging recommendations made by Machine Learning is an add-on which requires additional implementation effort.

If you would like to leverage this add-on, contact your CVM, Account Executive or create a Service Desk Ticket.

The results of the algorithm are stored in a distinct data model table called “CEL_P2P_ML_LEADTIMES”. This table is joined directly to the “MARC” table.

If Machine Learning is used, the following adjustments need to be made to the Knowledge Model:

  • If Actual Purchase Lead Time (i.e. recommendation without Machine Learning) still is to be displayed for reference:

    • Add additional KPI for recommended lead time, referencing the field "_CEL_P2P_ML_LEADTIMES"."RECOMMENDED_VALUE"

    • Add additional KPI for standard deviation of recommended lead time, referencing the field "_CEL_P2P_ML_LEADTIMES"."RECOMMENDED_STD"

    • Create copies of KPIs for actual replenishment lead time to use when computing other recommendations:

      • KPI_MATERIAL_CALC_ACTUAL_REPLENISHMENT_LEAD_TIME

      • KPI_MATERIAL_CALC_STDEV_REPLENISHMENT_LEAD_TIME

    • Update existing recommendation KPIs referencing actual lead time data to consider recommended data instead, especially the following:

      • FORMULA_MATERIAL_CALC_RECOMMENDED_SAFETY_STOCK

      • FORMULA_MATERIAL_CALC_RECOMMENDED_REORDER_POINT

  • If Actual Purchase Lead Time (i.e. recommendation without Machine Learning) is to be replaced:

    • Update KPI_MATERIAL_CALC_ACTUAL_PURCHASE_LEAD_TIME to reference the field "_CEL_P2P_ML_LEADTIMES"."RECOMMENDED_VALUE"

    • Update FORMULA_MATERIAL_STDEV_PURCHASE_LEAD_TIME to reference the field "_CEL_P2P_ML_LEADTIMES"."RECOMMENDED_STD"