Project Earned Value Report (CPI, SPI and Estimate at Completion)
Short answer: A custom ALV report that shows, per WBS element, planned value (PV), earned value (EV), actual cost (AC), the cost and schedule performance indices (CPI, SPI) and the estimate at completion (EAC) with traffic lights. The percentage of completion is derived from confirmed work hours on network activities, so it works without a progress analysis setup.
- Estimated effort
- M · 5–7 working days
- System
- ECC and S/4HANA
- Tables
- 7
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
CNE5 offers earned value analysis, but it needs a progress version, measurement methods and a regular progress calculation with CNE1; many customers do not have this setup. Budget/actual reports such as S_ALR_87013558 do not calculate earned value, CPI, SPI or EAC. The custom report derives these indicators directly from plan cost, actual cost and confirmed work hours.
Who uses it? Project managers, project control (PMO) teams and project cost accounting.
Closest standard alternatives
- CNE5 Progress Analysis. Progress analysis shows earned value; needs a progress version, measurement methods and a CNE1 run.
- S_ALR_87013558 Budget/Actual/Commitment/Remaining Plan/Assigned. Shows budget, actual and commitment; does not calculate EV, CPI, SPI or EAC.
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| PRPSWBS Element Master Data | WBS element: external number, description, level, object number (driving table) | — | ECC + S/4 |
| PROJProject Definition | Project definition and project manager | PROJ-PSPNR = PRPS-PSPHI | ECC + S/4 |
| COSPCO Object: Cost Totals for External Postings | Periodic plan (WRTTP 01) and actual (WRTTP 04) costs | COSP-OBJNR = PRPS-OBJNR | ECC + S/4 |
| BPGETotals Record for Overall Value (CO Object) | Overall budget (WRTTP 41), if chosen as BAC | BPGE-OBJNR = PRPS-OBJNR | ECC + S/4 |
| AFVCOperation within an Order | Network activities assigned to the WBS element | AFVC-PROJN = PRPS-PSPNR | ECC + S/4 |
| AFVVQuantities, Dates and Values of Order Operations | Planned and confirmed work of the activity | AFVV-AUFPL = AFVC-AUFPL AND AFVV-APLZL = AFVC-APLZL | ECC + S/4 |
| I_WBSElementBasicDataWBS Element Basic Data | CDS view that can replace PRPS in S/4HANA | WBSElementInternalID = PRPS-PSPNR | S/4HANA only |
S/4HANA notes
- COSP → ACDOCA: In S/4HANA COSP is a view, not a table; actual totals are calculated from ACDOCA.
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_PSPID | Project | Range / multiple | PROJ-PSPID | Yes | P-26015 |
| S_POSID | WBS element | Range / multiple | PRPS-POSID | No | P-26015-02* |
| S_VERNR | Responsible person number | Range / multiple | PRPS-VERNR | No | 12 |
| S_PBUKR | Company code | Range / multiple | PRPS-PBUKR | No | 1000 |
| P_KEYDT | Key date (for PV and AC) | Single value | — | Yes | 31.10.2026 |
| P_VERSN | Plan version | Single value | COSP-VERSN | No | 0 |
| P_STUFE | Lowest WBS level to show | Single value | PRPS-STUFE | No | 2 |
| R_BACPL | BAC = total plan cost | Radio button | — | No | X |
| R_BACBU | BAC = overall budget | Radio button | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Project | PROJ-PSPID |
| 2 | WBS element | PRPS-POSID |
| 3 | Description | PRPS-POST1 |
| 4 | Responsible | PRPS-VERNA |
| 5 | BAC | Calculated Σ COSP plan (WRTTP 01) or BPGE-WTGES (WRTTP 41) |
| 6 | Planned value (PV) | Calculated COSP plan cost of the periods up to the key date |
| 7 | Completion % | Calculated Σ AFVV-ISMNW ÷ Σ AFVV-ARBEI × 100 (max. 100) |
| 8 | Earned value (EV) | Calculated BAC × completion % |
| 9 | Actual cost (AC) | Calculated COSP actual cost up to the key date (WRTTP 04) |
| 10 | CPI | Calculated EV ÷ AC |
| 11 | SPI | Calculated EV ÷ PV |
| 12 | Estimate at completion (EAC) | Calculated BAC ÷ CPI |
| 13 | Variance at completion (VAC) | Calculated BAC − EAC |
| 14 | Currency | COSP-TWAER |
| 15 | Status | Calculated CPI or SPI < 0.90 red; 0.90–0.97 yellow; above green |
Sample output
| Project | WBS element | Description | Responsible | BAC | Planned value (PV) | Completion % | Earned value (EV) | Actual cost (AC) | CPI | SPI | Estimate at completion (EAC) | Variance at completion (VAC) | Currency | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| P-26015 | P-26015-01 | Engineering | Proje Lideri A | 1,200,000 | 900,000 | 80 | 960,000 | 1,010,000 | 0.95 | 1.07 | 1,263,158 | -63,158 | TRY | Yellow |
| P-26015 | P-26015-02 | Procurement and fabrication | Proje Lideri B | 3,400,000 | 2,100,000 | 52 | 1,768,000 | 2,260,000 | 0.78 | 0.84 | 4,358,974 | -958,974 | TRY | Red |
| P-26015 | P-26015-03 | Installation | Proje Lideri C | 850,000 | 120,000 | 16 | 136,000 | 118,000 | 1.15 | 1.13 | 739,130 | 110,870 | TRY | Green |
| P-26022 | P-26022-01 | Site preparation | Proje Lideri D | 540,000 | 400,000 | 70 | 378,000 | 395,000 | 0.96 | 0.95 | 562,500 | -22,500 | TRY | Yellow |
How does the report work?
- PROJ and PRPS are read by project, WBS element, responsible person and company code; WBS elements down to the selected level (STUFE) are taken.
- BAC (budget at completion): depending on the radio button, the total plan cost in COSP (WRTTP 01, selected version) or the overall budget in BPGE (WRTTP 41).
- PV = plan cost of the periods up to the key date (COSP-WKG001…WKG016 of the relevant fiscal years). AC = actual cost up to the same periods (COSP WRTTP 04).
- Percentage of completion (POC) = Σ confirmed work (AFVV-ISMNW) ÷ Σ planned work (AFVV-ARBEI) of the network activities assigned to the WBS element (AFVC-PROJN), capped at 100%. EV = BAC × POC.
- CPI = EV ÷ AC, SPI = EV ÷ PV, EAC = BAC ÷ CPI, VAC = BAC − EAC. A CPI or SPI below 0.90 shows red, 0.90–0.97 yellow and above that green. Values are rolled up to the project and higher WBS levels.
Performance notes
Read COSP in one pass with the WBS object numbers (OBJNR) and WRTTP 01/04; sum the period columns in ABAP. Read AFVC by PROJN and AFVV with a JOIN on the AUFPL/APLZL key. For multi-project portfolios a weekly background job is recommended.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the WBS element opens CJ20N; double-clicking the actual cost opens CJI3.
- Export to Excel
- Runs as a background job
- Send the result by email WBS elements with a red light can be sent weekly to the project manager and the PMO.
Authorization objects
- C_PROJ_KOKProject display authorization by controlling area
- C_PRPS_KOKWBS element authorization by controlling area
- C_PRPS_VNRWBS element authorization by responsible person
Frequently asked questions
How is the completion percentage found for WBS elements without a network?
For WBS elements without activities, POC can be taken from the cost ratio (AC ÷ BAC) or read from a user field (for example a percentage entered in free fields such as PRPS-USR00), depending on the selection. The method used is shown in a separate column.
Why can the results differ from the standard progress analysis?
The standard analysis calculates POC by measurement method (milestone, time-based, estimate and so on); this report uses a work-hour weighted method. If the customer has progress analysis set up, POC can also be taken directly from its results.
Where is actual cost read from in S/4HANA?
In S/4HANA actual values are written to ACDOCA and COSP can still be read as a compatibility view. For a clean core approach, actual cost comes from ACDOCA or released CDS views, and plan from the planning solution in use.
Packages that include this solution
Project Planning and Earned Value Pack
A four-component pack that brings the project plan into SAP and measures performance with earned value: WBS cost plan upload from Excel, transfer of …
Related reports
Network Activity Planned vs Actual Work Hours Report
A custom ALV report that compares planned work with confirmed actual work on network activities and lists the remaining hours, completion percentage, …
WBS Budget vs Actual vs Commitment Report with Remaining Budget
A custom report that shows, for each WBS element, the current budget, plan, actual cost, requisition and order commitments, remaining budget and …
Project WBS Schedule Slippage Report (Basic, Forecast and Actual Dates)
A custom ALV report that compares the basic start and finish dates of each WBS element with the forecast and actual dates, calculates the slip in days …
Let us build this report for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.