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

SAP IBP Planning View

A Planning View is the SAP IBP object that defines a specific, reusable screen layout — a row/column/filter arrangement of Key Figures — through which a planner actually views, enters, and edits planning data. It is the final object in this five-article Phase 2 group, and structurally the widest-fan-in object alongside Planning Area itself: a single Planning View is built directly against an activated Planning Area, scoped to one Version, and populated with a chosen set of Key Figures. Where the prior four articles (Key Figure, Planning Level, Planning Area, Version) covered the modeling layer a planner rarely touches directly, this article covers the consumption layer sitting on top of all of them — what the planner actually sees, and the two channels (Excel Add-in and Planner Workspace) that render the same configured view.


Part 1: Planning View — Core Concepts (All Modules)

1.1 What Is the Planning View?

Hub-and-spoke diagram showing Planning View at center, connected to Planning Area, Version, Key Figure, and its two consumption channels Excel Add-in and Planner Workspace

A Planning View holds no data of its own — it is a saved definition of which Key Figures appear, how they are arranged into rows/columns, what filters narrow the data down by default, and whether the resulting grid is editable. Once defined, it becomes the object a planner opens by name to work with a specific slice of a specific Version’s data.

AspectDetails
RoleA named, reusable screen layout (Key Figures + row/column arrangement + filters + edit permission) through which planners view and edit planning data
Prerequisite inputsThree — Planning Area, Version, and Key Figure — tying Planning View for the widest fan-in of any object in this model, alongside Planning Area itself
Where it’s configuredThe Configure Planning Views app (per the internal knowledge base’s Master Process table); administrators/configurators design the layout and select displayed Key Figures and filter conditions here
Consumption channelsTwo — the SAP Integrated Business Planning add-in for Microsoft Excel (primary, SAP-documented channel) and the Planner Workspace app (Fiori/web-based counterpart) — the same configured View ID is renderable through either
ClassificationThe terminal object in this article group — no further downstream dependent within the Phase 2 series is covered here

1.2 Consumption Channels — Excel Add-in vs. Planner Workspace

Two-column comparison of the SAP IBP Planning View consumption channels: Excel Add-in and Planner Workspace

A Planning View is not tied to a single client application — the same View ID, Layout, Key Figures, Default Filters, and Edit Mode settings can be opened through either of two distinct consumption channels. Which channel a planner reaches for shapes their day-to-day workflow more than any other single choice in this article.

ChannelPurposeUse CaseKey Behavior
Excel Add-inThe primary, SAP-documented consumption channelDay-to-day forecasting, formula-driven analysis, favorite/template-driven planning workAdds a dedicated Planning View ribbon group to the SAP IBP Excel tab; supports native Excel formulas layered on top of Key Figure cells, multiple views coexisting on one worksheet, and saving frequently-used views as favorites
Planner WorkspaceThe browser-based, Fiori/web counterpartDashboard-style monitoring, alert-driven planning, no-install accessEmbeds a Planning View alongside other component types — a custom-alerts overview, analytics charts — in one configurable workspace layout; components can interact (e.g. a Key Figure matching a triggered alert is highlighted directly inside the embedded view)

Design principle: These are two rendering channels for one underlying object, not two different Planning View types. Public SAP documentation describes the Planner Workspace’s embedded planning view, alert overview, and analytics chart as separate, composable components laid out together in one workspace — not as a formally distinct “Analytics/Dashboard view” type sitting beside “Planning View.” This article does not assert that taxonomy; the View ID / Layout / Key Figures / Default Filters / Edit Mode settings covered in Section 2.1 remain the only documented configuration surface for a Planning View, regardless of which channel renders it.


1.3 Organizational Levels and Data Hierarchy

Zone crop from the SAP IBP master data landscape showing Planning View positioned as a sibling of Version directly under Planning Area, with dashed reference arrows to Version and Key Figure

Data hierarchy with a concrete example

Client (SAP IBP Tenant)
   │
   └── Planning Area "PA-DP01" — Demand Planning Planning Area          (IBP-A03-03)
          │
          ├── Version "WORKING01" — Working                              (IBP-A03-04)
          │
          ├── Key Figure "SALESFCST" — Sales Forecast Qty                 (IBP-A03-01)
          │
          └── Planning View "PV-DP-WEEKLY" — Weekly Demand Planning View
                 │      [Row Axis: Product, Column Axis: Week, Filter: Location]
                 │
                 ├── scoped to ──> Version "WORKING01"
                 └── displays ──> Key Figure "SALESFCST"

   (rendering channel, not a Planning Area child — see Section 1.2 / 2.2-2.3)
   Excel Add-in worksheet, or Planner Workspace layout ── renders ──> Planning View "PV-DP-WEEKLY"

