# Blocked Vendor Invoices with Price and Quantity Variance Report

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

- Type: Report, Custom development, ALV report
- Module: MM
- Estimated effort: M (3–5 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/blocked-vendor-invoices-price-quantity-variance-report/


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

### Closest standard alternatives

- MRBR: Lists blocked invoices for release; purchasing group, received quantity and days blocked are not in the same list.
- MIR4: Shows a single invoice in detail; gives no collective follow-up list.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| RBKP | Invoice header: vendor, posting date, payment block and status (driving table) | Read | - | ECC + S/4 |
| RSEG | Invoice item: order reference, quantity, amount and block indicators | Read | RSEG-BELNR = RBKP-BELNR AND RSEG-GJAHR = RBKP-GJAHR | ECC + S/4 |
| EKKO | Responsible purchasing group | Read | EKKO-EBELN = RSEG-EBELN | ECC + S/4 |
| EKPO | Order net price and price unit | Read | EKPO-EBELN = RSEG-EBELN AND EKPO-EBELP = RSEG-EBELP | ECC + S/4 |
| EKBE | Received and invoiced quantity | Read | EKBE-EBELN = RSEG-EBELN AND EKBE-EBELP = RSEG-EBELP | ECC + S/4 |
| LFA1 | Vendor name | Read | LFA1-LIFNR = RBKP-LIFNR | ECC + S/4 |
| T024 | Purchasing group name and email address | Read | T024-EKGRP = EKKO-EKGRP | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | RBKP-BUKRS | Yes |
| S_GJAHR | Fiscal year | Range / multiple | RBKP-GJAHR | No |
| S_LIFNR | Vendor | Range / multiple | RBKP-LIFNR | No |
| S_BUDAT | Invoice posting date | Range / multiple | RBKP-BUDAT | No |
| S_EKGRP | Purchasing group | Range / multiple | EKKO-EKGRP | No |
| P_PRICE | Show price blocks | Checkbox | - | No |
| P_QTY | Show quantity blocks | Checkbox | - | No |
| P_KEYDT | Key date for days blocked | Single value | SY-DATUM | Yes |

## Output columns

| Column | Source |
|---|---|
| Invoice document | RBKP-BELNR |
| Fiscal year | RBKP-GJAHR |
| Vendor | RBKP-LIFNR |
| Vendor name | LFA1-NAME1 |
| Vendor invoice no | RBKP-XBLNR |
| Posting date | RBKP-BUDAT |
| Purchase order | RSEG-EBELN |
| Item | RSEG-EBELP |
| Purchasing group | EKKO-EKGRP |
| Block reason | Calculated: Text of the RSEG block indicators that are set (price, quantity, date, quality, amount, manual) |
| Invoiced qty | RSEG-MENGE |
| Received qty | Calculated: Σ EKBE-MENGE (VGABE = 1, SHKZG = H negative) |
| Invoice amount | RSEG-WRBTR |
| Price variance | Calculated: (RSEG-WRBTR ÷ RSEG-MENGE − EKPO-NETPR ÷ EKPO-PEINH) × RSEG-MENGE |
| Currency | RBKP-WAERS |
| Days blocked | Calculated: Key date − RBKP-BUDAT |

## How does the report work?

1. RBKP is read with the selection criteria; invoices with a payment block (ZLSPR = R) that are posted (RBSTAT = 5) remain.
2. 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.
3. For the purchase order item, the received quantity (VGABE = 1) and the quantity already invoiced (VGABE = 2) are summed from EKBE.
4. Price variance = (RSEG-WRBTR ÷ RSEG-MENGE − EKPO-NETPR ÷ EKPO-PEINH) × RSEG-MENGE. Quantity variance = total invoiced − received quantity.
5. 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.

## Authorization objects

- M_RECH_BUK: Invoice verification authorization by company code
- M_RECH_WRK: Invoice verification authorization by plant
- M_RECH_EKG: Invoice 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=mm-blocked-invoices-variance
