MM Report Custom development ALV report

Goods Received Not Invoiced Purchase Orders Report (GR/IR)

Short answer: A custom ALV report that compares received and invoiced quantity and amount per purchase order item and lists items that were received but not invoiced, or invoiced but not received. Each line shows how many days the difference has been open and which purchasing group should follow it up.

Estimated effort
M · 3–5 working days
System
ECC and S/4HANA
Tables
5
Scope
Global
Built by
NeKuDos Teknoloji
Last updated

Why is the standard not enough?

MB5S shows the GR/IR balance per purchase order, but not the purchasing group, the last goods receipt date or how long the difference has been open. In ME2N the "to be delivered" and "to be invoiced" selections do not combine with the final invoice indicator into a usable difference list. Teams merge two lists in Excel. The custom report calculates both directions from the purchase order history (EKBE) on one line and ages the difference.

Who uses it? Buyers, invoice verification teams and finance teams that reconcile the GR/IR account at month end.

Closest standard alternatives

  • MB5S Display List of GR/IR Balances. Lists the GR/IR balance per purchase order; no purchasing group, last goods receipt date or ageing.
  • ME2N Purchasing Documents per Document Number. Shows quantities to be delivered and to be invoiced separately; does not produce a two-way difference list.

Tables used

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

TableRoleJoinSystem
EKKOPurchasing Document HeaderCompany code, purchasing group, vendor and document currency (driving table)—ECC + S/4
EKPOPurchasing Document ItemMaterial, plant, goods receipt / invoice indicators and final invoice flagEKPO-EBELN = EKKO-EBELNECC + S/4
EKBEPurchasing Document HistoryPurchase order history: goods receipt and invoice quantities, amounts and posting datesEKBE-EBELN = EKPO-EBELN AND EKBE-EBELP = EKPO-EBELPECC + S/4
LFA1Vendor Master (General Section)Vendor nameLFA1-LIFNR = EKKO-LIFNRECC + S/4
I_PurchaseOrderHistoryAPI01Purchase Order History (API)In S/4HANA it can replace EKBE with a clean core approachPurchaseOrder = EKPO-EBELN AND PurchaseOrderItem = EKPO-EBELPS/4HANA only

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_BUKRSCompany codeRange / multipleEKKO-BUKRSYes1000
S_EKORGPurchasing organizationRange / multipleEKKO-EKORGNo1000
S_EKGRPPurchasing groupRange / multipleEKKO-EKGRPNo001
S_LIFNRVendorRange / multipleEKKO-LIFNRNo100245
S_WERKSPlantRange / multipleEKPO-WERKSNo1000
S_BEDATOrder date rangeRange / multipleEKKO-BEDATNo01.01.2026 – 31.10.2026
R_GRNIReceived, not invoicedRadio button—NoX
R_IRNGInvoiced, not receivedRadio button—No—
P_KEYDTKey date for days openSingle valueSY-DATUMYes17.11.2026

Output columns

#ColumnSource
1Purchase orderEKKO-EBELN
2ItemEKPO-EBELP
3Purchasing groupEKKO-EKGRP
4VendorEKKO-LIFNR
5Vendor nameLFA1-NAME1
6MaterialEKPO-MATNR
7Short textEKPO-TXZ01
8PlantEKPO-WERKS
9GR qtyCalculated Σ EKBE-MENGE (VGABE = 1, SHKZG = H negative)
10Invoiced qtyCalculated Σ EKBE-MENGE (VGABE = 2, SHKZG = H negative)
11Difference qtyCalculated GR qty − invoiced qty
12UnitEKPO-MEINS
13Difference amountCalculated Σ EKBE-WRBTR (VGABE = 1) − Σ EKBE-WRBTR (VGABE = 2)
14CurrencyEKKO-WAERS
15Last GR dateEKBE-BUDAT
16Days openCalculated Key date − last GR date

Sample output

Purchase orderItemPurchasing groupVendorVendor nameMaterialShort textPlantGR qtyInvoiced qtyDifference qtyUnitDifference amountCurrencyLast GR dateDays open
450001310200010001100245Atlas AmbalajRM-1001Carton box 40x3010005,0003,0002,000PC8,500TRY09/28/202650
450001314000020002100387Delta MetalRM-2040Steel sheet 2 mm20001,20001,200KG73,440TRY10/21/202627
450001317700010001100512Ege KimyaRM-3105Solvent-based paint10004004000L3,150TRY11/03/202614
450001319000030003100618Marmara KabloRM-4410Copper cable 4 mm²10000600-600M-21,600TRY0
A view built with fictional sample data; not real system data.

How does the report work?

  1. EKKO and EKPO are read with the selection-screen criteria; deleted items (EKPO-LOEKZ) and items that expect no goods receipt or no invoice (EKPO-WEPOS or EKPO-REPOS blank) are skipped.
  2. The EKBE records of each item are read: VGABE = 1 goods receipts, VGABE = 2 invoices. Records with SHKZG = H (reversals, returns) are summed with a negative sign.
  3. Difference quantity = goods receipt quantity − invoiced quantity; difference amount = goods receipt amount (EKBE-WRBTR) − invoice amount, in document currency.
  4. Depending on the radio button, only positive differences (not invoiced), only negative differences (not received) or all differences remain. Items with the final invoice flag (EKPO-EREKZ) and a zero difference are skipped.
  5. The last goods receipt date is the highest EKBE-BUDAT of the VGABE = 1 records; days open = key date − last goods receipt date. The vendor name is added from LFA1; the ALV shows subtotals per purchasing group and vendor.

Performance notes

Aggregate EKBE in SQL with SUM and GROUP BY (EBELN, EBELP, VGABE, SHKZG) rather than in an ABAP loop. Narrow the EKKO selection by company code and order date. At month end, run the report as a background job and email the result to each purchasing group.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document The order number opens ME23N, the difference amount opens the order history.
  • Export to Excel
  • Runs as a background job
  • Send the result by email At month end each purchasing group can receive its own open differences.

Authorization objects

  • M_BEST_EKOPurchase order display authorization by purchasing organization
  • M_BEST_EKGPurchase order display authorization by purchasing group
  • M_BEST_WRKPurchase order display authorization by plant

Frequently asked questions

In which currency is the difference shown?

In document currency (EKBE-WRBTR and EKKO-WAERS). If company code currency is needed, a second amount column based on EKBE-DMBTR is added.

How are returns and reversals handled?

EKBE records with debit/credit indicator SHKZG = H are summed with a negative sign, so a 102 reversal or an invoice cancellation reduces the difference correctly.

Does this report work on S/4HANA?

Yes. EKKO, EKPO and EKBE keep the same structure in S/4HANA. For a clean core approach, the order history can be read from the I_PurchaseOrderHistoryAPI01 CDS view.

Packages that include this solution

FI Package Custom

Month-End Close Control Pack

A pack that lists the five topics to clean up before the close with one company code and period selection: parked documents, unmatched bank items, …

5 components · v1.0

MM Package Custom

Inventory Control and GR/IR Pack

A five-report pack that tracks stock value and stock accuracy with one plant and storage location selection: stock aging, materials below safety …

5 components · v1.0

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

MM Report Custom ALV report

Open Purchase Orders by Vendor Report

A custom ALV report that shows, per vendor, the quantity not yet received, the open order value and the days of delay since the delivery date in a …

EKKO · EKPO · EKET · LFA1

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: Goods Received Not Invoiced Purchase Orders Report (GR/IR)