WBS Plan Cost vs Original Budget vs Current Budget Comparison Report
Short answer: A custom ALV report that places the original budget, supplements, returns, budget transfers, current budget and plan cost of each WBS element side by side and flags the gap between plan and budget. Project control teams see in one list which WBS element is underfunded and how much the budget has changed since the start.
- Estimated effort
- S · 3–4 working days
- System
- ECC and S/4HANA
- Tables
- 6
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
CJ31 shows the budget of one project and CJ40/CJR2 its plan, on separate screens. S_ALR_87013558 gives the current budget and actuals, but it does not show original budget, supplements, returns and transfers in separate columns and does not flag the gap between plan cost and budget. Teams usually merge this table in Excel. The custom report splits the budget by transaction type and runs the multi-project comparison in one go.
Who uses it? Project control (PMO) teams, project managers and budget owners.
Closest standard alternatives
- CJ31 Display Project Original Budget. Shows the budget of one project; no list with supplement/transfer split and plan comparison.
- S_ALR_87013558 Budget/Actual/Commitment/Remaining Plan/Assigned. Gives current budget, actual and commitment; original budget and budget movements are not separate columns.
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 (driving table) | — | ECC + S/4 |
| PROJProject Definition | Project definition | PROJ-PSPNR = PRPS-PSPHI | ECC + S/4 |
| BPGETotals Record for Overall Value (CO Object) | Overall budget values by business transaction (original, supplement, return, transfer) | BPGE-OBJNR = PRPS-OBJNR | ECC + S/4 |
| BPJATotals Record for Annual Value (CO Object) | Annual budget values by business transaction | BPJA-OBJNR = PRPS-OBJNR | ECC + S/4 |
| COSPCO Object: Cost Totals for External Postings | Plan cost (WRTTP 01, plan version) | COSP-OBJNR = PRPS-OBJNR | 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* |
| S_VERNR | Responsible person number | Range / multiple | PRPS-VERNR | No | 12 |
| P_VERSN | Plan version | Single value | COSP-VERSN | Yes | 0 |
| R_OVER | Overall values | Radio button | — | No | X |
| R_YEAR | Annual values | Radio button | — | No | — |
| P_GJAHR | Fiscal year (for annual view) | Single value | BPJA-GJAHR | No | 2026 |
| P_FLAG | Flagged WBS elements 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 | Original budget | Calculated BPGE/BPJA-WTGES/WTJHR, VORGA = original budget |
| 6 | Supplements | Calculated Total of VORGA = supplement values |
| 7 | Returns | Calculated Total of VORGA = return values |
| 8 | Net transfers | Calculated Receiving transfers − sending transfers |
| 9 | Current budget | Calculated Original + supplements − returns + net transfers |
| 10 | Plan cost | Calculated Σ COSP plan (WRTTP 01, selected version) |
| 11 | Plan − budget | Calculated Plan cost − current budget |
| 12 | Budget change % | Calculated (Current budget − original budget) ÷ original budget × 100 |
| 13 | Currency | BPGE-TWAER |
| 14 | Flag | Calculated Plan > budget: underfunded; budget > plan × ratio: idle budget |
Sample output
| Project | WBS element | Description | Level | Original budget | Supplements | Returns | Net transfers | Current budget | Plan cost | Plan − budget | Budget change % | Currency | Flag |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| P-26015 | P-26015-01 | Engineering | 2 | 1,000,000 | 200,000 | 0 | 0 | 1,200,000 | 1,200,000 | 0 | 20 | TRY | |
| P-26015 | P-26015-02 | Procurement and fabrication | 2 | 3,000,000 | 0 | 0 | -250,000 | 2,750,000 | 3,400,000 | 650,000 | -8.30 | TRY | Underfunded |
| P-26015 | P-26015-03 | Installation | 2 | 600,000 | 0 | 0 | 250,000 | 850,000 | 850,000 | 0 | 41.70 | TRY | |
| P-26022 | P-26022-02 | Infrastructure | 2 | 900,000 | 0 | 150,000 | 0 | 750,000 | 480,000 | -270,000 | -16.70 | TRY | Idle budget |
How does the report work?
- PROJ and PRPS are read by project, WBS element and responsible person.
- In the overall view BPGE, in the annual view BPJA for the selected fiscal year, budget values (WRTTP 41) are read and split by business transaction (VORGA): original budget, supplement, return, sending and receiving transfer.
- Current budget = original + supplements − returns + incoming transfers − outgoing transfers.
- Plan cost is taken from the COSP plan values (WRTTP 01) of the selected plan version, overall or per year.
- The plan − current budget difference and the change in % versus the original budget are calculated. If plan exceeds budget, an “underfunded” flag is set; if budget exceeds plan by more than a given ratio, an “idle budget” flag is set. The ALV shows subtotals per project and WBS level.
Performance notes
Read BPGE and BPJA in one pass with the WBS object numbers (OBJNR); restrict COSP by the same object list, WRTTP 01 and the version. If the object list contains thousands of WBS elements, read in packages.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the budget columns opens CJ31; double-clicking plan cost opens CJ41.
- Export to Excel
- Runs as a background job
- Send the result by email Underfunded WBS elements can be sent monthly to budget owners.
Authorization objects
- C_PROJ_KOKProject display authorization by controlling area
- C_PRPS_KOKWBS element authorization by controlling area
Frequently asked questions
Are budget transfers counted twice?
No. On the sending WBS element the outgoing transfer is negative and on the receiving one the incoming transfer is positive. Within the project total both sides cancel out; only transfers between projects change the project total.
Can I see who changed the budget?
This report splits the amounts by business transaction. For user and date per document, the budget document header can be read to add a document-level list to the report; this adds 1–2 days to the estimate.
Does it work on S/4HANA?
Yes. The classic PS budget (BPGE, BPJA) is still used in S/4HANA. Plan cost is read from the COSP compatibility view; if the new planning solution is used, plan is taken from ACDOCP.
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
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 …
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 …
Unordered Purchase Requisitions on WBS Elements with Remaining Budget Report
A custom ALV report that lists purchase requisitions assigned to a WBS element or network and not yet converted to an order, with open quantity, open …
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.