Design principle: Planning Area has a direct 1:N relationship into Planning View, the same as its 1:N relationship into Version — structurally, Planning View is a sibling of Version, not a child of Version, even though Version is also one of Planning View’s three prerequisite inputs. That distinction matters: a Planning View does not contain a Version, it references one, alongside a set of Key Figures — hence the dashed “scoped to” / “displays” arrows rather than nesting. The Excel Add-in and Planner Workspace are rendering channels, not org-hierarchy nodes at all; they sit outside the tree entirely, shown here only to make clear that neither channel owns the Planning View object itself.


1.4 Integration with Other Master Data Objects

Hub-and-spoke diagram showing Planning View at center connected to Planning Area, Version, Key Figure, Planning Level, Excel Add-in, and Planner Workspace

A Planning View does not stand alone — it is the presentation layer built directly on top of the three prior Phase 2 objects, plus an indirect dependency on Planning Level through the attributes available for filtering.

ObjectRelationshipPractical Notes
Planning AreaDirect prerequisite — a Planning View is built against one activated Planning Area’s containerFull mechanics in IBP-A03-03. Planning Area has a direct 1:N relationship into Planning View, in addition to its 1:N relationship into Version.
VersionDirect prerequisite — a Planning View is scoped to display and edit one Version’s data at a timeFull mechanics in IBP-A03-04. A planner typically opens the same View definition against different Versions (e.g. “Working” to enter numbers, “Simulation” to test a what-if).
Key FigureDirect prerequisite — a Planning View displays a chosen set of Key Figures on its row/column axesFull mechanics in IBP-A03-01. The Key Figures field in Section 2.1 is simply the inclusion list; each Key Figure’s own Storage Type and Aggregation/Disaggregation behavior was already fixed upstream.
Planning LevelIndirect dependency, via attributes — the Default Filters dropdown in a Planning View operates on the attributes exposed by the underlying Planning Level, not on arbitrary fieldsFull mechanics in IBP-A03-02. Getting a Planning Level’s attribute set right upstream is what makes a Planning View’s filter options meaningful downstream.
Excel Add-in / Planner WorkspaceConsumption channels, not master data objects — the two applications a planner uses to open a configured Planning ViewCovered in full in Sections 2.2 and 2.3 of this article — the only place in this series these client applications are documented in depth.

Part 2: IBP-Specific Field Details

2.0 Scope of IBP Ownership

Checklist showing IBP consultant ownership across Planning View configuration sections: View Configuration, Excel Add-in Consumption, and Planner Workspace Consumption

Data SectionIBP InvolvementNotes
View Configuration◎ OwnerThe five core settings set when a Planning View is created: View ID, Layout, Key Figures, Default Filters, Edit Mode
Excel Add-in Consumption◎ OwnerRow/column axis layout, favorites, templates, formula-enabled cells, and the ~2,000-row × 24-column performance guidance a consultant designs within
Planner Workspace Consumption◎ OwnerEmbedding a configured Planning View inside a browser-based Planner Workspace layout, alongside alert overviews and analytics components

Legend: ◎ = Owner / Critical


2.1 View Configuration

Checklist of the five core Planning View configuration settings: View ID, Layout, Key Figures, Default Filters, Edit Mode

These are the five fields the internal knowledge base’s Planning View settings table lists — set inside the Configure Planning Views app when the view is first designed.

FieldDescriptionPractical Usage
View IDUnique identifier for the Planning ViewAdopt a naming convention that reflects the planning process it serves (e.g. PV-DP-WEEKLY for a weekly demand planning view) — planners select views by this name, so keep it business-readable, not just technical.
LayoutThe row/column/filter arrangement of the viewLayout is fully configurable per view — a common pattern places Key Figures on the column axis and time periods on the row axis, but any assignment is valid. Design this around how the planner reads the grid, not around convenience during configuration.
Key FiguresWhich Key Figures are displayed in the viewEach Key Figure included here was already defined with its own Storage Type and base Planning Level (IBP-A03-01) — this field is simply the display/edit inclusion list for this specific view.
Default FiltersThe initial filter conditions applied when the view opensOperates on the attributes exposed by the underlying Planning Level (Section 1.4) using operators such as “is equal to” or “is not equal to” — a planner can broaden or narrow the filter after opening, but a well-chosen default saves repetitive re-filtering every session.
Edit ModeWhether the view is editableOnly Stored (or Stored+Calculated hybrid) Key Figures can actually accept manual input regardless of this setting (IBP-A03-01, Section 1.2) — flipping Edit Mode on for a view built entirely from Calculated Key Figures has nothing to write to.

