Explaining Downstream Key Figures

Objective

After completing this lesson, you will be able to explain downstream key figures for location-centric view

Introduction to Downstream Key Figures for Location-Centric View

A typical view that a planner wants to see on one screen is the one where all the key figures are related to a location-product (or an aggregation of several location-products).

The view needs to display the entire inbound and outbound material flow, and all inbound and outbound demands at that location-product for all periods. This is illustrated by the figure, Location-Centric View.

Location-Centric View

Outbound location demand (OLD) from DC0 to DC1 has location DC0 in its key and therefore is displayed for location centric view of DC0, but not of DC1. Similarly, the key figure Transport Receipts, which stores the data of the transport receipts planned from DC1 to DC0, is displayed in location centric view of DC0, but not of DC1.

Downstream key figures resolve this, as shown in the figure, Location-Centric View with Downstream Key Figures.

Location-Centric View with Downstream Key Figures

Transports planned from DC1 in downstream direction to DC0 are stored in a downstream key figure transport supply

Transports planned from DC1 in downstream direction to DC0 are stored in a downstream key figure transport supply. By selecting all key figures with product ID = P1 and location ID = DC1, the system will return the inbound transports arriving in DC1 as transport receipts and the outbound transports leaving DC1 as transport supply.

This assumes a lead time between DC0 and DC1 (and between DC1 and DC2) of one period.

The planner can compare the inbound and outbound dependent demands by comparing the outbound location demand with the related dependent location demand. The inbound dependent location demand is lead time shifted in order to be comparable with the outbound location.

Dependent Customer Demand

The technical name of Dependent Customer Demand is DEPENDENTCUSTOMERDEMANDDS, and the key includes customer, product, and location.

Customer Supply

The technical name for Customer Supply is CONSTRAINEDDEMANDDS, and the key includes customer, product, and location.

Dependent Location Demand

The technical name for Dependent Location Demand is DEPENDENTLOCATIONDEMANDDS, and the key includes product, ship-to location, and location.

Transport Supply

The technical name for Transport Supply is TRANSPORTDS, and the key includes product, ship-to location, and location.

The downstream key figure Transport Supply corresponds to the upstream key figure Transport.

The downstream key figure Transport Supply corresponds to the upstream key figure Transport.

Dependent Production Demand

The technical name for Dependent Production Demand is DEPENDENTPRODUCTIONDEMANDDS, and the key includes output production, location, product, and source ID.

Component Supply

The technical name of Component Supply is PRODUCTIONCOMPONENTDS, and the key includes output product, location, product, and source ID.

The downstream key figure Component Supply corresponds to the upstream key figure Component Usage.

The downstream key figure Component Supply corresponds to the upstream key figure Component Usage.

Demonstration: How to Plan Using In-Transit and Downstream Key Figures

Plan Using In-Transit and Downstream Key Figures

Task 1: Adapt your Planning View

Task 2: Plan Using In-Transit and Downstream Key Figures

Steps

  1. Run the Time-Series-Based Supply Planning Heuristic operator and observe the values in the in-transit key figures that you had added to your planning view.

    1. In the Application Jobs section of the IBP ribbon, choose SOP Operator-> Run, choose Time-Series-Based Supply Planning Heuristic, and choose Run.

    2. When the job is finished, choose Refresh.

  2. In the DC to Customer tab observe what Location ID/Product ID/Customer ID has values in in-transit key figure. Check in the master data, as to what is the lead time associated with that combination and what is the difference with all other lead times.

    1. In the SAP IBP, add-in for Microsoft Excel, open your Supply Planning favorite (if it is not already open) and choose the DC to Customer tab. Here, view the key figure you added earlier: In-Transit Customer Receipts.

    2. In the SAP IBP, add-in for Microsoft Excel, use the Manage Master Workbook tab and choose Create.

    3. Choose master data type Customer Source. Load the data and view the lead times.

  3. Do the same analysis with in-transit key figures in the Transportation tab.

    1. In the SAP IBP, add-in for Microsoft Excel, open your Supply Planning favorite (if it is not already open) and choose the Transportation tab. Here, view the key figures you added earlier: In-Transit Supply.and In-Transit Receipts.

    2. In the SAP IBP, add-in for Microsoft Excel, use the Manage Master Workbook tab and choose Create.

    3. Choose master data type Location Source. Load the data and view the lead times.

Log in to track your progress & complete quizzes

Learning

SAP FacebookSAP YoutubeSAP LinkedIn