WBS Budget vs Actual vs Commitment Report with Remaining Budget
Short answer: A custom report that shows, for each WBS element, the current budget, plan, actual cost, requisition and order commitments, remaining budget and budget utilization percentage in a flat ALV list. WBS elements that exceed the budget including open orders can be filtered by project manager and responsible person.
- Estimated effort
- M · 4–6 working days
- System
- ECC and S/4HANA
- Tables
- 6
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
S_ALR_87013558 is a Report Painter hierarchy report: it gives totals per level, and filtering by responsible person or overrun and exporting a flat list to Excel is hard. CJI3 lists actual and CJI5 commitment line items separately and neither compares them with the budget. Project controllers merge these three reports every month to build a remaining-budget table.
Who uses it? Project managers, project controllers and finance teams that monitor capital budgets.
Closest standard alternatives
- S_ALR_87013558 Budget/Actual/Commitment/Remaining Plan/Assigned. Shows budget, actual, commitment and remaining plan hierarchically; flat list, filtering by responsible person and overrun filter are hard.
- CJI5 Project Commitment Line Items. Lists commitment line items; does not compare them with actuals and budget on the same line.
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| PROJProject Definition | Project definition and project currency | — | ECC + S/4 |
| PRPSWBS Element Master Data | WBS element: description, level, responsible person, company code and profit center (driving table) | PRPS-PSPHI = PROJ-PSPNR | ECC + S/4 |
| BPGETotals Record for Overall Value (CO Object) | Overall budget values (original, supplement, return, transfer) | BPGE-OBJNR = PRPS-OBJNR | ECC + S/4 |
| RPSCOProject Info Database: Costs, Revenues, Finances | Project information database: plan, actual and commitment values | RPSCO-OBJNR = PRPS-OBJNR | ECC + S/4 |
| PRHIWork Breakdown Structure Hierarchy | WBS hierarchy (for cumulated values) | PRHI-POSNR = PRPS-PSPNR | ECC + S/4 |
| TKA01Controlling Areas | Controlling area currency | TKA01-KOKRS = PRPS-PKOKR | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_PSPID | Project definition | Range / multiple | PROJ-PSPID | Yes | P-26-0012 |
| S_POSID | WBS element | Range / multiple | PRPS-POSID | No | P-26-0012-02 |
| S_PBUKR | Company code | Range / multiple | PRPS-PBUKR | No | 1000 |
| S_PRCTR | Profit center | Range / multiple | PRPS-PRCTR | No | PC1100 |
| S_VERNR | Responsible person | Range / multiple | PRPS-VERNR | No | 12 |
| P_GJAHR | Fiscal year (blank: all years) | Single value | RPSCO-GJAHR | No | 2026 |
| P_CUMUL | Cumulate lower elements into parents | Checkbox | — | No | X |
| P_OVER | Overruns only | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Project | PROJ-PSPID |
| 2 | WBS element | PRPS-POSID |
| 3 | Description | PRPS-POST1 |
| 4 | Level | PRPS-STUFE |
| 5 | Responsible | PRPS-VERNA |
| 6 | Budget | Calculated Σ BPGE-WLGES (value type 41; original + supplement − return ± transfer) |
| 7 | Plan | Calculated Σ RPSCO-WLP00…WLP16 (WRTTP = 01) |
| 8 | Actual | Calculated Σ RPSCO-WLP00…WLP16 (WRTTP = 04) |
| 9 | PR commitment | Calculated Σ RPSCO-WLP00…WLP16 (WRTTP = 21) |
| 10 | PO commitment | Calculated Σ RPSCO-WLP00…WLP16 (WRTTP = 22) |
| 11 | Assigned | Calculated Actual + PR commitment + PO commitment |
| 12 | Remaining budget | Calculated Budget − assigned |
| 13 | Utilization (%) | Calculated Assigned ÷ budget × 100 |
| 14 | Currency | TKA01-WAERS |
Sample output
| Project | WBS element | Description | Level | Responsible | Budget | Plan | Actual | PR commitment | PO commitment | Assigned | Remaining budget | Utilization (%) | Currency |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| P-26-0012 | P-26-0012-01 | Engineering and design | 2 | S. Arslan | 1,800,000 | 1,750,000 | 1,420,000 | 0 | 160,000 | 1,580,000 | 220,000 | 87.80 | TRY |
| P-26-0012 | P-26-0012-02 | Equipment procurement | 2 | M. Demir | 9,500,000 | 9,800,000 | 6,100,000 | 450,000 | 3,350,000 | 9,900,000 | -400,000 | 104.20 | TRY |
| P-26-0012 | P-26-0012-03 | Site installation | 2 | E. Kaya | 3,200,000 | 3,200,000 | 950,000 | 120,000 | 1,100,000 | 2,170,000 | 1,030,000 | 67.80 | TRY |
| P-26-0015 | P-26-0015-01 | Warehouse extension works | 2 | M. Demir | 6,400,000 | 6,300,000 | 5,900,000 | 0 | 820,000 | 6,720,000 | -320,000 | 105 | TRY |
How does the report work?
- PROJ and PRPS are read by project, WBS, company code, profit center and responsible person (VERNR); the level comes from PRPS-STUFE.
- The current budget is calculated from BPGE (value type 41) as the sum of original budget, supplements, returns and transfers; for an annual selection the year values are used.
- Value types are read from the project information database (RPSCO) by WBS object number: 01 plan, 04 actual, 21 requisition commitment, 22 order commitment. Period values (WLP00–WLP16) are summed for the selected fiscal year.
- Assigned = actual + requisition commitment + order commitment; remaining budget = budget − assigned; utilization percentage = assigned ÷ budget × 100.
- With “cumulated” selected, the values of lower WBS elements are summed up to their parents through the PRHI hierarchy. With “overruns only” selected, only lines with a negative remaining budget remain.
Performance notes
Because RPSCO is a summary table, line items (COEP, COOI) do not need to be read and the report runs fast. Check that the standard actual and commitment updates to RPSCO are active so the values are current. For large project portfolios a month-end background job is recommended.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document The actual amount opens CJI3, the commitment amount CJI5 and the budget CJ31 for that WBS element.
- Export to Excel
- Runs as a background job
- Send the result by email Overrun lines can be sent to each responsible person monthly.
Authorization objects
- C_PROJ_KOKProject display authorization by controlling area
- C_PRPS_VNRWBS element authorization by responsible person
- C_PRPS_PRCWBS element authorization by profit center
Frequently asked questions
Why does the report read RPSCO instead of CJI3 and CJI5?
RPSCO is the project information database and holds period totals by value type. It is much faster than summing line items and gives the same result as the standard reports.
How does it relate to availability control?
The report does not perform availability control; it only shows the status. The remaining budget calculation uses the same assigned-value logic as availability control, but tolerance settings are not reflected in the report.
Does this report work on S/4HANA?
Yes. In S/4HANA actuals are stored in ACDOCA and RPSCO continues to be updated for compatibility. For a clean core approach, actuals can be read from CDS views such as I_ActualPlanJournalEntryItem.
Packages that include this solution
Project Budget and Schedule Controlling Pack
A pack that combines five reports for the project review meeting with one project definition and WBS selection: budget vs actual vs commitment, …
Related reports
Technically Completed WBS Elements with Unsettled Balance Report
A custom ALV report that lists technically completed (TECO) or closed WBS elements that still carry a cost balance, with status date, balance, …
Project Material Procurement Status Report (Component to Goods Receipt)
A custom ALV report that tracks network material components on one line through purchase requisition, purchase order, goods receipt and goods issue. …
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.