2.2 Excel Add-in Consumption

Stack layered diagram showing SAP IBP Excel Add-in Planning View features: row/column axis layout, attribute-based filters, formula cells, favorites/templates, and the row/column performance guidance

The SAP Integrated Business Planning add-in for Microsoft Excel is the primary, SAP-documented channel through which planners and analysts work with Planning Views. A dedicated Planning View ribbon group in the SAP IBP Excel tab provides creation/customization, favorites, and filter management.

Field / ConceptDescriptionPractical Usage
Row / Column Axis LayoutMembers (Key Figures, time periods, Planning Level attributes such as Product or Customer) are placed on a row axis and a column axis, fully configurable per viewA common pattern places Key Figures on columns and time periods on rows, but attributes can also be placed on either axis (e.g. breaking out receipts by Product and Customer on the column axis) — design the axis assignment around the review workflow, not a fixed convention.
Attribute-Based FilterUsers define which planning combinations display by specifying attribute values with operators like “is equal to” / “is not equal to”This is the mechanical link to Section 1.4’s Planning Level dependency — a filter can only offer the attributes the view’s underlying Planning Level actually exposes.
Formula CellsUsers can add extra rows/columns with native Excel formulas, which the add-in converts and propagates into the IBP formula layerUseful for row/column totals or derived figures layered on top of the plain Key Figure display, without requiring a new Calculated Key Figure to be built server-side for a one-off view.
Repeat Row/Column HeadersNested-axis views can repeat outer-dimension headers on every inner row/columnTurn this on when the resulting grid will subsequently be Excel-filtered or exported — without it, a filtered/exported subset loses the outer grouping context.
Favorites & TemplatesFrequently-used views can be saved as favorites; administrators distribute VBA-based, formula-based, or macro-free Planning View templates to drive end-user adoptionMost end users do not build a view’s row/column/filter layout from scratch — they open a distributed template “from favorites.” Formula-based templates have a documented constraint: embedded chart functionality only processes up to 300 rows, tighter than the general performance guidance below.
Performance GuidanceSAP-documented sizing guidance: keep a Planning View to roughly under 2,000 rows × 24 columns for acceptable refresh performanceAn example view of 80 Key Figures × 24 months refreshes in about 5 seconds under this guidance. A broad Planning Level scope (many attribute combinations) multiplied by many Key Figures can exceed this quickly — validate row/column/filter scope against this ceiling during design, not after planners report slow refreshes.

Coverage note: SAP Note 1790530 is cited in SAP’s own sample-template documentation as the authoritative reference for Planning View template development best practices. It requires an S-user login and was not accessible under this pipeline’s public-knowledge-only constraint — any specific technical recommendations from that note are omitted here rather than guessed at.


2.3 Planner Workspace Consumption

Two-column comparison showing the Planner Workspace app’s composable layout: embedded Planning View, custom-alerts overview, and analytics components

The Planner Workspace app is SAP’s Fiori/web-based counterpart to the Excel add-in: a configurable, browser-accessible environment where planners plan, review alerts, and run simulations without needing Excel installed.

Field / ConceptDescriptionPractical Usage
Planner Workspace appA configurable, browser-based work environment for planning, alert review, and simulationThe no-install, dashboard-style alternative to the Excel Add-in — useful for planners who need quick, occasional access rather than deep formula-driven analysis.
Embedded Planning View componentThe same View ID, Layout, Key Figures, Default Filters, and Edit Mode settings from Section 2.1, rendered as one component inside a Planner Workspace layoutConfiguring a Planning View once in Section 2.1 is sufficient for both channels — there is no separate “Planner Workspace version” of the view’s settings to maintain.
Custom-alerts overview componentA separate, composable component that can be laid out alongside an embedded Planning View in the same workspaceComponents can interact: a Key Figure matching a triggered custom alert can be highlighted directly inside the embedded Planning View, giving the planner a visual cue without leaving the workspace.
Analytics componentsAnalytics charts are a separate, composable component type available within a Planner Workspace layout, alongside the embedded Planning View and alerts overviewDo not present this as a distinct “Analytics/Dashboard view” type of Planning View — SAP documentation treats it as one more component a workspace can lay out beside a Planning View, not a variant of the Planning View object itself (see Section 1.2 design principle).

Coverage note: Direct fetches of the Planner Workspace Help Portal pages during research returned only client-side tracking script rather than rendered documentation, so the findings above are drawn from corroborating indexed search snippets rather than a single fully-verified page render. Treat the component-composition framing as well-corroborated but not independently confirmed against a raw page fetch.


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