Explaining Output Key Figures

Objectives

After completing this lesson, you will be able to:
  • Explain the purpose of output key figures
  • Identify examples of output key figures

Overview of Output Key Figures

Note

As there are various types of demand, there are various corresponding dependent demand key figures. These key figures are outlined later in this lesson.

Generally, output key figures are not editable.

TRANSPORT and TRANSPORTDS

The two key figures shown in the figure store the receipts generated to satisfy demand at a target location and the matching supply from the source location. For Transport Receipts, LOC is the target location. For Transport Supply, LOC is the source location.

Note that these key figures are also considered as inputs in the planning area that is used in this course.

Distinction between TRANSPORT and TRANSPORTDS

Upstream and Downstream Key Figures

Upstream refers to information about the target or destination, while downstream refers to information about the source.

The pair of key figures, TRANSPORT and TRANSPORTDS, is an example of upstream and downstream key figures. The downstream key figure is denoted by the suffix DS on its technical name.

In this example, the downstream key figure TRANSPORTDS shows the source location’s shipping date.

The upstream key figure has the target’s receipt date.

If both key figures are input key figures, you can input values for them before calling the planning operator. If you enter values for both key figures for the same period (taking into account any shift in lead time), the planning algorithm only considers the value entered for the upstream key figure. The downstream key figure will be ignored.

For this reason, be cautious about using both key figures on the same Microsoft Excel worksheet.

If you enter a value for either the upstream or downstream key figure and leave the other blank, the planning operator copies this value to the other key figure, that is, the one for which no value was entered.

Demand Output Key Figures

As a preliminary step in the sales and operations planning process, a copy of the Recommended Safety Stock key figure as well as a copy of the Combined Final Demand (from Demand Planning) to the Consensus Demand key figure are created. Consensus Demand is used in the supply planning runs of the sales and operations planning process, while the original Demand Planning key figure continues to be managed by the Demand Planner. In this way, the input into Supply Planning remains stable.

Next, during the supply review, the supply planner creates a constrained demand plan. To calculate the constrained demand plan, the planning algorithms use master data such as sourcing rules or quotas, resources, production sources (bills of material), lead times, lot sizes, and co-products. It also reads input planning data from key figures such as Consensus Demand, inventory target, and available capacity to calculate the constrained demand plan and update several other demand output key figures. The table, Demand Output Key Figures, shows the Demand Output key figures that are updated through this planning run.

Demand Output Key Figures

Key Figure IDDescriptionDetails
CONSTRAINEDDEMANDCustomer ReceiptsQuantity of the product supplied per period from a location to a customer, as calculated by a planning algorithm.
DEPENDENTCUSTOMERDEMANDOutbound Customer DemandDemand for a customer product combination per period to be met by a ship-from location, as calculated by a planning algorithm.
DEPENDENTCUSTOMERDEMANDDSDependent Customer DemandDownstream key figure corresponding to the upstream key figure Outbound Customer Demand.
DEPENDENTDEMANDDependent DemandSum of all dependent demands (dependent customer demand, dependent location demand, and dependent production demand) for the location product.
DEPENDENTLOCATIONDEMANDOutbound Location DemandDemand from a receiving location to a ship-from location that is needed to satisfy a fraction of, or the entire net demand of the receiving location. More than one outbound location demand may be required to meet the net demand.
DEPENDENTLOCATIONDEMANDDSDependent Location DemandDownstream key figure corresponding to the upstream key figure Outbound Location Demand.
DEPENDENTPRODUCTIONDEMANDOutbound Production DemandDemand for components (input products) derived from the net demand of a finished or semi-finished product, according to the defined component coefficient.
DEPENDENTPRODUCTIONDEMANDDSDependent Production DemandDownstream key figure corresponding to the upstream key figure Outbound Production Demand.
NETDEMANDNet DemandDemand that needs to be sourced for a location product. This is calculated by the planning algorithms using other key figures (primarily Dependent Demand, Stock on Hand or Projected Stock of the previous period) and lot-size parameters.

Inventory Output Key Figures

The table, Inventory Output Key Figures, shows the output key figures that can be used for inventory.

Inventory Output Key Figures

