PS Report Custom development ALV report

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.

TableRoleJoinSystem
PROJProject DefinitionProject definition and project currency—ECC + S/4
PRPSWBS Element Master DataWBS element: description, level, responsible person, company code and profit center (driving table)PRPS-PSPHI = PROJ-PSPNRECC + S/4
BPGETotals Record for Overall Value (CO Object)Overall budget values (original, supplement, return, transfer)BPGE-OBJNR = PRPS-OBJNRECC + S/4
RPSCOProject Info Database: Costs, Revenues, FinancesProject information database: plan, actual and commitment valuesRPSCO-OBJNR = PRPS-OBJNRECC + S/4
PRHIWork Breakdown Structure HierarchyWBS hierarchy (for cumulated values)PRHI-POSNR = PRPS-PSPNRECC + S/4
TKA01Controlling AreasControlling area currencyTKA01-KOKRS = PRPS-PKOKRECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_PSPIDProject definitionRange / multiplePROJ-PSPIDYesP-26-0012
S_POSIDWBS elementRange / multiplePRPS-POSIDNoP-26-0012-02
S_PBUKRCompany codeRange / multiplePRPS-PBUKRNo1000
S_PRCTRProfit centerRange / multiplePRPS-PRCTRNoPC1100
S_VERNRResponsible personRange / multiplePRPS-VERNRNo12
P_GJAHRFiscal year (blank: all years)Single valueRPSCO-GJAHRNo2026
P_CUMULCumulate lower elements into parentsCheckbox—NoX
P_OVEROverruns onlyCheckbox—No—

Output columns

#ColumnSource
1ProjectPROJ-PSPID
2WBS elementPRPS-POSID
3DescriptionPRPS-POST1
4LevelPRPS-STUFE
5ResponsiblePRPS-VERNA
6BudgetCalculated Σ BPGE-WLGES (value type 41; original + supplement − return ± transfer)
7PlanCalculated Σ RPSCO-WLP00…WLP16 (WRTTP = 01)
8ActualCalculated Σ RPSCO-WLP00…WLP16 (WRTTP = 04)
9PR commitmentCalculated Σ RPSCO-WLP00…WLP16 (WRTTP = 21)
10PO commitmentCalculated Σ RPSCO-WLP00…WLP16 (WRTTP = 22)
11AssignedCalculated Actual + PR commitment + PO commitment
12Remaining budgetCalculated Budget − assigned
13Utilization (%)Calculated Assigned ÷ budget × 100
14CurrencyTKA01-WAERS

Sample output

ProjectWBS elementDescriptionLevelResponsibleBudgetPlanActualPR commitmentPO commitmentAssignedRemaining budgetUtilization (%)Currency
P-26-0012P-26-0012-01Engineering and design2S. Arslan1,800,0001,750,0001,420,0000160,0001,580,000220,00087.80TRY
P-26-0012P-26-0012-02Equipment procurement2M. Demir9,500,0009,800,0006,100,000450,0003,350,0009,900,000-400,000104.20TRY
P-26-0012P-26-0012-03Site installation2E. Kaya3,200,0003,200,000950,000120,0001,100,0002,170,0001,030,00067.80TRY
P-26-0015P-26-0015-01Warehouse extension works2M. Demir6,400,0006,300,0005,900,0000820,0006,720,000-320,000105TRY
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, 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.

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

PS Package Custom

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

5 components · v1.0

Related reports

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: WBS Budget vs Actual vs Commitment Report with Remaining Budget