Supply Key Figures in HPA

Objective

After completing this lesson, you will be able to explain the Features of Supply Key Figures in HPA

Key Figures' Naming Convention in HPA

The persistence layer distinguishes between stored and external key figures. The later one are an aggregated view of the internal data structure of the orders. External and stored key figures have separate persistence, so there is no automated conversion between them. This means that algorithms that produce orders store their results differently from algorithms that work on time series. Even for algorithms that do the same planning (like network planning), we need separate persistencies if they create outputs from different persistencies.

It is not technically possible to persist data in the same key figure objects for orders and time series; therefore, separate key figures with an intuitive naming scheme are used, making it very transparent.

The suffix OR or TS is used if the key figure exists in both persistencies – order-based and time-series planning.

The master data type (LN = lane or PDS) is added in case a key figure exists for both sources of supply. The default is the location product master data type. If an attribute/key figure exists at a more granular level, then LN or PDS is added.

Like SAP7F, the key figures carry in the technical name the state (e.g., PLANNED, UNPLANNED, FIX,…) for time-series and order-based key figures.

Examples are key figures related to resources:

  • I_CAPACONSPLANNEDOR
  • I_CAPACONSPLANNEDTS

Other examples of parts of the technical name

  • Prefix (type of constraint, behavior): MIN, MAX, AVG, CALC, ADJ, FINAL,….
  • Topic (process): DISTR, PRODN, SUPPLY, …
  • Master Data Type – (source of supply in case of ambiguities): LN (lane), PDS
  • Technical suffix represents
    • status: PLANNED, FXD (fixed), UNFXD (unfixed), LOAD, CONF, CONFLATE, CONFINTIME, …
    • persistency: OR, TS
    • calculation details: MEAN, CV, BIAS, …
    • app-specific information: COSTRT,….

The schematic for key figure names is illustrated in two examples below.

The figure describes the Naming Scheme for Key Figures.

Using the Order Key Figures in TS Supply

With the new capabilities in Harmonized Planning, stored, calculated and external/order key figures can be fed directly into the time-series supply.

As mentioned in the introduction, one of the important elements of process enablement in Harmonized Supply Planning is managing the confirmed input data.

This represents a significant change from the current state, especially in time-series supply. The confirmed data input is considered "as-is." It typically includes inputs that SAP IBP receives from SAP S/4HANA, such as purchase orders, production orders, and stock transfer orders.

For example, the abstract supply chain planning calculation on buckets recalculates the confirmed production inputs and the corresponding dependent component demands using SAP IBP master data and capacity consumption data. Hence, the transformation of the input data introduces a modelling error into the algorithm, and the output can suffer from poor planning quality, especially when integration is facilitated by the ETL.

So, Harmonized Planning's base capability assumes that confirmed data used as input should be treated as untouchable by the algorithms. It is not recalculated; it is taken as is. The buckets in the time series supply take the quantity and the dates, as they are. There won't be any new planned orders. Production orders from S/4 SAP HANA are integrated with their quantity and not with the capacity consumption. Consumption is calculated by each algorithm separately.

The business meanings define confirmed data. It is qualified to be confirmed, and this base feature applies to all data that falls into that category.

The figure describes the Confirmed Key Figures in Application Mapping.

The new architecture implies a time series with order key figures supported by the OKF Cache (this topic is explored in more detail at the end of this course). This replicated cache enables fast time-series access to order data. The compilation time for the query (e.g., in the Microsoft Excel UI) and the execution time are significantly reduced.

Supply Key Figures in HPA

Downstream is the direction in which goods flow through the supply chain network, from purchased components or raw materials via semi-finished goods to finished goods, delivered to customers or customer-facing distribution centers.

Thus, for a location product, the downstream key figures show incoming demand or outgoing supply. On the other hand, upstream key figures show the outgoing demand or the incoming supply for a location product.

Downstream and Upstream

Downstream is the direction in which goods flow through the supply chain network, from purchased components or raw materials via semi-finished goods to finished goods, delivered to customers or customer-facing distribution centers.

Thus, for a location product, the downstream key figures show incoming demand or outgoing supply. On the other hand, upstream key figures show the outgoing demand or the incoming supply for a location product.

The upstream distribution key figures have the planning level of the day (for OBP) and the technical week (for time series) as the root, along with product, location, ship from location, mode of transport, and additional lanes.

As shown in the figure below, the key figures in green, including Distribution Supply Confirmed (Lane) and Distribution Supply Planned Fix (Lane), are order key figures that come as input from S/4 SAP HANA by RTI, and these are "as-is key figures."

The other group of key figures, highlighted in the image, acts as input to SAP IBP. For some of these key figures, including the Minimum Distribution Supply (Lane) and Maximum Distribution Supply (Lane), the terminology has been revised from a time-series perspective. These are analogous to the receipts of SAPIBP1, where the key figures are called Min Transport and Max Transport. These are the transport receipt portions when we describe the upstream view.

Planning Level - Day | Product | Ship-From Location | Location | Mode of Transport | Additional Lane ID

There are also minimum distribution quotas and maximum distribution quotas. In addition, certain adjustment key figures and the optimizer input key figures are the input key figures for the time-series supply.

Some key figures serve as input to Time Series and OBP, since the time root has been moved to the day level. Since these are cross-application key figures, the Minimum Distribution Supply (Lane) and Max Distribution Supply (Lane) can be used in the application mapping for both time-series and order-based applications. If there is a specific business need and a distinction needs to be made, it is possible to branch out in the application mapping.

