Now accepting guest editorial from SAP, Oracle, Workday and ServiceNow practitioners.Pitch a guide
The Sign-Off Table

Lesson 2 of 6

The planning model: areas, key figures, versions

11 min

Listen to this lesson

0:00 / 16:27

Everything a planner sees in IBP comes from the planning area. SAP's learning material calls it the central configurable object: it brings together master data types, attributes, the time profile, key figures, planning levels and versions, and it defines how data is stored, calculated and aggregated. People often call it the planning model. If you can read a planning area, you can predict what a planning view will show and why.

The building blocks

ObjectWhat it isContoso example
AttributeA single field with a data type, such as product ID or brandPRDID, LOCID, CUSTID, PRODUCTFAMILY
Master data typeA set of attributes describing one entity; simple, compound, reference or externalProduct, Location, Customer; compound Location Product
Time profileThe buckets and their hierarchy (day, week, month, quarter, year)Weeks for demand sensing, months for S&OP
Planning levelThe combination of time and attributes at which a key figure is storedProduct / location / customer / month
Key figureA measurable value in time buckets, stored or calculatedSales history, statistical forecast, consensus demand
VersionA separate data set; the baseline plus optional versionsBaseline and an Upside version for a fleet tender
ScenarioA private or shared what-if copy of changes on a version, created by plannersWhat if Great Lakes orders 20% more in Q2

Planning area building blocks, from SAP's configuration model.

Simple master data types (product, location, customer) combine into compound types, and key figure values hang off those combinations per time bucket.
The Sign-Off Table · thesignofftable.com/academy/sap-scm-201

Stored and calculated key figures

A stored key figure holds data that is loaded or typed in: sales history from S/4HANA, a marketing adjustment entered by a planner. A calculated key figure is derived by a calculation from other key figures, for example consensus demand from the statistical forecast plus adjustments. Calculations can run at different planning levels, and that is where many surprises come from: a key figure calculated at product / location / month and then disaggregated to customer may not equal the sum you expect from customer-level inputs.

A simplified chain of key figures for demand: stored inputs feed a calculated consensus that is released downstream.
The Sign-Off Table · thesignofftable.com/academy/sap-scm-201

Worked example: aggregation and disaggregation

Contoso stores consensus demand for CMC-ALT-100 at product / location / customer / month. For Detroit (1710) in March, the customer values are Great Lakes Fleet Services 1,200, other fleet customers 1,800 and aftermarket 1,000, a total of 4,000 pieces. Sunita opens a view at product / location level and changes 4,000 to 4,400. IBP must push the extra 400 down to customers. With proportional disaggregation based on the existing values, Great Lakes gets 1,320, other fleet 1,980 and aftermarket 1,100. If the key figure's disaggregation mode were "equal split", each would get about 133 more instead. Same total, different customer plans.

Customer groupBeforeProportional (+10%)Equal split (+133.3)
Great Lakes Fleet Services1,2001,3201,333.3
Other fleet1,8001,9801,933.3
Aftermarket1,0001,1001,133.3
Total4,0004,4004,400

Illustrative course data: one change at product / location level, two disaggregation results.

Testers should record the disaggregation mode of every key figure planners edit, then test one change at an aggregate level and check the lower-level result against a hand calculation. This is the planning equivalent of checking a pricing condition.

Versions and scenarios

When a planning area is activated, the baseline version exists automatically. Administrators can add versions, such as an Upside version for a large fleet tender, and choose which key figures each version carries. Scenarios are lighter: a planner creates a what-if on top of a version, shares it with colleagues, and either promotes the changes or discards them. A frequent defect is a planner saving into the wrong version or scenario and reporting "lost" data; the data is there, in another data set.

A planning area must be activated before use and reactivated after each model change, which is why model changes need regression tests.
The Sign-Off Table · thesignofftable.com/academy/sap-scm-201
VersionScenario
Created byConfiguration (administrator)Planner, in the Excel add-in or web
DataComplete separate data set for chosen key figuresDelta of changes on top of a version
Typical useBaseline, upside, downside plansQuick what-if, shared for review
End of lifeCopied or cleared by jobPromoted to the version or deleted
Versions are designed data sets; scenarios are planners' what-ifs.
The Sign-Off Table · thesignofftable.com/academy/sap-scm-201

Step by step: reading a planning area before you test

  1. Open the planning area in the model configuration apps and note its status (active or inactive) and the time profile it uses.
  2. List the master data types and their key attributes. For CMCPA01: product, location, customer, and the compound types location product and customer product.
  3. Open the key figures planners will edit and record, for each, whether it is stored or calculated, its base planning level and its disaggregation settings.
  4. Follow every calculated key figure back to its inputs and note at which level the calculation runs.
  5. List the versions and which key figures each one carries; an Upside version without the capacity key figure cannot show capacity.
  6. Record all of this in the key figure catalog and agree it with Sunita before writing test cases.

This reading takes a morning and saves days. Most planning defects reported by testers in early cycles at Contoso were not defects at all: the tester expected a value at customer level for a key figure that was stored only at product / location level, or looked at the baseline while the planner worked in a version.

What would you do?

Sunita changes March demand for CMC-ALT-100 in Detroit from 4,000 to 4,400 at product / location level. Maria, the O2C key user, says the Great Lakes plan should not change because their order book is fixed. What should the team do?

Key points
  • The planning area holds master data types, attributes, time profile, planning levels, key figures and versions.
  • Stored key figures are loaded or typed; calculated ones are derived and can surprise at other levels.
  • Disaggregation mode decides how an aggregate change lands on detailed cells.
  • Versions are configured data sets; scenarios are planners' what-ifs on top of them.

Check your understanding · not graded

Lesson check

  1. 1. What happens to the baseline version when a planning area is activated?

  2. 2. Which key figure is typically calculated rather than stored?

  3. 3. Sunita raises a product / location total from 4,000 to 4,400. What decides how the 400 lands on customers?

  4. 4. What is a planning scenario?