JinJin48
JinJin48
SAP Consultant | BTP · S/4HANA · US Global Rollout
· 13 min read

SAP IBP Key Figure

A Key Figure is the SAP IBP object type that represents a single quantitative measure flowing through a Planning Area — demand quantity, supply quantity, inventory quantity, revenue, forecast accuracy, fill rate, and similar values. It is the “value” axis of the planning data cube, complementing the master-data-driven dimension axes (Product, Location, Customer, Time) covered in the Phase 1 master data articles. Unlike Product, Location, or Customer Master, a Key Figure is not typically replicated from an ERP master record — it is defined as part of building the Planning Area’s model itself. This article covers what a Key Figure is, its core Stored-vs-Calculated data model, its position in the org/data hierarchy, and every field a consultant configures when creating one.


Part 1: Key Figure — Core Concepts (All Modules)

1.1 What Is the Key Figure?

Hub-and-spoke diagram showing Key Figure at center, connected to Master Data Types, Time Profile, Planning Level, Planning Area, Planning View, and Planning Operator

A Key Figure holds the transactional/planning data in an SAP IBP model — quantities and currency amounts representing plan data (sales forecast, projected inventory, capacity plan) or actual/historical data (sales orders, shipment history). It is defined and configured inside a Planning Area, not maintained as an independent, freestanding master data object the way Product or Location Master are.

AspectDetails
RoleRepresents a single quantitative measure (demand qty, supply qty, inventory qty, revenue, KPI) that flows through a Planning Area’s data model
Planning processes using itDemand Planning, Supply Planning, Inventory Planning, S&OP, and Planning Operators (statistical forecast, supply heuristic, inventory optimizer) all read and write Key Figures
Where it’s configuredPlanning Area → Configuration tab → Key Figures node → New → Key Figure — a configuration step scoped to a specific Planning Area, not a fully separate standalone master-data app
Data storage modelHANA in-memory, scoped to the owning Planning Area; a Key Figure is a stored or calculated measure in that Planning Area’s fact model, not an independently addressable ABAP Dictionary table
Governance appWhere-Used Information for Key Figures (Fiori) — shows every calculation, Copy Operator, and Excel Planning Template that references a given key figure

1.2 Storage Type — Stored vs. Calculated

Three-column comparison of SAP IBP Key Figure storage types: Stored, Calculated, and Stored+Calculated hybrid

Every Key Figure is built on one structural axis: whether its data is physically stored, or computed at run time. Getting this distinction wrong is costly — it determines whether the figure can be manually edited by a planner and whether it can ever be used as a disaggregation target.

Storage TypeEditable?Use CaseKey Behavior
StoredYesDirectly integrated from a source system or manually entered by a planner — e.g. Demand Qty, Supply QtyPhysically holds rows at its base planning level. Only a Stored key figure can be set Edit Allowed = Yes. Only a Stored (time-series) key figure can be used as a disaggregation target.
CalculatedNo (normally)Derived at run time from a formula referencing other key figures and/or master data attributes — e.g. Inventory Turnover Ratio, Fill RateNo independent storage — recalculated on every read. Normally cannot be edited directly, since there is nothing to write a manual override back to.
Stored + Calculated (hybrid)Yes (exception)A formula seeds a default value that a planner can then manually override — e.g. an initial forecast proposal a demand planner adjustsSpecial case: flagged as both Stored and Calculated simultaneously so the field becomes editable despite carrying a calculation formula.

Design principle: Stored vs. Calculated is the structural axis — it determines whether the key figure’s data physically exists in the Planning Area’s storage, which in turn decides whether it can be edited or used as a disaggregation target. Input and Output are a separate, secondary framing layered on top: usage-role labels describing how a key figure is used in a given planning step (a planner-editable input vs. a system-generated result), not a third and fourth storage type sitting beside Stored and Calculated. A Stored key figure is typically the “Input” to a planning step; a Calculated key figure — or the result a Planning Operator writes back — is typically the “Output.” See Section 2.5 for where this usage-role framing becomes an explicit configuration setting on a Planning Operator.


1.3 Organizational Levels and Data Hierarchy