The figure describes the Maximum Distribution Supply.

Some key figures act as outputs. The OBP planning run output (at the lowest level of granularity) is all the distribution supply planned on the lane, which has an OR suffix.

If you're running other processes like deployment or TLB, they each have their respective outputs, such as distribution supply lane deployment and distribution supply lane load.

A more valuable cross-application key figure example is Total Distribution Supply confirmed (▷I_TOTALDISTRSUPPLYLNCONF◁), which is the sum of distribution supply confirmed lane, distribution supply deployment lane, and distribution supply load. These are all read via the calculation scenario used by the time series supply. The time-series supply planning will read these key figures directly from the orders via their respective outputs, such as the planning calculation scenario, at the calendar-week level or the planning run level specified in the planning run profile.

The figure below shows key figures from the upstream planning view as outputs from a time-series supply perspective. We saw certain key figures read directly from the day granularity as input for time-series supply planning. This output from the time-series supply is written in key figures with the TS suffix.

You can see the Distribution Supply Planned (Lane) TS, the Distribution Supply Plan Unfixed (Lane) TS, and the Distribution Supply (Lane) TS.

Calendars can act as input, whether a transport calendar for transportation lane (I_TRANSPCALENDAR) or an arrival calendar (I_TLANEARRIVALCALENDAR). It can be specified as an attribute on the respective T-lane product or as a key figure, as in the SAPIBP1 or SAP4 sample planning areas.

The figure describes the Distribution Key Figures Upstream.

In addition to time-series supply and order-based applications, key figures are also used in other applications, such as inventory optimization. For example, Key figures like Calc. Distribution Lead Time (CV) and Calc. Distribution Lead Time (Mean). So, other key figures that form either an input or an output for Inventory optimization processes will be at the same planning level.

As depicted in the figure below, the downstream key figures have a different planning level (from Loc to ShipToLoc). The key changes, but the same pattern repeats as groups of key figures, such as input key figures within SAP IBP, like Max Distribution from a downstream perspective, and output key figures.

The total distribution demand confirmed (Lane) is the as-is key figure.

The figure describes the Distribution Key Figures Downstream.

The figure below shows the transportation resource capacity consumption key figures. There are input key figures like the capacity consumption rate (lane). With 2508 release, it's only supported by time series supply.

The respective output key figures come from time series supply output planning runs and Order-based planning runs.

There is a planning-level change here. Day, Product ID, Location, Mode of transport, Additional lane, and Resource ID are the roots. Certain downstream views exist as well.

From an order-based perspective, you can see the same key figure, the DS figure, from a downstream view perspective. These are very specific to the order base.

The figure describes the Transportation Resource Capacity Consumption Key Figures.

Transitioning to the production model, there are production key figures, and the figure below demonstrates these objects.

Highlighted in red, the input key figures come from S/4 SAP HANA (populated via RTI). So this is production supply, PDS conf, and the fixed key figures at the day PDS planning level. This acts as an input for the algorithms for time series and order-based planning.

Then there are input key figures in SAP IBP. These are the min-max key figures, adjusted key figures, or optimizer input key figures.

The key figures at the Week PDS level represent the algorithm output for the time series supply, which outputs the production supply for the main product.

Then there are production supply planned, and production supply planned unfixed key figures following the same pattern as distribution.

These key figures are outputs of the planning run.

The figure describes the Planning Levels and Key Figures PDS Header (Production) Key Figures.

The figure below shows the component key figures. The same pattern can be observed.

There are input key figures populated via RTI, also known as the order key figures (I_COMPDEMANDPDSCONF). The I_COMPDEMANDPDSPLANNEDFXD acts as an input.

The output for time series supply is I_COMPSUPPLYPDS, the upstream key figure, and I_COMPDEMANDPDSTS, the downstream key figure.

And then there are Component Demand Planned and Component Demand Planned Unfixed. They exist for both time series and order-based as these are different persistencies.

The figure describes the Planning Levels and Key Figures PDS Component Key Figures.
Pattern for the naming of production key figures

The figure below shows PDS Resource key figures (the capacity consumption key figures).

There are similarities to the previous key figure groups.

There is, as input from S/4 SAP HANA, the confirmed capacity consumption.

The planning level I_DAYRESACTPDS has an additional root that differs from the current one in SAP7F.

I_CAPACONSRTPDS is the capacity consumption rate used only in time series supply, where you can also have a time-dependent capacity consumption rate similar to what's there today and at the weekly levels.

All the key figures on the week level are either input or output for time series supply, and some of the day level key figures are inputs for time series supply as well, as time series supply will directly read the most granular key figures.

The output from time series supply, I_CAPACONSPDSTS, comprises planned and unplanned plus confirmed quantity, and I_CAPACONSPDSPLANNEDTS, is only for the planned portion of the production supply.

RTI fills out the Available Capacity, which is stored (for example, depending on settings in S/4 SAP HANA) at seconds/day. There is a new UoM conversion (I_CAPAAVAILABLEUOMCONV) for displaying the capacity. If the Available Capacity is not filled, the calculation defaults to the Default Capacity Available configured as an Attribute as a Key Figure.

The figure describes the Planning Levels and Key Figures PDS Resource Key Figures.

There are several key figures for additional outputs (co-products), as depicted in the figure below. The input key figures for the additional supply or co-products are confirmed and fixed, and taken as input. In the 2508 release, only time-series supply supports co-production, so the output in this case is for time-series supply production, and this key figure is at the weekly level.

The figure describes the Planning Levels and Key Figures Additional Output Key Figures.