PS Report Custom development ALV report

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.

TableRoleJoinSystem
PRPSWBS Element Master DataWBS element: external number, description, level (driving table)—ECC + S/4
PROJProject DefinitionProject definitionPROJ-PSPNR = PRPS-PSPHIECC + S/4
BPGETotals Record for Overall Value (CO Object)Overall budget values by business transaction (original, supplement, return, transfer)BPGE-OBJNR = PRPS-OBJNRECC + S/4
BPJATotals Record for Annual Value (CO Object)Annual budget values by business transactionBPJA-OBJNR = PRPS-OBJNRECC + S/4
COSPCO Object: Cost Totals for External PostingsPlan cost (WRTTP 01, plan version)COSP-OBJNR = PRPS-OBJNRECC + 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*
S_VERNRResponsible person numberRange / multiplePRPS-VERNRNo12
P_VERSNPlan versionSingle valueCOSP-VERSNYes0
R_OVEROverall valuesRadio button—NoX
R_YEARAnnual valuesRadio button—No—
P_GJAHRFiscal year (for annual view)Single valueBPJA-GJAHRNo2026
P_FLAGFlagged WBS elements onlyCheckbox—No—

Output columns

#ColumnSource
1ProjectPROJ-PSPID
2WBS elementPRPS-POSID
3DescriptionPRPS-POST1
4LevelPRPS-STUFE
5Original budgetCalculated BPGE/BPJA-WTGES/WTJHR, VORGA = original budget
6SupplementsCalculated Total of VORGA = supplement values
7ReturnsCalculated Total of VORGA = return values
8Net transfersCalculated Receiving transfers − sending transfers
9Current budgetCalculated Original + supplements − returns + net transfers
10Plan costCalculated Σ COSP plan (WRTTP 01, selected version)
11Plan − budgetCalculated Plan cost − current budget
12Budget change %Calculated (Current budget − original budget) ÷ original budget × 100
13CurrencyBPGE-TWAER
14FlagCalculated Plan > budget: underfunded; budget > plan × ratio: idle budget

Sample output

ProjectWBS elementDescriptionLevelOriginal budgetSupplementsReturnsNet transfersCurrent budgetPlan costPlan − budgetBudget change %CurrencyFlag
P-26015P-26015-01Engineering21,000,000200,000001,200,0001,200,000020TRY
P-26015P-26015-02Procurement and fabrication23,000,00000-250,0002,750,0003,400,000650,000-8.30TRYUnderfunded
P-26015P-26015-03Installation2600,00000250,000850,000850,000041.70TRY
P-26022P-26022-02Infrastructure2900,0000150,0000750,000480,000-270,000-16.70TRYIdle budget
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 and responsible person.
  2. 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.
  3. Current budget = original + supplements − returns + incoming transfers − outgoing transfers.
  4. Plan cost is taken from the COSP plan values (WRTTP 01) of the selected plan version, overall or per year.
  5. 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

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

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 Plan Cost vs Original Budget vs Current Budget Comparison Report