Zone crop from the SAP IBP master data landscape showing Key Figure KF-DEMAND positioned under Planning Area PA-DP01 alongside Planning Level and Version, with Planning View as a downstream child

Data hierarchy with a concrete example

Client (SAP IBP Tenant)
   │
   └── Planning Area "PA-DP01" — Demand Planning Planning Area          (IBP-A03-03)
          │
          ├── Key Figure "KF-DEMAND" — Demand Quantity                    [this article's object]
          │
          ├── Planning Level "PL-PROD-LOC" — Product x Location            (IBP-A03-02)
          │
          ├── Version "VER-BASELINE" — Approved plan (baseline)            (IBP-A03-04)
          │
          └── Planning View "PV-DP-WEEKLY" — Weekly Demand Planning View   (IBP-A03-05)

Design principle: Key Figure, Planning Level, and Version are structurally parallel children of a Planning Area — none nests inside another. A Key Figure is anchored to exactly one base planning level; every other level it is viewed or planned at is either aggregated up or disaggregated down from that anchor. The full mechanics of what a Planning Level is and how it is built are covered in sibling article IBP-A03-02; this article treats “base planning level” only as the anchor point a Key Figure’s Storage Type and Aggregation/Disaggregation settings key off of.


1.4 Integration with Other Master Data Objects

Hub-and-spoke showing Key Figure at center connected to Master Data Types, Time Profile, Planning Level, Planning Area, Planning View, and Planning Operator

A Key Figure does not stand alone — it exists inside a chain of Phase 2 planning-configuration objects and is consumed further downstream by execution objects.

ObjectRelationshipPractical Notes
Master Data TypesA Key Figure’s base planning level combines attributes drawn from Master Data Types (Product, Location, Customer, etc.)Already covered in Phase 1 (IBP-A02-01 through A02-06) — a Key Figure inherits its dimensional granularity from these; it does not define new master data of its own.
Time ProfileSupplies the time-bucket dimension (week/month/year) most Aggregation Modes and all Last Period Aggregation logic operate acrossConfigured once per Planning Area, shared by every Key Figure in that area.
Planning LevelDetermines the exact dimensional combination a Key Figure can be stored/viewed at; every Key Figure references a base Planning LevelFull mechanics covered in sibling article IBP-A03-02 — this article treats it only as the anchor a Key Figure points to.
Planning AreaThe container that bundles Time Profile + Planning Level(s) + Key Figure(s) into an activatable planning modelFull mechanics covered in sibling article IBP-A03-03 — a Key Figure cannot exist outside a Planning Area.
Planning ViewDisplays one or more Key Figures to planners in a configurable grid/reportCovered in sibling article IBP-A03-05 — this article’s Key Figures are the data a Planning View renders.
Planning OperatorConsumes “Input Key Figures” and writes “Output Key Figures” when it runs (statistical forecast, supply heuristic, inventory optimization, etc.)Covered in downstream article IBP-A05-01 — this is where the Input/Output usage-role framing from Section 1.2 becomes an explicit configuration setting.

Part 2: IBP-Specific Field Details

2.0 Scope of IBP Ownership

Checklist showing IBP consultant ownership across Key Figure configuration sections: General Definition, Storage/Aggregation, Disaggregation, Currency/UOM, Usage Roles

Data SectionIBP InvolvementNotes
General Definition◎ OwnerKey Figure ID, Name, Description, Base Planning Level, Data Type
Storage & Aggregation Configuration◎ OwnerStorage Type (Stored/Calculated), Edit Allowed, Aggregation Mode
Disaggregation & Proportionality◎ OwnerDisaggregation Mode, Proportionality weighting
Currency & UOM Conversion○ Shared with Master Data governanceDepends on exchange-rate reference data and Product UOM attributes maintained outside the key figure record itself
Usage Roles & Governance◎ OwnerInput/Output usage-role framing, Where-Used Information app, advanced patterns

Legend: ◎ = Owner / Critical, ○ = Direct involvement


2.1 General Definition

Checklist of key General Definition fields: Key Figure ID, Name, Description, Base Planning Level, Data Type

General Definition is the identity layer of the Key Figure — set once when the key figure is created, on the Planning Area’s Configuration tab.

FieldDescriptionPractical Usage
Key Figure IDUnique technical identifier for the key figure within the Planning AreaAdopt a naming convention early (e.g. prefix by process: DEM_, SUP_, INV_) — key figures accumulate quickly once formulas and Planning Operators start referencing each other, and an inconsistent scheme becomes a real maintenance drag within a few sprints.
Name / DescriptionBusiness-facing label and longer description shown in planning views and the Excel Add-inThis is what planners see, not the technical ID — write it the way a demand planner or supply planner would recognize it, not the way IT would name it internally.
Base Planning LevelThe single planning level at which this key figure’s data is physically storedFix this at design time. Changing a live key figure’s base planning level later typically means recreating it and reloading history, since it changes where and how granularly the values are stored.
Data TypeNumeric type — Integer, Decimal, etc.Decimal precision matters for ratio/percentage key figures (fill rate, forecast accuracy) — an Integer-typed ratio silently truncates and produces misleading 0% / 100% readings in dashboards.

2.2 Storage & Aggregation Configuration

Stack layered diagram grouping Key Figure configuration by Storage Type, Edit Allowed, Aggregation Mode, and Calculation Formula

This is where the Stored-vs-Calculated axis from Section 1.2 becomes concrete configuration, along with how values roll up from the base planning level to higher levels.

FieldDescriptionPractical Usage
Storage TypeStored / Calculated / Stored+Calculated hybridGet this right before building downstream calculations — a Calculated key figure referenced heavily by other formulas is recalculated on every read, and cannot receive a manual planner override unless also flagged Stored.
Edit AllowedWhether a planner can manually enter/overwrite a value for this key figure in a planning viewOnly available for Stored (or hybrid Stored+Calculated) key figures — enabling it on a purely Calculated key figure has nothing to write to and is not a valid configuration.
Aggregation ModeSUM, AVG, MIN, MAX, COUNT, STDDEV, or Last Period AggregationSUM is the default for flow quantities (demand, supply). For stock/inventory-type key figures, a common nuance: SUM across product/location, but AVG across time — inventory doesn’t “add up” meaningfully across months. Use Last Period Aggregation for point-in-time balances (e.g. end-of-month stock) where summing across the period would double-count.
Calculation FormulaThe formula referencing other key figures / master data attributes (Calculated key figures only)Formulas can combine inputs stored at different base planning levels — IBP aggregates or disaggregates each input to a common calculation level internally before evaluating. Document the formula’s business logic outside the system too; the formula field alone doesn’t explain why a ratio is built the way it is.

2.3 Disaggregation & Proportionality

Stack layered diagram showing Disaggregation Mode and Proportionality options: Equal Distribution, Copy Values, and weighting by another key figure

Disaggregation is the flip side of aggregation: when a planner edits a value at a higher level, the system automatically splits it back down to the base planning level.

FieldDescriptionPractical Usage
Disaggregation ModeHow an edit made at a higher level is split down to the base planning levelTwo base modes: Equal Distribution (splits the value evenly across the lower-level members) and Copy Values (writes the same value into every target bucket rather than splitting it). Only Stored key figures can be disaggregation targets — a purely Calculated key figure has no storage row to write the split into.
ProportionalityThe weighting method used when the split should not be equalOptions include “No Proportional Disaggregation” (falls back to Equal Distribution), weighting by another key figure’s stored values, and — since IBP release 2208 — weighting by another key figure’s calculated values (e.g. splitting a regional demand number down to products in proportion to each product’s historical sales share).
Key Figure for ProportionalityThe reference key figure supplying the split weightsMust itself be populated at (or derivable to) the same base planning level as the key figure being disaggregated — a mismatch here is a common cause of an unexpectedly even split when a proportional one was intended.

2.4 Currency & UOM Conversion

Two-column comparison of Currency Conversion and Unit of Measure Conversion configuration for a Key Figure

Currency and UOM handling are layered on top of a Key Figure’s stored base value — neither is a fixed property of the key figure record itself.

FieldDescriptionPractical Usage
Currency ConversionConverts a key figure’s stored base-currency amount to a target currency, either via a dedicated calculated key figure multiplying against exchange-rate reference data, or on-the-fly at query time in the Excel Add-in / AnalyticsExchange-rate reference data is typically time-dependent — confirm during blueprint whether the project needs point-in-time historical rates (audit/variance reporting) or current-rate-only conversion; retrofitting time-dependency later is rework.
Unit of Measure ConversionConverts a key figure’s stored base UOM to a target UOM using a conversion factor sourced from a Product master attributeUnlike currency, UOM factors are generally not time-dependent (a case-to-each ratio rarely changes week to week), which simplifies the reference data model relative to currency conversion.
Target selectionWhether the target currency/UOM is fixed by a calculated key figure, or selectable at runtime by the plannerOn-the-fly runtime selection (Excel Add-in / Analytics) avoids building a separate calculated key figure per target currency/UOM — prefer it unless the business specifically needs a persisted, reportable converted value.

Prerequisite: Currency conversion requires exchange-rate reference data to already exist in the model (typically a compound master data type pairing “Currency From” / “Currency To” with a rate value); UOM conversion requires the conversion factor to be maintained as a Product master attribute. Neither works out of the box without this reference data in place.


2.5 Usage Roles & Governance

Checklist covering Input/Output usage roles, advanced key figure patterns, and the Where-Used Information governance app

This section returns to the Input/Output usage-role framing introduced in Section 1.2, now shown as it appears operationally, alongside a few advanced key figure patterns and the governance app consultants should know before changing or deleting a live key figure.

Field / ConceptDescriptionPractical Usage
Input Key Figure (usage role)A key figure a Planning Operator reads as a starting value for a runConfigured explicitly on the Planning Operator (e.g. a statistical forecast operator’s “Input Key Figures” setting) — it is a role assignment, not a separate storage type; see Section 1.2.
Output Key Figure (usage role)A key figure — Stored or Calculated — that a Planning Operator writes its result intoSame caveat as Input: the storage mechanics were already decided by Storage Type in Section 2.2. “Output” only describes that this run’s result lands here.
Helper Key FigureAn intermediate/scratch key figure used only to simplify a multi-step calculationNot meant for direct end-user display — a useful pattern for breaking a complex formula into readable, testable pieces. Keep the naming convention distinct (e.g. an _HLP suffix) so planners don’t accidentally add helper figures to a planning view.
Attribute-as-Key-FigureA technique for exposing a master-data attribute value through the key-figure mechanismLets an attribute (e.g. a Product’s standard cost) appear alongside true key figures in planning views and calculations — useful, but don’t confuse it with a genuine transactional measure when reviewing a data model.
Alert Key FigureA key figure used specifically to drive threshold-based alertsTypically a Calculated key figure comparing an actual/planned value against a threshold (e.g. flagging capacity overloads or stock-outs) — the alert logic itself lives in Alert configuration, not in the key figure record.
Where-Used Information for Key FiguresFiori app listing every calculation, Copy Operator, and Excel Planning Template that references a selected key figureRun this before changing or deleting a key figure with a wide dependency graph — especially one feeding Planning Operators — to see the full blast radius first. Access to this governance capability is gated by a dedicated business catalog.

L1) Big Picture

IDCategoryTitle
ibp-001OverviewWhat is SAP IBP?

L2-A) Master Data

IDCategoryTitle
ibp-a01OverviewSAP IBP Master Data: Overview, Hierarchy & Relationships
ibp-a02-01Master DataSAP IBP Master Data Types
ibp-a02-02Master DataSAP IBP Attribute
ibp-a02-03Master DataSAP IBP Time Profile
ibp-a02-05Master DataSAP IBP Location Master
ibp-a03-01Master DataSAP IBP Key Figure 📍
ibp-a03-02Master DataSAP IBP Planning Level
ibp-a03-03Master DataSAP IBP Planning Area
ibp-a03-04Master DataSAP IBP Planning Version
ibp-a03-05Master DataSAP IBP Planning View
ibp-a04-01Master DataSAP IBP Integration Model
ibp-a05-01Master DataSAP IBP Planning Operator

L2-B) Transaction

IDCategoryTitle
ibp-b01OverviewSAP IBP Transactions: Process Flow, Hierarchy & Relationships