Blocked Vendor Invoices with Price and Quantity Variance Report
Short answer: A custom ALV report that lists vendor invoices blocked for payment in invoice verification with the block reason, the received quantity, the price variance amount, the responsible purchasing group and the days spent blocked. It shows at a glance who has to resolve which invoice.
- Estimated effort
- M · 3–5 working days
- System
- ECC and S/4HANA
- Tables
- 7
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
MRBR lists blocked invoices for release and shows the block reason, but not the responsible purchasing group, the received quantity, the variance amount against the order price or how many days the invoice has been blocked, on the same line. MIR4 opens one document. Teams therefore enrich the block list by hand every week and email it to purchasing.
Who uses it? Accounts payable and invoice verification teams, buyers and finance teams that plan cash.
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 |
|---|---|---|---|
| RBKPDocument Header: Incoming Invoice | Invoice header: vendor, posting date, payment block and status (driving table) | — | ECC + S/4 |
| RSEGDocument Item: Incoming Invoice | Invoice item: order reference, quantity, amount and block indicators | RSEG-BELNR = RBKP-BELNR AND RSEG-GJAHR = RBKP-GJAHR | ECC + S/4 |
| EKKOPurchasing Document Header | Responsible purchasing group | EKKO-EBELN = RSEG-EBELN | ECC + S/4 |
| EKPOPurchasing Document Item | Order net price and price unit | EKPO-EBELN = RSEG-EBELN AND EKPO-EBELP = RSEG-EBELP | ECC + S/4 |
| EKBEPurchasing Document History | Received and invoiced quantity | EKBE-EBELN = RSEG-EBELN AND EKBE-EBELP = RSEG-EBELP | ECC + S/4 |
| LFA1Vendor Master (General Section) | Vendor name | LFA1-LIFNR = RBKP-LIFNR | ECC + S/4 |
| T024Purchasing Groups | Purchasing group name and email address | T024-EKGRP = EKKO-EKGRP | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | RBKP-BUKRS | Yes | 1000 |
| S_GJAHR | Fiscal year | Range / multiple | RBKP-GJAHR | No | 2026 |
| S_LIFNR | Vendor | Range / multiple | RBKP-LIFNR | No | 100387 |
| S_BUDAT | Invoice posting date | Range / multiple | RBKP-BUDAT | No | 01.10.2026 – 17.11.2026 |
| S_EKGRP | Purchasing group | Range / multiple | EKKO-EKGRP | No | 002 |
| P_PRICE | Show price blocks | Checkbox | — | No | X |
| P_QTY | Show quantity blocks | Checkbox | — | No | X |
| P_KEYDT | Key date for days blocked | Single value | SY-DATUM | Yes | 17.11.2026 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Invoice document | RBKP-BELNR |
| 2 | Fiscal year | RBKP-GJAHR |
| 3 | Vendor | RBKP-LIFNR |
| 4 | Vendor name | LFA1-NAME1 |
| 5 | Vendor invoice no | RBKP-XBLNR |
| 6 | Posting date | RBKP-BUDAT |
| 7 | Purchase order | RSEG-EBELN |
| 8 | Item | RSEG-EBELP |
| 9 | Purchasing group | EKKO-EKGRP |
| 10 | Block reason | Calculated Text of the RSEG block indicators that are set (price, quantity, date, quality, amount, manual) |
| 11 | Invoiced qty | RSEG-MENGE |
| 12 | Received qty | Calculated Σ EKBE-MENGE (VGABE = 1, SHKZG = H negative) |
| 13 | Invoice amount | RSEG-WRBTR |
| 14 | Price variance | Calculated (RSEG-WRBTR ÷ RSEG-MENGE − EKPO-NETPR ÷ EKPO-PEINH) × RSEG-MENGE |
| 15 | Currency | RBKP-WAERS |
| 16 | Days blocked | Calculated Key date − RBKP-BUDAT |
Sample output
| Invoice document | Fiscal year | Vendor | Vendor name | Vendor invoice no | Posting date | Purchase order | Item | Purchasing group | Block reason | Invoiced qty | Received qty | Invoice amount | Price variance | Currency | Days blocked |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5105600812 | 2026 | 100387 | Delta Metal | DLT2026-1184 | 10/22/2026 | 4500013140 | 00020 | 002 | Price | 1,200 | 1,200 | 79,200 | 5,760 | TRY | 26 |
| 5105600845 | 2026 | 100245 | Atlas Ambalaj | ATL-55621 | 11/02/2026 | 4500013102 | 00010 | 001 | Quantity | 3,500 | 3,000 | 5,950 | 0 | TRY | 15 |
| 5105600871 | 2026 | 100512 | Ege Kimya | EGK/2026/903 | 11/09/2026 | 4500013177 | 00010 | 001 | Price, quantity | 450 | 400 | 3,780 | 236 | TRY | 8 |
| 5105600890 | 2026 | 100618 | Marmara Kablo | MK-77812 | 11/12/2026 | 4500013190 | 00030 | 003 | Manual | 600 | 0 | 21,600 | 0 | TRY | 5 |
How does the report work?
- RBKP is read with the selection criteria; invoices with a payment block (ZLSPR = R) that are posted (RBSTAT = 5) remain.
- Block indicators are read from the RSEG items: price (SPGRP), quantity (SPGRM), date (SPGRT), order price quantity (SPGRG), item amount (SPGRS), quality (SPGRC) and manual (SPGRQ). Items with at least one indicator set are listed.
- For the purchase order item, the received quantity (VGABE = 1) and the quantity already invoiced (VGABE = 2) are summed from EKBE.
- Price variance = (RSEG-WRBTR ÷ RSEG-MENGE − EKPO-NETPR ÷ EKPO-PEINH) × RSEG-MENGE. Quantity variance = total invoiced − received quantity.
- Days blocked = key date − RBKP-BUDAT. The purchasing group comes from EKKO, the vendor name from LFA1 and the group name from T024; the ALV is sorted by days blocked.
Performance notes
Select RBKP by company code, fiscal year and ZLSPR, and read RSEG and EKBE for the document list in one go. The number of blocked invoices is usually small, so the report runs fast online. Use a background job for weekly distribution.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document The invoice number opens MIR4, the order number opens ME23N.
- Export to Excel
- Runs as a background job
- Send the result by email Each purchasing group can receive its own blocked invoices at the address stored in T024.
Authorization objects
- M_RECH_BUKInvoice verification authorization by company code
- M_RECH_WRKInvoice verification authorization by plant
- M_RECH_EKGInvoice verification authorization by purchasing group
Frequently asked questions
Does the report release the invoices?
No, the report only reads. Release is done in MRBR; if needed, MRBR can be opened directly from the report for the selected invoices.
Why can the price variance differ from the amount in MRBR?
The report calculates the variance against the order net price. If tolerances, delivery costs or price unit conversion apply, the calculation rule is adapted to the customer's invoice verification setup during installation.
Does this report work on S/4HANA?
Yes. RBKP, RSEG and EKBE keep the same structure in S/4HANA. Fiori also has apps for blocked invoices; the report adds the purchasing group and ageing view.
Related reports
Vendor Open Items Aging Report
A custom ALV report that ages vendor open items by net due date and spreads the amounts into not-due, 0–30, 31–60, 61–90 and 90+ day buckets. The …
Goods Received Not Invoiced Purchase Orders Report (GR/IR)
A custom ALV report that compares received and invoiced quantity and amount per purchase order item and lists items that were received but not …
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.