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

- Type: Report, Custom development, ALV report
- Module: PS
- Estimated effort: M (4–6 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/wbs-budget-actual-commitment-remaining-budget-report/


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

### Closest standard alternatives

- S_ALR_87013558: Shows budget, actual, commitment and remaining plan hierarchically; flat list, filtering by responsible person and overrun filter are hard.
- CJI5: Lists commitment line items; does not compare them with actuals and budget on the same line.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| PROJ | Project definition and project currency | Read | - | ECC + S/4 |
| PRPS | WBS element: description, level, responsible person, company code and profit center (driving table) | Read | PRPS-PSPHI = PROJ-PSPNR | ECC + S/4 |
| BPGE | Overall budget values (original, supplement, return, transfer) | Read | BPGE-OBJNR = PRPS-OBJNR | ECC + S/4 |
| RPSCO | Project information database: plan, actual and commitment values | Read | RPSCO-OBJNR = PRPS-OBJNR | ECC + S/4 |
| PRHI | WBS hierarchy (for cumulated values) | Read | PRHI-POSNR = PRPS-PSPNR | ECC + S/4 |
| TKA01 | Controlling area currency | Read | TKA01-KOKRS = PRPS-PKOKR | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_PSPID | Project definition | Range / multiple | PROJ-PSPID | Yes |
| S_POSID | WBS element | Range / multiple | PRPS-POSID | No |
| S_PBUKR | Company code | Range / multiple | PRPS-PBUKR | No |
| S_PRCTR | Profit center | Range / multiple | PRPS-PRCTR | No |
| S_VERNR | Responsible person | Range / multiple | PRPS-VERNR | No |
| P_GJAHR | Fiscal year (blank: all years) | Single value | RPSCO-GJAHR | No |
| P_CUMUL | Cumulate lower elements into parents | Checkbox | - | No |
| P_OVER | Overruns only | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Project | PROJ-PSPID |
| WBS element | PRPS-POSID |
| Description | PRPS-POST1 |
| Level | PRPS-STUFE |
| Responsible | PRPS-VERNA |
| Budget | Calculated: Σ BPGE-WLGES (value type 41; original + supplement − return ± transfer) |
| Plan | Calculated: Σ RPSCO-WLP00…WLP16 (WRTTP = 01) |
| Actual | Calculated: Σ RPSCO-WLP00…WLP16 (WRTTP = 04) |
| PR commitment | Calculated: Σ RPSCO-WLP00…WLP16 (WRTTP = 21) |
| PO commitment | Calculated: Σ RPSCO-WLP00…WLP16 (WRTTP = 22) |
| Assigned | Calculated: Actual + PR commitment + PO commitment |
| Remaining budget | Calculated: Budget − assigned |
| Utilization (%) | Calculated: Assigned ÷ budget × 100 |
| Currency | TKA01-WAERS |

## How does the report work?

1. PROJ and PRPS are read by project, WBS, company code, profit center and responsible person (VERNR); the level comes from PRPS-STUFE.
2. 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.
3. 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.
4. Assigned = actual + requisition commitment + order commitment; remaining budget = budget − assigned; utilization percentage = assigned ÷ budget × 100.
5. 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.

## Authorization objects

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

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=ps-wbs-budget-actual-commitment
