Please see the SAP Analytics Approach document, section 'Documentation' for more information about the context of this document.
It is to be populated by the story owner and the reporting functional consultant collaboratively.
It does NOT describe business logic e.g. KPI definitions delivered by the data models (e.g. analytic models) that it consumes. This is covered in the Data Model Functional Specification
If a requirement is for a flat table, then this will be delivered as a story and this document may simply show the order of the columns. Where more detailed requirements for a story layout are known, this template will capture these requirements.
As story building is an iterative and agile process, it is expected that this document will be updated through the development process.
| Status | |
|---|---|
| Functional Specification Owner | CONNELLY-ext, Delia |
| Stakeholders | |
| Jira Request ID | [ERP-125] Business Case form to capture Project Financial Indicators - Jira |
| Jira Development (Build) ID | [ERP-263] Business Case form to capture Project Financial Indicators - Jira |
| Lean IX App Link | To be added when development reaches UAT |
| Business Process Reference (L4) | 10.01.03.01. Manage Initiatives and Items | Signavio |
| Parameter | Value |
|---|---|
| Application System (Delivery Tool) | SAC Story |
The Project Business Case captures key financial information about a project in a simplified and standardized format to enable:
The Business Case includes:
The Project Business Case must be completed for all financially driven projects.
This section is predominantly for planning stories and can be deleted if not applicable. Insert the flowchart and fill in the steps.

