MM Report Custom development ALV report

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

  • MRBR Release Blocked Invoices. Lists blocked invoices for release; purchasing group, received quantity and days blocked are not in the same list.
  • MIR4 Display Invoice Document / Change Status. Shows a single invoice in detail; gives no collective follow-up list.

Tables used

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

TableRoleJoinSystem
RBKPDocument Header: Incoming InvoiceInvoice header: vendor, posting date, payment block and status (driving table)—ECC + S/4
RSEGDocument Item: Incoming InvoiceInvoice item: order reference, quantity, amount and block indicatorsRSEG-BELNR = RBKP-BELNR AND RSEG-GJAHR = RBKP-GJAHRECC + S/4
EKKOPurchasing Document HeaderResponsible purchasing groupEKKO-EBELN = RSEG-EBELNECC + S/4
EKPOPurchasing Document ItemOrder net price and price unitEKPO-EBELN = RSEG-EBELN AND EKPO-EBELP = RSEG-EBELPECC + S/4
EKBEPurchasing Document HistoryReceived and invoiced quantityEKBE-EBELN = RSEG-EBELN AND EKBE-EBELP = RSEG-EBELPECC + S/4
LFA1Vendor Master (General Section)Vendor nameLFA1-LIFNR = RBKP-LIFNRECC + S/4
T024Purchasing GroupsPurchasing group name and email addressT024-EKGRP = EKKO-EKGRPECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_BUKRSCompany codeRange / multipleRBKP-BUKRSYes1000
S_GJAHRFiscal yearRange / multipleRBKP-GJAHRNo2026
S_LIFNRVendorRange / multipleRBKP-LIFNRNo100387
S_BUDATInvoice posting dateRange / multipleRBKP-BUDATNo01.10.2026 – 17.11.2026
S_EKGRPPurchasing groupRange / multipleEKKO-EKGRPNo002
P_PRICEShow price blocksCheckbox—NoX
P_QTYShow quantity blocksCheckbox—NoX
P_KEYDTKey date for days blockedSingle valueSY-DATUMYes17.11.2026

Output columns

#ColumnSource
1Invoice documentRBKP-BELNR
2Fiscal yearRBKP-GJAHR
3VendorRBKP-LIFNR
4Vendor nameLFA1-NAME1
5Vendor invoice noRBKP-XBLNR
6Posting dateRBKP-BUDAT
7Purchase orderRSEG-EBELN
8ItemRSEG-EBELP
9Purchasing groupEKKO-EKGRP
10Block reasonCalculated Text of the RSEG block indicators that are set (price, quantity, date, quality, amount, manual)
11Invoiced qtyRSEG-MENGE
12Received qtyCalculated Σ EKBE-MENGE (VGABE = 1, SHKZG = H negative)
13Invoice amountRSEG-WRBTR
14Price varianceCalculated (RSEG-WRBTR ÷ RSEG-MENGE − EKPO-NETPR ÷ EKPO-PEINH) × RSEG-MENGE
15CurrencyRBKP-WAERS
16Days blockedCalculated Key date − RBKP-BUDAT

Sample output

Invoice documentFiscal yearVendorVendor nameVendor invoice noPosting datePurchase orderItemPurchasing groupBlock reasonInvoiced qtyReceived qtyInvoice amountPrice varianceCurrencyDays blocked
51056008122026100387Delta MetalDLT2026-118410/22/2026450001314000020002Price1,2001,20079,2005,760TRY26
51056008452026100245Atlas AmbalajATL-5562111/02/2026450001310200010001Quantity3,5003,0005,9500TRY15
51056008712026100512Ege KimyaEGK/2026/90311/09/2026450001317700010001Price, quantity4504003,780236TRY8
51056008902026100618Marmara KabloMK-7781211/12/2026450001319000030003Manual600021,6000TRY5
A view built with fictional sample data; not real system data.

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.

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

FI Report Custom ALV report

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 …

BSIK · LFA1 · LFB1 · T001

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: Blocked Vendor Invoices with Price and Quantity Variance Report