PS Report Custom development ALV report

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.

TableRoleJoinSystem
PRPSWBS Element Master DataWBS element: external number, description, level, object number (driving table)—ECC + S/4
PROJProject DefinitionProject definition and project managerPROJ-PSPNR = PRPS-PSPHIECC + S/4
COSPCO Object: Cost Totals for External PostingsPeriodic plan (WRTTP 01) and actual (WRTTP 04) costsCOSP-OBJNR = PRPS-OBJNRECC + S/4
BPGETotals Record for Overall Value (CO Object)Overall budget (WRTTP 41), if chosen as BACBPGE-OBJNR = PRPS-OBJNRECC + S/4
AFVCOperation within an OrderNetwork activities assigned to the WBS elementAFVC-PROJN = PRPS-PSPNRECC + S/4
AFVVQuantities, Dates and Values of Order OperationsPlanned and confirmed work of the activityAFVV-AUFPL = AFVC-AUFPL AND AFVV-APLZL = AFVC-APLZLECC + S/4
I_WBSElementBasicDataWBS Element Basic DataCDS view that can replace PRPS in S/4HANAWBSElementInternalID = PRPS-PSPNRS/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

ParameterDescriptionTypeReference fieldRequiredExample
S_PSPIDProjectRange / multiplePROJ-PSPIDYesP-26015
S_POSIDWBS elementRange / multiplePRPS-POSIDNoP-26015-02*
S_VERNRResponsible person numberRange / multiplePRPS-VERNRNo12
S_PBUKRCompany codeRange / multiplePRPS-PBUKRNo1000
P_KEYDTKey date (for PV and AC)Single value—Yes31.10.2026
P_VERSNPlan versionSingle valueCOSP-VERSNNo0
P_STUFELowest WBS level to showSingle valuePRPS-STUFENo2
R_BACPLBAC = total plan costRadio button—NoX
R_BACBUBAC = overall budgetRadio button—No—

Output columns

#ColumnSource
1ProjectPROJ-PSPID
2WBS elementPRPS-POSID
3DescriptionPRPS-POST1
4ResponsiblePRPS-VERNA
5BACCalculated Σ COSP plan (WRTTP 01) or BPGE-WTGES (WRTTP 41)
6Planned value (PV)Calculated COSP plan cost of the periods up to the key date
7Completion %Calculated Σ AFVV-ISMNW ÷ Σ AFVV-ARBEI × 100 (max. 100)
8Earned value (EV)Calculated BAC × completion %
9Actual cost (AC)Calculated COSP actual cost up to the key date (WRTTP 04)
10CPICalculated EV ÷ AC
11SPICalculated EV ÷ PV
12Estimate at completion (EAC)Calculated BAC ÷ CPI
13Variance at completion (VAC)Calculated BAC − EAC
14CurrencyCOSP-TWAER
15StatusCalculated CPI or SPI < 0.90 red; 0.90–0.97 yellow; above green

Sample output

ProjectWBS elementDescriptionResponsibleBACPlanned value (PV)Completion %Earned value (EV)Actual cost (AC)CPISPIEstimate at completion (EAC)Variance at completion (VAC)CurrencyStatus
P-26015P-26015-01EngineeringProje Lideri A1,200,000900,00080960,0001,010,0000.951.071,263,158-63,158TRYYellow
P-26015P-26015-02Procurement and fabricationProje Lideri B3,400,0002,100,000521,768,0002,260,0000.780.844,358,974-958,974TRYRed
P-26015P-26015-03InstallationProje Lideri C850,000120,00016136,000118,0001.151.13739,130110,870TRYGreen
P-26022P-26022-01Site preparationProje Lideri D540,000400,00070378,000395,0000.960.95562,500-22,500TRYYellow
A view built with fictional sample data; not real system data.

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.

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

PS Package Custom

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 …

4 components · v1.0

Related reports

PS Report Custom ALV report

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, …

AUFK · AFKO · AFVC · AFVV

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.

Related report: Project Earned Value Report (CPI, SPI and Estimate at Completion)