Step | Description | Comment |
|---|---|---|
| 1. | Create Item | A new Item is created in S4HANA. The Item master data is synch'd to SAC. |
| 2. | Maintain Project Cost | A time-phased Project Cost is required for all Portfolio Items. This is entered at Item level for new Items or copied from Detailed Planning for Items with a Project/WBS. Past periods are automatically over-written with actual costs. |
| 3. | Financial Driver? | If the Project has a financial driver, then a Business Case is required. |
| 4. | Complete Business Case* | The previously entered Project Cost is displayed in the Business Case (non-editable). Manual inputs to the Business Case are made as required. |
| 5. | Calculate Financial Indicators* | Financial Indicators such as NPV, MIRR and VCI are calculated from the business case inputs. |
| 6. | Calculate Project Score** | If the Project has a financial driver, Project Score is calculated based on the financial indicators from the Business Case. Otherwise, Project Score is calculated based on a Risk assessment. |
| 7. | Maintain Item | Portfolio Item master data is maintained throughout its lifecycle. |
| 8. | Next? | Various planning actions are required throughout the life of the Portfolio Item |
| 9. | FY Budget Request | FY Budget Request is maintained for Items requiring budget for the next Financial Year. This is an annual process for the relevant Items. |
| 10. | Stage Gate Funding Request | A Stage Gate is triggered. Depending on the Item Type and Stage Gate, this may involve a funding request. |
| 11. | Variation Funding Request | A Variation Funding Request is made mid-phase when supplementary budget is required. |
| 12. | Detailed Planning | During the life of the Item/Project a time-phased, detailed plan can be maintained at WBS Element level. This can be copied at Item level to Project Cost. Past periods are automatically over-written with actual costs. |
* Covered in this Functional Specification
** Referenced in this Function Specification, but details not included.
Content Ownership: Functional Consultant, Input from: Reporting & Analytics Consultant
The Project Business Case incorporates data drawn from the following sources:
The results are stored in DSP against the Portfolio Item.
An Overview Page for 'Portfolio Item Planning & Reporting' will include a link to the 'Portfolio Item Planning' Story:
| Story | Page # | Page | Functional Specification |
|---|---|---|---|
| Portfolio Item Planning | 1 | Project Cost (Item) | ERP-669 SAC Planning Portfolio Items |
| 2 | Project Cost (Cluster) | ERP-669 SAC Planning Portfolio Items | |
| 3 | Business Case (Item/Cluster) | ERP-263 SAC Project Business Case | |
| 4 | Detailed Planning (Item) | ERP-670 SAC Planning WBS Elements |
Further related planning Stories are accessed via the same 'Portfolio Item Planning & Reporting' Overview Page:
| Story | Page # | Page | Functional Specification |
|---|---|---|---|
| FY Budget Request | 1 | FY Budget Request (Item/Cluster) | ERP-669 SAC Planning Portfolio Items |
| |||
|
This page supports input of the Business Case and calculation of Financial Indicators and Project Score. It is also possible to display a previously saved snapshot of the Business Case.
Report Field Name | Mandatory/Optional | Prompt Type (Single Value, Multiple Single Values, Interval, Selection Option, Hierarchy) | Default Value(s) or Restrictions (please provide default value) |
|---|---|---|---|
| Item Id | Mandatory | Single Value Select from Hierarchy with option to filter by Item attributes such as Description, Person Responsible | |
| Snapshot Version | Optional | Single Value Select from existing Business Case snapshots for the Item |
N/a
Calculations are incorporated in the Layout tables below.
All currency amounts will be saved in the Item Currency with the necessary conversions applied:
All quantities will be saved in the selected Unit.
This section will contain a wire-frame of the page indicating the widgets on it. The wire-frame can be a draw-io diagram or a screenshot of e.g. an excel mock-up.
If there are multiple data models in the story, indicate which data models the widget takes data from at page or widget level.
Widget level details such as filters, dimensions, hierarchy usage, history, comparatives, targets, thresholds, top N etc can also be included. N.B. This level of detail is not mandatory and often changes through the iterative development process. For tables, indicate the number of expected rows.
Refer here for a mock-up of the Business Case: Business Case Template - Google Sheets
If multiple data sources consumed by story:
Widget | Data Model | Field | Filter |
|---|---|---|---|
Header | PPM_ITEM | Project Name: CGPL_TEXT-TEXT1 | |
| PPM_ITEM | Project ID /RPM/ITEM_D-EXTERNAL_ID | ||
| PPM_ITEM | Project Owner: /RPM/ITEM_D-ZXX14 | Derive Personnel Name from Position | |
| PPM_ITEM | /RPM/ITEM_D-CATEGORY | Retrieve description from RPM_PROJ_CAT | |
Time Horizon | Years to be displayed in the time horizon are repeated for each table/widget and determined as follows: If Year of Project Kick=Off not blank First year = Year of Project Kick-Off else First year = year of Planned Start (/RPM/ITEM_D-PLANNED_START) Final year = End Year for NPV Calculation The following years are highlighted in the time horizon:
| ||
0. Preliminary Information | PPM_ITEM | Year of Project Kick-Off | Mandatory, format YYYY Default to year of /RPM/ITEM_D-PLANNED_START |
| PPM_ITEM | First Year of Commercial Sales | Optional, format YYYY If entered, must be >= Year of Project Kick-Off | |
| PPM_ITEM | Time to Full Maturity (Years) | Optional, integer If entered, must be >= 0 | |
| PPM_ITEM | Discount Rate (WACC) | Mandatory, format % If blank, take default from /SYQ/T_SCORING_PARAMS-PARAM_VALUE where:
Must be >= 0 and <= 100 | |
| SCORING_PARAMETERS | Years for NPV Calculation: /SYQ/T_SCORING_PARAMS-PARAM_VALUE | Where:
| |
| PPM_ITEM | Currency | Mandatory Default to Group Currency (EUR) and allow to switch to Item currency (/RPM/ITEM_D-CURRENCY) | |
| Currency Multiplier | Mandatory Select from list of defined multipliers; 1, 1k, 1m If blank, default to 1k Derive Currency Factor and Currency Display: If Currency Multiplier = 1 Currency Factor = 1 Currency Display = Currency ElseIf Currency Multiplier = 1k Currency Factor = 1,000 Currency Display = "k" & Currency Else (Currency Multiplier = 1m) Currency Factor = 1,000,000 Currency Display = "m" & Currency | ||
| PPM_ITEM | Reinvestment Rate | Mandatory, format % If blank, default to Discount Rate (WACC) Must be >= 0 and <= 100 | |
| PPM_ITEM | End Year for NPV Calculation | Calculated: If First Year of Commercial Sales = 0 then End Year for NPV Calculation = Year of Project Kick-Off + Years for NPV Calculation Else End Year for NPV Calculation = First Year of Commercial Sales + Years for NPV Calculation | |
| PPM_ITEM | Probability of Commercial Success | Optional, format % If entered, must be >= 0 and <= 100 | |
| PPM_ITEM | Probability of Technical Success | Optional, format % If entered, must be >= 0 and <= 100 | |
| PPM_ITEM | Risk Adjustment | Mandatory, format % Must be >= 0 and <= 100 | |
| PPM_ITEM | Working Capital/Sales Ratio | Mandatory, format % Must be >= 0 and <= 100 If blank, take default from /SYQ/T_SCORING_PARAMS-PARAM_VALUE where:
| |
| PPM_ITEM | EBITDA at Maturity | Optional, format as per Currency | |
1. Project Cost | Project Cost - Opex Currency /RPM/FIN_PLAN-CURRENCY | Display-only; Currency Display | |
| PPM_ITEM | Project Cost - Opex: /RPM/FIN_PLAN-AMOUNT | Display-only, format as per Currency Filter:
| |
Project Cost - Capex Currency /RPM/FIN_PLAN-CURRENCY | Display-only; Currency Display | ||
| PPM_ITEM | Project Cost - Capex: /RPM/FIN_PLAN-AMOUNT | Display-only, format as per Currency Filter:
| |
Total Project Costs Currency | Display-only; Currency Display | ||
| Total Project Costs | Display-only, format as per Currency Calculated: Project Cost - OPEX + Project Cost - CAPEX | ||
2. Project P&L Impact | PPM_ITEM | Price/Cost Multiplier | Mandatory Select from list of defined multipliers; 1, 1k, 1m Derive Price/Cost Factor: If Currency Multiplier = 1 Price/Cost Factor = 1 Price Currency Display = Currency ElseIf Currency Multiplier = 1k Price/Cost Factor= 1,000 Price Currency Display ="k" & Currency Else (Currency Multiplier = 1m) Price/Cost Factor = 1,000,000 Price Currency Display ="m" & Currency |
| PPM_ITEM | Unit | Mandatory Select from list of defined UOM | |
| PPM_ITEM | Product Volumes Unit: /RPM/FIN_PLAN-UNIT | Display-only, same as selected Unit Filter:
| |
| PPM_ITEM | Product Volumes: /RPM/FIN_PLAN-QUANTITY | Optional, format as quantity in selected Unit Filter:
| |
| PPM_ITEM | Product Selling Price Unit: /RPM/FIN_PLAN-UNIT | Display-only, derived as Price Currency Display / Unit Filter:
| |
| PPM_ITEM | Product Selling Price: /RPM/FIN_PLAN-AMOUNT | Optional, format is Currency per selected Unit Filter:
| |
Sales Forecast Currency /RPM/FIN_PLAN-CURRENCY | Display-only; Currency Display | ||
| PPM_ITEM | Sales Forecast | Display-only Calculated per year: Product Volumes * Product Selling Price * Price/Cost Factor / Currency Factor | |
| PPM_ITEM | Product Variable Cost Unit: /RPM/FIN_PLAN-UNIT | Display-only, derived as Price Currency Display / Unit Filter:
| |
| PPM_ITEM | Product Variable Cost: /RPM/FIN_PLAN-AMOUNT | Optional, format as per Product Selling Price Filter:
| |
| Contribution Currency /RPM/FIN_PLAN-CURRENCY | Display-only; Currency Display | |
2. Project P&L Impact | PPM_ITEM | Contribution | Display-only, format as per Currency Calculated per year: Product Volumes * (Product Selling Price - Product Variable Cost) * Price/Cost Factor / Currency Factor |
| PPM_ITEM | Contribution in % of Sales | Display-only, format as % Calculated per year: Contribution / Sales Forecast * 100 | |
Total Fixed Costs Currency /RPM/FIN_PLAN-CURRENCY | Display-only; Currency Display | ||
| PPM_ITEM | Total Fixed Costs: /RPM/FIN_PLAN-AMOUNT | Optional, format as per Currency Filter:
| |
| 3. Cash Impacts | Working Capital Currency | Display-only; Currency Display | |
| PPM_ITEM | Working Capital | Display-only, format as per Currency Calculated per year: Working Capital/Sales Ratio * Sales Forecast | |
Change in Working Capital Currency | Display-only; Currency Display | ||
| PPM_ITEM | Change in Working Capital | Display-only, format as per Currency Calculated per year: Working Capital/Sales Ratio * (Sales Forecast this year - Sales Forecast last year) | |
Other Cash Impacts Currency /RPM/FIN_PLAN-CURRENCY | Display-only; Currency Display | ||
| PPM_ITEM | Other Cash Impacts: /RPM/FIN_PLAN-AMOUNT | Optional, format as per Currency Filter:
| |
| 4. Subsidies | Subsidy Currency /RPM/FIN_PLAN-CURRENCY | Display-only; Currency Display | |
| PPM_ITEM | Subsidy: /RPM/FIN_PLAN-AMOUNT | Optional, format as per Currency Filter:
| |
| 5. Interim Calculations | Year XXXX - Year YYYY | Display only Year XXXX = Year of Project Kick-Off Year YYYY = End Year for NPV Calculation | |
| PPM_ITEM | Discount Period | Display-only, format as numeric, 1 decimal Calculated per year: Retrieve First Discount Period from /SYQ/T_SCORING_PARAMS-PARAM_VALUE where:
If Year = Year of Project Kick-Off then Set Discount Period to First Discount Period Else Add 1 to previous year Discount Period | |
Cashflow Currency | Display-only; Currency Display | ||
| PPM_ITEM | Cashflow | Display-only, format as per Currency Calculated per year: Cashflow = Contribution - Total Project Costs - Change in Working Capital - Other Cash Impact | |
Discounted Cashflow Currency | Display-only; Currency Display | ||
| PPM_ITEM | Discounted Cashflow | Display-only, format as per Currency Calculated per year: Cashflow / (1 + Discount Rate) ^ Discount Period | |
Risk Adjusted Contribution Currency | Display-only; Currency Display | ||
| PPM_ITEM | Risk Adjusted Contribution | Display-only, format as per Currency Calculated per year: Risk Adjusted Contribution = Contribution * Risk Adjustment % | |
Risk Adjusted Cashflow Currency | Display-only; Currency Display | ||
| PPM_ITEM | Risk Adjusted Cashflow | Display-only, format as per Currency Calculated per year: Risk Adjusted Cashflow = Risk Adjusted Contribution - Total Project Costs - Change in Working Capital | |
Risk Adjusted Discounted Cashflow Currency | Display-only; Currency Display | ||
| PPM_ITEM | Risk Adjusted Discounted Cashflow | Display-only, format as per Currency Calculated per year: Risk Adjusted Cashflow / (1 + Discount Rate) ^ Discount Period | |
Cumulative Discounted Cashflow Currency | Display-only; Currency Display | ||
| PPM_ITEM | Cumulative Discounted Cash Flow | Display-only, format as per Currency Calculated per year: Discounted Cashflow for this year + Cumulative Discounted Cash Flow for previous year | |
| PPM_ITEM | Payback Period (Days) | Display-only, format as per Currency Calculated per year: If Cumulative Discounted Cash Flow = 0 then Payback Period (Days) = zero ElseIf Cumulative Discounted Cash Flow < 0 then Payback Period (Days) =365 ElseIf previous year Cumulative Discounted Cash Flow > 0 then Payback Period (Days) = zero Else Payback Period (Days) = (previous year Cumulative Discounted Cash Flow * -1) / (Cumulative Discounted Cash Flow - previous year Cumulative Discounted Cash Flow) * 365 | |
Present value -ve Cashflow Currency | Display-only; Currency Display | ||
Present value -ve Cashflow | Display-only, format as per Currency Calculated per year: If Cash Flow >= 0 then Present value -ve Cashflow = zero Else Present value -ve Cashflow = Cashflow / (1 + Discount Rate) ^ Discount Period | ||
Future value +ve Cashflow Currency | Display-only; Currency Display | ||
Future value +ve Cashflow | Display-only, format as per Currency Calculated per year: If Cash Flow <= 0 then Present value +ve Cashflow = zero Else Present value +ve Cashflow = Cashflow * (1 + Reinvestment Rate) ^ (# Cashflow Periods - Discount Period) | ||
| # Cashflow Periods | Derived: # Cashflow Periods = End Year for NPV Calculation - Year of Project Kick-Off + 1 | ||
| 6. Financial Indicators | PPM_ITEM | Year XXXX - Year YYYY | Where XXXX = Year of Project Kick-Off and YYYY = End Year for NPV Calculation |
| PPM_ITEM | NPV (Net Present Value) | Display-only, format as per Currency Calculated: NPV (Net Present Value) = Sum (Discounted Cashflow) for all years | |
NPV Currency | Display-only; Currency Display | ||
| PPM_ITEM | Risk Adjusted NPV | Display-only, format as per Currency Calculated: Risk Adjusted NPV = Sum (Risk Adjusted Discount Cashflow) for all years | |
Risk Adjusted NPV Currency | Display-only; Currency Display | ||
| PPM_ITEM | MIRR (Modified Internal Rate of Return) | Display-only, format as per Currency Calculated: FVCF = Sum (Present value +ve Cashflow) for all years PVCF = Sum (Present value -ve Cashflow) for all years * -1 MIRR = (FVCF / PVCF) ^ (1 / # Cashflow Periods) -1 | |
| PPM_ITEM | Discounted Payback Period | Display-only, format as per Currency Calculated: Discounted Payback Period = Sum (Playback Period) for all years / 365 | |
| PPM_ITEM | VCI (Value Creation Index) | Display-only, format as per Currency Calculated: VCI = NPV / Sum (Total Project Costs) for all years | |
| PPM_ITEM | Project Score | Display-only, numeric Refer to ERP-669 SAC Planning Portfolio Items for the calculation | |
| 7. Comments and Justification | PPM_ITEM_Long_Text | CGPL_TEXT-LTXT | Optional, long text commentary to support Business Case Filter:
|
Refresh & Calculate
On clicking 'Refresh & Calculate', the Project Cost rows are updated with the latest values (copied from the 'Project Cost' Financial View of the Portfolio Item) and all calculations are re-run.
Calculate & Save
On clicking 'Calculate & Save', the following automations occur all calculations are performed and the results saved.
Save as Version
On clicking 'Save as Version' a copy of the Business Case is saved. This is a non-editable version which can be displayed for future reference.
A Version is identified by the date & time it was created.
As story page N.
Details any filters that apply to the entire story. N.B. Most mandatory (e.g. security variables) should be applied in Datasphere.
Report Field Name | Mandatory/Optional | Prompt Type (Single Value, Multiple Single Values, Interval, Selection Option, Hierarchy) | Default Value(s) or Restrictions (please provide default value) |
|---|---|---|---|
This section lists the data models consumed by the story and links to the functional specification describing them.
| Data Model Technical Name | Data Model Description | Jira Development ID | Link to Data Model Functional Specification |
|---|---|---|---|
| (Filled when available) | Text for data model | ||
The Business Case can be completed by:
Content Ownership: Functional Consultant, Input from: Reporting & Analytics Consultant
The following assumptions have been made:
Indicate any dependencies or constraints that may impact development, in terms of requirements from internal or external applications or teams, limited access to legacy system, time constraints or data restrictions. Also, please specify schedule dependencies e.g. interface or batch jobs that must run prior to execution.
Specify any special requirements or considerations that may impact the development based on specific locations, regulatory compliance or system limitations. Clearly outline requirements e.g. localization rules for countries like China
If the development interacts with third-party systems such as Icertis, describe any additional integration, security or authentication considerations that must be taken into account.
The Business Case is required for financially driven Portfolio Item and will be completed/updated prior to each Stage Gate.
N.B. Unless this is a planning story, the testing should cover layout and user experience NOT data values for metrics created in the data model. Data model values will be tested in conjunction with the data model specification.
Please provide some guidance and/or test data to help the developer unit test the report. Please include both positive and negative testing (to validate error situations handling)
List any considerations essential for application test planning (e.g., test this before ABC along with DEF separate from GHI).
The developer will need to test repeatedly, so where appropriate provide instructions to reverse the actions performed so the test may be run again, or explain how to create new input data to the test. In particular, the developer will need logons for test users representing the various roles within the approval process.
| ID | Condition | Expected Results |
|---|---|---|
| 1 | Item is selected which has no previous Business Case. | Business Case is presented with default values and Project Costs pre-populated. |
| 2 | All required data is entered. | Entered data is validated as expected. |
| 3 | User clicks 'Calculate & Save' | The calculations are performed and data is saved. |
| 4 | Item is selected which has a previously saved Business Case. | Business Case is presented with previously entered data. Calculations are re-run with same results as before. |
| 5 | Item is selected which has a previously saved Business Case. Input data is changed. User clicks 'Calculate & Save' | Calculations are re-run for the changed data with new results. |
| 6 | Project Cost is updated for an Item which has a previously saved Business Case. Business Case is reopened. User clicks 'Refresh' & Calculate'. | Initially, the Business Case is displayed with the previously saved data, including Project Costs. Onn 'Refresh & Calculate' the latest Project Cost is copied into the Business Case and calculations re-run. |
| 7 | User clicks 'Calculate & Save' | The calculations are performed and data is saved, over-writing any previous data. |
| 8 | Use clicks 'Save as Version' | The current version of the Business Case is taken with date & time stamp. |
| 9 | A Business Case Version is selected for display. | The Version is displayed with all information unchanged. The data in non-editable. |
Prerequisites for testing:
Description of requirements not covered by topics above
Insert links and references to other documents which are relevant when trying to understand this decision and its implications. Other decisions are often impacted, so it's good to list them here with links. Attachments are also possible but dangerous as they are static documents and not updated by their authors.
