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

- 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/unordered-purchase-requisitions-on-wbs-elements-with-remaining-budget-report/


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

### Closest standard alternatives

- ME5A: Lists requisitions; has no WBS budget or remaining budget.
- CJI5: Lists requisition and order commitments as amounts; has no waiting time or budget status.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| EBAN | Purchase requisition item: quantity, ordered quantity, price, release date | Read | EBAN-BANFN = EBKN-BANFN AND EBAN-BNFPO = EBKN-BNFPO | ECC + S/4 |
| EBKN | Requisition account assignment: WBS element or network (driving table) | Read | - | ECC + S/4 |
| PRPS | WBS element: external number, description, object number | Read | PRPS-PSPNR = EBKN-PS_PSP_PNR | ECC + S/4 |
| PROJ | Project definition | Read | PROJ-PSPNR = PRPS-PSPHI | ECC + S/4 |
| BPGE | Overall WBS budget (WRTTP 41) | Read | BPGE-OBJNR = PRPS-OBJNR | ECC + S/4 |
| RPSCO | Project information database: actual and commitment values | Read | RPSCO-OBJNR = PRPS-OBJNR | 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_WERKS | Plant | Range / multiple | EBAN-WERKS | No |
| S_EKGRP | Purchasing group | Range / multiple | EBAN-EKGRP | No |
| S_FRGDT | Release date | Range / multiple | EBAN-FRGDT | No |
| P_REL | Only released requisitions | Checkbox | - | No |
| P_NETW | Include requisitions assigned to networks | Checkbox | - | No |
| P_OVER | Only WBS elements with tight or exceeded budget | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Project | PROJ-PSPID |
| WBS element | PRPS-POSID |
| WBS description | PRPS-POST1 |
| Purchase requisition | EBAN-BANFN |
| Item | EBAN-BNFPO |
| Material | EBAN-MATNR |
| Short text | EBAN-TXZ01 |
| Open qty | Calculated: EBAN-MENGE − EBAN-BSMNG |
| Unit | EBAN-MEINS |
| Open requisition value | Calculated: Open qty × EBAN-PREIS ÷ EBAN-PEINH × account assignment share |
| Release date | EBAN-FRGDT |
| Days waiting | Calculated: Key date − EBAN-FRGDT |
| Purchasing group | EBAN-EKGRP |
| WBS remaining budget | Calculated: BPGE budget − RPSCO actual − order and requisition commitment |
| Budget status | Calculated: Covered (≥ 20%), tight (0–20%) or exceeded (< 0) |

## How does the report work?

1. PROJ and PRPS are read by project definition and WBS element; the WBS internal numbers (PSPNR) are collected into a set.
2. 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.
3. 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.
4. Open value = (EBAN-MENGE − EBAN-BSMNG) × EBAN-PREIS ÷ EBAN-PEINH × share. Days waiting = key date − EBAN-FRGDT (BADAT if empty).
5. 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).

## Authorization objects

- M_BANF_WRK: Requisition display authorization by plant
- M_BANF_EKG: Requisition display authorization by purchasing group
- C_PROJ_KOK: Project 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.

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