PS Report Custom development ALV report

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

  • ME5A Purchase Requisitions: List Display. Lists requisitions; has no WBS budget or remaining budget.
  • CJI5 Project Commitment Line Items. Lists requisition and order commitments as amounts; has no waiting time or budget status.

Tables used

The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.

TableRoleJoinSystem
EBANPurchase RequisitionPurchase requisition item: quantity, ordered quantity, price, release dateEBAN-BANFN = EBKN-BANFN AND EBAN-BNFPO = EBKN-BNFPOECC + S/4
EBKNPurchase Requisition Account AssignmentRequisition account assignment: WBS element or network (driving table)—ECC + S/4
PRPSWBS Element Master DataWBS element: external number, description, object numberPRPS-PSPNR = EBKN-PS_PSP_PNRECC + S/4
PROJProject DefinitionProject definitionPROJ-PSPNR = PRPS-PSPHIECC + S/4
BPGETotals Record for Overall Value (CO Object)Overall WBS budget (WRTTP 41)BPGE-OBJNR = PRPS-OBJNRECC + S/4
RPSCOProject Info Database: Costs, Revenues, FinancesProject information database: actual and commitment valuesRPSCO-OBJNR = PRPS-OBJNRECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_PSPIDProject definitionRange / multiplePROJ-PSPIDYesP-26-0014
S_POSIDWBS elementRange / multiplePRPS-POSIDNoP-26-0014-02
S_WERKSPlantRange / multipleEBAN-WERKSNo1100
S_EKGRPPurchasing groupRange / multipleEBAN-EKGRPNo002
S_FRGDTRelease dateRange / multipleEBAN-FRGDTNo01.09.2026 – 17.11.2026
P_RELOnly released requisitionsCheckbox—NoX
P_NETWInclude requisitions assigned to networksCheckbox—NoX
P_OVEROnly WBS elements with tight or exceeded budgetCheckbox—No—

Output columns

#ColumnSource
1ProjectPROJ-PSPID
2WBS elementPRPS-POSID
3WBS descriptionPRPS-POST1
4Purchase requisitionEBAN-BANFN
5ItemEBAN-BNFPO
6MaterialEBAN-MATNR
7Short textEBAN-TXZ01
8Open qtyCalculated EBAN-MENGE − EBAN-BSMNG
9UnitEBAN-MEINS
10Open requisition valueCalculated Open qty × EBAN-PREIS ÷ EBAN-PEINH × account assignment share
11Release dateEBAN-FRGDT
12Days waitingCalculated Key date − EBAN-FRGDT
13Purchasing groupEBAN-EKGRP
14WBS remaining budgetCalculated BPGE budget − RPSCO actual − order and requisition commitment
15Budget statusCalculated Covered (≥ 20%), tight (0–20%) or exceeded (< 0)

Sample output

ProjectWBS elementWBS descriptionPurchase requisitionItemMaterialShort textOpen qtyUnitOpen requisition valueRelease dateDays waitingPurchasing groupWBS remaining budgetBudget status
P-26-0014P-26-0014-02-01Mechanical installation001004581200010RM-2040Galvanised sheet 1.5 mm800KG48,96010/20/202628002125,400Covered
P-26-0014P-26-0014-02-03Electrical panels001004583000020EL-7720Cable NYY 4x161,500M54,00011/03/20261400321,300Tight
P-26-0021P-26-0021-01-02Site preparation001004587700010Crane rental service1PC36,00011/10/20267004-4,200Exceeded
A view built with fictional sample data; not real system data.

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

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

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: Unordered Purchase Requisitions on WBS Elements with Remaining Budget Report