# Project Earned Value Report (CPI, SPI and Estimate at Completion)

> 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.

- Type: Report, Custom development, ALV report
- Module: PS
- Estimated effort: M (5–7 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/project-earned-value-cpi-spi-report/


## 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.

### Closest standard alternatives

- CNE5: Progress analysis shows earned value; needs a progress version, measurement methods and a CNE1 run.
- S_ALR_87013558: Shows budget, actual and commitment; does not calculate EV, CPI, SPI or EAC.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| PRPS | WBS element: external number, description, level, object number (driving table) | Read | - | ECC + S/4 |
| PROJ | Project definition and project manager | Read | PROJ-PSPNR = PRPS-PSPHI | ECC + S/4 |
| COSP | Periodic plan (WRTTP 01) and actual (WRTTP 04) costs | Read | COSP-OBJNR = PRPS-OBJNR | ECC + S/4 |
| BPGE | Overall budget (WRTTP 41), if chosen as BAC | Read | BPGE-OBJNR = PRPS-OBJNR | ECC + S/4 |
| AFVC | Network activities assigned to the WBS element | Read | AFVC-PROJN = PRPS-PSPNR | ECC + S/4 |
| AFVV | Planned and confirmed work of the activity | Read | AFVV-AUFPL = AFVC-AUFPL AND AFVV-APLZL = AFVC-APLZL | ECC + S/4 |
| I_WBSElementBasicData | CDS view that can replace PRPS in S/4HANA | Read | WBSElementInternalID = PRPS-PSPNR | S/4HANA only |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_PSPID | Project | Range / multiple | PROJ-PSPID | Yes |
| S_POSID | WBS element | Range / multiple | PRPS-POSID | No |
| S_VERNR | Responsible person number | Range / multiple | PRPS-VERNR | No |
| S_PBUKR | Company code | Range / multiple | PRPS-PBUKR | No |
| P_KEYDT | Key date (for PV and AC) | Single value | - | Yes |
| P_VERSN | Plan version | Single value | COSP-VERSN | No |
| P_STUFE | Lowest WBS level to show | Single value | PRPS-STUFE | No |
| R_BACPL | BAC = total plan cost | Radio button | - | No |
| R_BACBU | BAC = overall budget | Radio button | - | No |

## Output columns

| Column | Source |
|---|---|
| Project | PROJ-PSPID |
| WBS element | PRPS-POSID |
| Description | PRPS-POST1 |
| Responsible | PRPS-VERNA |
| BAC | Calculated: Σ COSP plan (WRTTP 01) or BPGE-WTGES (WRTTP 41) |
| Planned value (PV) | Calculated: COSP plan cost of the periods up to the key date |
| Completion % | Calculated: Σ AFVV-ISMNW ÷ Σ AFVV-ARBEI × 100 (max. 100) |
| Earned value (EV) | Calculated: BAC × completion % |
| Actual cost (AC) | Calculated: COSP actual cost up to the key date (WRTTP 04) |
| CPI | Calculated: EV ÷ AC |
| SPI | Calculated: EV ÷ PV |
| Estimate at completion (EAC) | Calculated: BAC ÷ CPI |
| Variance at completion (VAC) | Calculated: BAC − EAC |
| Currency | COSP-TWAER |
| Status | Calculated: CPI or SPI < 0.90 red; 0.90–0.97 yellow; above green |

## How does the report work?

1. PROJ and PRPS are read by project, WBS element, responsible person and company code; WBS elements down to the selected level (STUFE) are taken.
2. 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).
3. 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).
4. 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.
5. 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.

## Authorization objects

- C_PROJ_KOK: Project display authorization by controlling area
- C_PRPS_KOK: WBS element authorization by controlling area
- C_PRPS_VNR: WBS 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=ps-earned-value-cpi-spi