Key Figure IDDescriptionDetails
COVERAGECoverageNumber of periods for which the dependent demand can be satisfied by the projected inventory of a period.
DEFICITDeficit (in what comes into location)Noncumulative difference between the net demand and receipts for a location product for each period. This is always zero or greater; no negative values are calculated. It is always equal to zero when using the optimizer.
INTRANSITIn-Transit ReceiptsQuantity of the product in transit from one location to another (not to the customer).
INTRANSITCUSTOMERIn-Transit Customer ReceiptsQuantity of the product in transit from a location to a customer.
INTRANSITDSIn-Transit SupplyDownstream key figure corresponding to the upstream key figure In-Transit Receipts.
INVENTORYCORRECTIONVIOLATEDInventory Correction ViolatedAmount of a quantity defined by an inventory correction that could not be added to, or subtracted from, projected stock. For example, if a maximum inventory level prevents a planning algorithm from adding a positive inventory correction, or if not enough supply is available to fulfill a negative inventory correction.
PROJECTEDINVENTORYProjected StockStock balance of a product in a certain location per period. The projected stock of a product is the stock at a location that is expected to exist at the end of a period, if all receipts and supplies arrive as planned.
SHORTAGEShortage (of what goes out of location)Noncumulative difference between the dependent demand and supply for a location product. This is always zero or greater; no negative values are calculated. It is always equal to zero when using the optimizer, and also when using the Infinite without Shortages heuristic.

Supply Output Key Figures

The table, Supply Output Key Figures, shows the output key figures that can be used for supply.

Supply Output Key Figures

Key Figure IDDescriptionDetails
CONSDEMDELIVEREDTotal DeliveredTotal amount of the consensus demand delivered on time or late.
CONSTRAINEDDEMANDDSCustomer SupplyDownstream key figure corresponding to customer receipts.
CUSTOMERRATIOCOMPComputed Customer Sourcing RatioRatios of customer sources of supply calculated by the system based on the current supply plan of a planning session.
INDEPENDENTDEMANDSUPPLYIndependent Demand SupplyAmount delivered to satisfy a corresponding independent demand. The independent demand supply could be less than, but is not greater than, its corresponding independent demand.
PRODUCTIONProduction ReceiptsReceipts of an output product according to a production source of supply.
RECEIPTExternal ReceiptsAmount received at a location product by an external source of supply. This means that the net demand is satisfied without defining where corresponding receipts come from. If no external source of supply is specified, there is no supply.
RECEIPTRATIOCOMPComputed External Receipt RatioRatios of external sources of supply that are computed by the system based on the current supply plan of a planning session.
SUPPLYSupplySum of all supplies, that is, everything that leaves a location. It comprises quantities transported (in a downstream direction) to another location, transported to a customer, or consumed in a production process.
TOTALCONSTRAINEDDEMANDTotal Customer ReceiptsSupply for a customer product combination per period, as calculated by a planning algorithm.
TOTALRECEIPTReceiptsFor each period, the sum of all receipts; that is, everything received at a location for a product. It comprises production receipts, transport receipts, and external receipts.

SOURCING and TRANSPORT Output Key Figures

The table, SOURCING and TRANSPORT Output Key Figures, shows the output key figures that can be used for SOURCING and TRANSPORT.

SOURCING and TRANSPORT Output Key Figures

Key Figure IDDescriptionDetails
LOCATIONRATIOCOMPComputed Location Sourcing RatioRatios of location sources of supply that are calculated by the system based on the current supply plan of a planning session.
TRANSPORTTransport ReceiptsQuantity transported from a ship-from location to another location in a particular period. It reflects the supply from this location, as calculated by a planning algorithm.
TRANSPORTDSTransport SupplyDownstream key figure corresponding to the upstream key figure, Transport Receipts.
TRANSPORTRECEIPTSHIPTOTransport Ship-To ReceiptsQuantity transported from one location to another location in a particular period. Used with subnetworks, this is the same quantity as transport receipts but is based on delivery times at the ship-to location.

PRODUCTION, CAPACITY, and BILLS OF MATERIAL Output Key Figures

The table, PRODUCTION, CAPACITY, and BILLS OF MATERIAL Output Key Figures, shows the output key figures that can be used for PRODUCTION, CAPACITY, and BILLS OF MATERIAL.

