Unordered Purchase Requisitions on WBS Elements with Remaining Budget Report
Short answer: 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 value, release date and days waiting, and shows the WBS element's remaining budget next to every line. Purchasing sees which requisition to order first and the project manager sees which WBS element needs a budget supplement in the same list.
- 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?
ME5A and ME5J list project requisitions but do not show the WBS element's budget or remaining budget; CJI5 gives the requisition commitment as an amount but has no release date, purchasing group or waiting time. Budget availability control only warns at posting time. Project offices therefore join the requisitions and the budget report in Excel by WBS number.
Who uses it? Project managers, project controllers, project buyers.
Closest standard alternatives
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| EBANPurchase Requisition | Purchase requisition item: quantity, ordered quantity, price, release date | EBAN-BANFN = EBKN-BANFN AND EBAN-BNFPO = EBKN-BNFPO | ECC + S/4 |
| EBKNPurchase Requisition Account Assignment | Requisition account assignment: WBS element or network (driving table) | — | ECC + S/4 |
| PRPSWBS Element Master Data | WBS element: external number, description, object number | PRPS-PSPNR = EBKN-PS_PSP_PNR | ECC + S/4 |
| PROJProject Definition | Project definition | PROJ-PSPNR = PRPS-PSPHI | ECC + S/4 |
| BPGETotals Record for Overall Value (CO Object) | Overall WBS budget (WRTTP 41) | BPGE-OBJNR = PRPS-OBJNR | ECC + S/4 |
| RPSCOProject Info Database: Costs, Revenues, Finances | Project information database: actual and commitment values | RPSCO-OBJNR = PRPS-OBJNR | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_PSPID | Project definition | Range / multiple | PROJ-PSPID | Yes | P-26-0014 |
| S_POSID | WBS element | Range / multiple | PRPS-POSID | No | P-26-0014-02 |
| S_WERKS | Plant | Range / multiple | EBAN-WERKS | No | 1100 |
| S_EKGRP | Purchasing group | Range / multiple | EBAN-EKGRP | No | 002 |
| S_FRGDT | Release date | Range / multiple | EBAN-FRGDT | No | 01.09.2026 – 17.11.2026 |
| P_REL | Only released requisitions | Checkbox | — | No | X |
| P_NETW | Include requisitions assigned to networks | Checkbox | — | No | X |
| P_OVER | Only WBS elements with tight or exceeded budget | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Project | PROJ-PSPID |
| 2 | WBS element | PRPS-POSID |
| 3 | WBS description | PRPS-POST1 |
| 4 | Purchase requisition | EBAN-BANFN |
| 5 | Item | EBAN-BNFPO |
| 6 | Material | EBAN-MATNR |
| 7 | Short text | EBAN-TXZ01 |
| 8 | Open qty | Calculated EBAN-MENGE − EBAN-BSMNG |
| 9 | Unit | EBAN-MEINS |
| 10 | Open requisition value | Calculated Open qty × EBAN-PREIS ÷ EBAN-PEINH × account assignment share |
| 11 | Release date | EBAN-FRGDT |
| 12 | Days waiting | Calculated Key date − EBAN-FRGDT |
| 13 | Purchasing group | EBAN-EKGRP |
| 14 | WBS remaining budget | Calculated BPGE budget − RPSCO actual − order and requisition commitment |
| 15 | Budget status | Calculated Covered (≥ 20%), tight (0–20%) or exceeded (< 0) |
Sample output
| Project | WBS element | WBS description | Purchase requisition | Item | Material | Short text | Open qty | Unit | Open requisition value | Release date | Days waiting | Purchasing group | WBS remaining budget | Budget status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| P-26-0014 | P-26-0014-02-01 | Mechanical installation | 0010045812 | 00010 | RM-2040 | Galvanised sheet 1.5 mm | 800 | KG | 48,960 | 10/20/2026 | 28 | 002 | 125,400 | Covered |
| P-26-0014 | P-26-0014-02-03 | Electrical panels | 0010045830 | 00020 | EL-7720 | Cable NYY 4x16 | 1,500 | M | 54,000 | 11/03/2026 | 14 | 003 | 21,300 | Tight |
| P-26-0021 | P-26-0021-01-02 | Site preparation | 0010045877 | 00010 | Crane rental service | 1 | PC | 36,000 | 11/10/2026 | 7 | 004 | -4,200 | Exceeded |
How does the report work?
- PROJ and PRPS are read by project definition and WBS element; the WBS internal numbers (PSPNR) are collected into a set.
- Account assignments with PS_PSP_PNR in this set are read from EBKN; if P_NETW is set, requisitions assigned to a network (NPLNR) are also linked to the network’s WBS element (AUFK-PSPEL). With multiple account assignments the share is calculated from EBKN-VPROZ or EBKN-MENGE.
- EBAN items that are not deleted (LOEKZ), not closed (EBAKZ) and have an open quantity (MENGE − BSMNG) above zero remain; if P_REL is set only released requisitions (FRGDT filled) are taken.
- Open value = (EBAN-MENGE − EBAN-BSMNG) × EBAN-PREIS ÷ EBAN-PEINH × share. Days waiting = key date − EBAN-FRGDT (BADAT if empty).
- Remaining budget = BPGE budget (WRTTP 41) − RPSCO actual (WRTTP 04) − order commitment (22) − requisition commitment (21). Remaining ≥ 20% of budget counts as covered, between 0 and 20% as tight, negative as exceeded (the threshold is configurable).
Performance notes
Read EBKN by WBS internal numbers; if ECC has no secondary index on this field, adding one during installation is recommended. Budget and RPSCO values are read once per WBS element and shared by all requisition lines.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document The requisition number opens ME53N, the remaining budget opens CJ31 and the commitment amount opens CJI5 for that WBS element.
- Export to Excel
- Runs as a background job
- Send the result by email Requisitions on WBS elements with exceeded budget can be sent weekly to the project manager.
Authorization objects
- M_BANF_WRKRequisition display authorization by plant
- M_BANF_EKGRequisition display authorization by purchasing group
- C_PROJ_KOKProject display authorization by controlling area
Frequently asked questions
Why does the remaining budget also deduct the requisition commitment?
As soon as a requisition is saved, a commitment arises on the project and budget availability control counts that amount as used. The report follows the same logic, so the remaining budget shows what is left once all open requisitions are ordered.
How does the report work for projects with annual budgets?
By default the overall budget is compared. If the budget is managed per year, the report is set up during installation to use the annual budget values and the actual and commitment values of that year.
Does the report work on S/4HANA?
Yes. EBAN, EBKN, PRPS and BPGE keep the same structure in S/4HANA. Actual values can also be read from ACDOCA; RPSCO is still updated as the project information database in S/4HANA.
Related reports
Released Purchase Requisitions Not Yet Converted to Purchase Orders Report
A custom ALV report that lists released purchase requisition items not yet converted to a purchase order, with open quantity, open value and days …
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. …
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 …
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.