MM Report Custom development ALV report

Purchasing Contract Utilization and Remaining Balance Report

Short answer: A custom ALV report that lists, for quantity and value contracts, how much of the target quantity and value has been used by release orders, the remaining balance, the utilization percentage and the days until the contract ends. Purchasing sees contracts that need renewal or are about to be used up in time.

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

Why is the standard not enough?

ME3L lists contracts per vendor, and the release documentation is opened one contract item at a time in ME33K. The utilization percentage against target, the remaining balance and the days until expiry for all contracts are not in one list. Teams keep the renewal and renegotiation calendar in Excel.

Who uses it? Purchasing managers, category managers and contract management teams.

Closest standard alternatives

  • ME3L Outline Agreements per Vendor. Lists contracts per vendor; no utilization percentage and no days to expiry.
  • ME33K Display Contract. Shows the release documentation of one contract; does not compare all contracts.

Tables used

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

TableRoleJoinSystem
EKKOPurchasing Document HeaderContract header: vendor, validity dates and header target value (driving table)—ECC + S/4
EKPOPurchasing Document ItemContract item: material, target quantity and target valueEKPO-EBELN = EKKO-EBELNECC + S/4
EKABRelease DocumentationRelease documentation: quantity and value of release ordersEKAB-KONNR = EKPO-EBELN AND EKAB-KTPNR = EKPO-EBELPECC + S/4
LFA1Vendor Master (General Section)Vendor nameLFA1-LIFNR = EKKO-LIFNRECC + S/4
I_PurchaseContractItemAPI01Purchase Contract Item (API)In S/4HANA it can be read for contract items with a clean core approachPurchaseContract = EKKO-EBELNS/4HANA only

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_EKORGPurchasing organizationRange / multipleEKKO-EKORGYes1000
S_EKGRPPurchasing groupRange / multipleEKKO-EKGRPNo001
S_LIFNRVendorRange / multipleEKKO-LIFNRNo100245
S_KONNRContractRange / multipleEKKO-EBELNNo4600000210
S_BSARTContract type (MK quantity, WK value)Range / multipleEKKO-BSARTNoMK
S_KDATEValidity end dateRange / multipleEKKO-KDATENo01.11.2026 – 31.03.2027
P_PCTUtilization threshold for warning (%)Single value—No80
P_KEYDTKey dateSingle valueSY-DATUMYes17.11.2026

Output columns

#ColumnSource
1ContractEKKO-EBELN
2ItemEKPO-EBELP
3VendorEKKO-LIFNR
4Vendor nameLFA1-NAME1
5MaterialEKPO-MATNR
6Short textEKPO-TXZ01
7Valid fromEKKO-KDATB
8Valid toEKKO-KDATE
9Target qtyEKPO-KTMNG
10Released qtyCalculated Σ EKAB-MENGE
11Remaining qtyCalculated EKPO-KTMNG − released qty
12Target valueEKPO-ZWERT
13Released valueCalculated Σ EKAB-NETWR
14Utilization (%)Calculated Released ÷ target × 100 (value for value contracts, quantity for quantity contracts)
15CurrencyEKKO-WAERS
16Days to expiryCalculated EKKO-KDATE − key date

Sample output

ContractItemVendorVendor nameMaterialShort textValid fromValid toTarget qtyReleased qtyRemaining qtyTarget valueReleased valueUtilization (%)CurrencyDays to expiry
460000021000010100245Atlas AmbalajRM-1001Carton box 40x3001/01/202612/31/2026120,000103,50016,500204,000175,95086.30TRY44
460000022400010100387Delta MetalRM-2040Steel sheet 2 mm03/01/202602/28/202760,00021,00039,0003,672,0001,285,20035TRY103
460000023100010100700Kuzey LojistikDomestic freight service01/01/202612/31/20260002,500,0002,310,00092.40TRY44
460000024500020100512Ege KimyaRM-3105Solvent-based paint06/01/202611/30/20268,0007,40060063,00058,27592.50TRY13
A view built with fictional sample data; not real system data.

How does the report work?

  1. Contracts (BSTYP = K) are read from EKKO by purchasing organization, vendor and validity end (KDATE); deleted documents are skipped.
  2. The target quantity (KTMNG) and item target value (ZWERT) are taken from the EKPO items; for value contracts the header target value EKKO-KTWRT is used.
  3. Release documentation is summed from EKAB per contract and item (KONNR, KTPNR): released quantity (MENGE) and released value (NETWR).
  4. Remaining quantity = KTMNG − released quantity; utilization percentage = released ÷ target × 100 (by value for value contracts).
  5. Days to expiry = EKKO-KDATE − key date. Contracts above the utilization threshold or ending within the given number of days are flagged; the vendor name is added from LFA1.

Performance notes

The number of contracts is usually small; take the EKAB totals for the contract list in a single SQL with GROUP BY KONNR, KTPNR. The report runs online; a background job with email can be used for monthly renewal tracking.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking the contract opens ME33K; clicking the released quantity shows the release orders.
  • Export to Excel
  • Runs as a background job
  • Send the result by email Contracts close to expiry or above the threshold can be sent monthly.

Authorization objects

  • M_RAHM_BSAContract display authorization by document type
  • M_RAHM_EKOContract display authorization by purchasing organization
  • M_RAHM_EKGContract display authorization by purchasing group

Frequently asked questions

How are service items without a target shown?

For items without a target quantity, utilization is calculated by value. If the item target value is also empty, the header target value (EKKO-KTWRT) is used.

Do deleted release orders affect the utilization?

EKAB tracks the release order items. Deleted release items are checked against EKPO-LOEKZ and removed from the total.

Does this report work on S/4HANA?

Yes. EKKO, EKPO and EKAB are used in S/4HANA as well. Central contracts in S/4HANA are out of scope and are assessed separately.

Related reports

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

MM Program Custom Mass upload

Mass Purchase Order Creation from Excel Program

A custom program that creates purchase orders in bulk from Excel or CSV rows, grouping them by vendor, purchasing organization and group number. It …

EKKO · EKPO · EKET · EKKN

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: Purchasing Contract Utilization and Remaining Balance Report