PRODUCTION, CAPACITY, and BILLS OF MATERIAL Output Key Figures

Key Figure IDDescriptionDetails
PRODUCTIONRATIOCOMPComputed Production Sourcing RatioRatios of production sources of supply that are calculated by the system based on the current supply plan of a planning session.
CAPADEMANDCapacity Demand of Handling or Storage ResourceAmount of capacity needed to handle or store the entire net demand of a location product. This is calculated by multiplying the net demand by the capacity consumption rate of the handling or storage resource.
CAPAUSAGECapacity Usage of Handling or Storage ResourceAmount of a resource’s capacity supply needed to handle or store a product. If the capacity supply is sufficient to satisfy the capacity demand for all products, this equals the key figure Capacity Demand of Production Resource.
PCAPADEMANDCapacity Demand of Production ResourceAmount of capacity needed to produce the portion of the net demand of a location product that is sourced via a production source of supply to a production source. This is calculated by multiplying the net demand (sourced via this production source) by the capacity consumption rate of production resource.
PCAPAUSAGECapacity Usage of Production ResourceAmount of a resource’s capacity supply consumed by the production of a product. If the capacity supply is sufficient to satisfy the capacity demand for all products, this equals the key figure Capacity Demand of Production Resource.
PRODUCTIONCOMPONENTComponent UsageQuantity of a component produced and supplied for a production or assembly process.

Demonstration: How to Execute a Planning Run with Input and Output Key Figures

Execute a Planning Run with Input and Output Key Figures

Task 1: Review and Note the Configuration of Two SAPIBP1 Input Key Figures

Task 2: Create a Planning View with Independent Demand and Add a Demand

Add independent demand key figures to the DC to Customer tab in your Supply Planning favorite.

Steps

  1. In the SAP IBP, add-in for Microsoft Excel, add the Independent Demand and Independent Demand Supply key figures to your Supply Planning favorite on the DC to Customer tab.

    1. In SAP IBP, add-in for Microsoft Excel, choose your Supply Planning favorite and choose the DC to Customer tab.

    2. Choose Edit View → Edit Planning View.

    3. Choose the Key Figure tab and select the Independent Demand and Total Supply for Independent Demand (Location-Centric) key figures and choose OK.

    4. Update your favorite.

  2. Enter an independent demand of 400 for product T-F2## at location 2500 eight periods in the future (9th column), and save the data.

    1. In the SAP IBP, add-in for Microsoft Excel, choose the cell for Independent Demand for T-F2## at location 2500 8 periods from now (9th column), and enter a value of 400.

    2. Choose Data Input → Save Data.

  3. If you receive an error message stating that there are no planning objects for this combination, create a new planning object. Add and save the independent demand.

    1. In the SAP IBP, add-in for Microsoft Excel, choose Master Data → New Planning Object.

    2. Ensure it has the correct product ID and location ID nominated.

    3. To create the combination, choose Add.

    4. Repeat Step 2 to create independent demand.

Task 3: Execute a Planning Run and Check Your Results

Steps

  1. In the SAP IBP, add-in for Microsoft Excel, use the supply planning operator to run planning again and check the sourcing results.

    1. In Microsoft Excel, ensure you are on the SAP IBP tab, and in the Application Jobs section, choose SOP Operator → Run.

    2. Choose Next. Optionally, you can choose a reason code and enter a comment.

    3. Choose Run.

    4. On the pop-up the status of the job will be displayed. To review the logs select Navigate to Status, to close the Pop-up select OK. To review the logs later, choose S&OP Operator → Status.

    5. When the job has completed, proceed to step 2.

  2. Refresh your favorite Supply Planning, and record the planning results for T-F2## at location 2500 in the following table:

    Key FigureCurrent Period + 4Period + 5Period + 6Period + 7Period + 8Period + 9
    Dependent Customer Demand      
    Customer Supply      
    Independent Demand      
    Total Supply for Independent Demand      

    1. Open your favorite Supply Planning.

    2. Record the entries in the table provided.

Log in to track your progress & complete quizzes

Learning

SAP FacebookSAP YoutubeSAP LinkedIn