Explaining Output Key Figures

Objective

After completing this lesson, you will be able to explain the purpose and 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 ID	Description	Details
CONSTRAINEDDEMAND	Customer Receipts	Quantity of the product supplied per period from a location to a customer, as calculated by a planning algorithm.
DEPENDENTCUSTOMERDEMAND	Outbound Customer Demand	Demand for a customer product combination per period to be met by a ship-from location, as calculated by a planning algorithm.
DEPENDENTCUSTOMERDEMANDDS	Dependent Customer Demand	Downstream key figure corresponding to the upstream key figure Outbound Customer Demand.
DEPENDENTDEMAND	Dependent Demand	Sum of all dependent demands (dependent customer demand, dependent location demand, and dependent production demand) for the location product.
DEPENDENTLOCATIONDEMAND	Outbound Location Demand	Demand 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.
DEPENDENTLOCATIONDEMANDDS	Dependent Location Demand	Downstream key figure corresponding to the upstream key figure Outbound Location Demand.
DEPENDENTPRODUCTIONDEMAND	Outbound Production Demand	Demand for components (input products) derived from the net demand of a finished or semi-finished product, according to the defined component coefficient.
DEPENDENTPRODUCTIONDEMANDDS	Dependent Production Demand	Downstream key figure corresponding to the upstream key figure Outbound Production Demand.
NETDEMAND	Net Demand	Demand 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 ID	Description	Details
COVERAGE	Coverage	Number of periods for which the dependent demand can be satisfied by the projected inventory of a period.
DEFICIT	Deficit (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.
INTRANSIT	In-Transit Receipts	Quantity of the product in transit from one location to another (not to the customer).
INTRANSITCUSTOMER	In-Transit Customer Receipts	Quantity of the product in transit from a location to a customer.
INTRANSITDS	In-Transit Supply	Downstream key figure corresponding to the upstream key figure In-Transit Receipts.
INVENTORYCORRECTIONVIOLATED	Inventory Correction Violated	Amount 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.
PROJECTEDINVENTORY	Projected Stock	Stock 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.
SHORTAGE	Shortage (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 ID	Description	Details
CONSDEMDELIVERED	Total Delivered	Total amount of the consensus demand delivered on time or late.
CONSTRAINEDDEMANDDS	Customer Supply	Downstream key figure corresponding to customer receipts.
CUSTOMERRATIOCOMP	Computed Customer Sourcing Ratio	Ratios of customer sources of supply calculated by the system based on the current supply plan of a planning session.
INDEPENDENTDEMANDSUPPLY	Independent Demand Supply	Amount delivered to satisfy a corresponding independent demand. The independent demand supply could be less than, but is not greater than, its corresponding independent demand.
PRODUCTION	Production Receipts	Receipts of an output product according to a production source of supply.
RECEIPT	External Receipts	Amount 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.
RECEIPTRATIOCOMP	Computed External Receipt Ratio	Ratios of external sources of supply that are computed by the system based on the current supply plan of a planning session.
SUPPLY	Supply	Sum 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.
TOTALCONSTRAINEDDEMAND	Total Customer Receipts	Supply for a customer product combination per period, as calculated by a planning algorithm.
TOTALRECEIPT	Receipts	For 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 ID	Description	Details
LOCATIONRATIOCOMP	Computed Location Sourcing Ratio	Ratios of location sources of supply that are calculated by the system based on the current supply plan of a planning session.
TRANSPORT	Transport Receipts	Quantity 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.
TRANSPORTDS	Transport Supply	Downstream key figure corresponding to the upstream key figure, Transport Receipts.
TRANSPORTRECEIPTSHIPTO	Transport Ship-To Receipts	Quantity 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 ID	Description	Details
PRODUCTIONRATIOCOMP	Computed Production Sourcing Ratio	Ratios of production sources of supply that are calculated by the system based on the current supply plan of a planning session.
CAPADEMAND	Capacity Demand of Handling or Storage Resource	Amount 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.
CAPAUSAGE	Capacity Usage of Handling or Storage Resource	Amount 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.
PCAPADEMAND	Capacity Demand of Production Resource	Amount 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.
PCAPAUSAGE	Capacity Usage of Production Resource	Amount 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.
PRODUCTIONCOMPONENT	Component Usage	Quantity 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

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.
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.
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

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.

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

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

Open your favorite Supply Planning.
Record the entries in the table provided.

Result

Supply for independent demand will be equal to independent demand.

Next lesson