MM Report Custom development ALV report

Open Purchase Orders by Vendor Report

Short answer: 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 single list. Purchasing teams see which vendor is late on which item, and by how many days, without stitching data together in Excel.

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?

ME2L and ME2N list open orders, but they do not show the total open value per vendor, the number of days late and the open quantity per schedule line on one screen. Teams usually build this by merging several lists in Excel. The custom report does it in one run and can email it weekly to each purchasing group.

Who uses it? Buyers, purchasing managers and supply chain planners.

Closest standard alternatives

  • ME2L Purchasing Documents per Vendor. Lists open orders per vendor with scope of list WE101; no days late and no total open value per vendor.
  • ME2N Purchasing Documents per Document Number. Open quantity and value can be added in ALV, but it does not calculate delay per schedule line.

Tables used

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

TableRoleJoinSystem
EKKOPurchasing Document HeaderVendor, company code, purchasing organization and currency (driving table)—ECC + S/4
EKPOPurchasing Document ItemMaterial, plant and price; deleted and completed items are excludedEKPO-EBELN = EKKO-EBELNECC + S/4
EKETPurchasing Schedule LinesDelivery date, scheduled and delivered quantityEKET-EBELN = EKPO-EBELN AND EKET-EBELP = EKPO-EBELPECC + S/4
LFA1Vendor Master (General Section)Vendor nameLFA1-LIFNR = EKKO-LIFNRECC + S/4
I_PurchaseOrderItemAPI01Purchase Order Item (CDS)In S/4HANA it can replace EKPO with a clean core approachPurchaseOrder = EKKO-EBELNS/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_MATNRMaterialRange / multipleEKPO-MATNRNoRM-1001
S_EINDTDelivery date rangeRange / multipleEKET-EINDTNo01.10.2026 – 30.11.2026
P_KEYDTKey date for delay calculation (default: today)Single valueSY-DATUMYes16.11.2026
P_OVERDUOverdue onlyCheckbox—NoX

Output columns

#ColumnSource
1Purchase orderEKKO-EBELN
2ItemEKPO-EBELP
3VendorEKKO-LIFNR
4Vendor nameLFA1-NAME1
5MaterialEKPO-MATNR
6Short textEKPO-TXZ01
7PlantEKPO-WERKS
8Delivery dateEKET-EINDT
9Scheduled qtyEKET-MENGE
10Received qtyEKET-WEMNG
11Open qtyCalculated EKET-MENGE − EKET-WEMNG
12UnitEKPO-MEINS
13Open valueCalculated Open qty × EKPO-NETPR ÷ EKPO-PEINH
14CurrencyEKKO-WAERS
15Days lateCalculated Key date − EKET-EINDT (negative value: days until due)

Sample output

Purchase orderItemVendorVendor nameMaterialShort textPlantDelivery dateScheduled qtyReceived qtyOpen qtyUnitOpen valueCurrencyDays late
450001234500010100245Atlas AmbalajRM-1001Carton box 40x30100010/20/20265,0003,0002,000PC8,500TRY27
450001234500020100245Atlas AmbalajRM-1002Stretch film 50 cm100011/05/20261,20001,200KG46,200TRY11
450001239800010100387Delta MetalRM-2040Steel sheet 2 mm200011/28/20268000800KG48,960TRY-12
450001241000010100512Ege KimyaRM-3105Solvent-based paint100010/02/2026300120180L25,560TRY45
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; items with a deletion indicator (LOEKZ) or the delivery completed flag (ELIKZ) are skipped.
  2. The EKET schedule lines of each item are read. Open quantity = scheduled quantity (MENGE) − quantity delivered (WEMNG). Lines with zero open quantity are skipped.
  3. Open value = open quantity × net price (NETPR) ÷ price unit (PEINH). If the order price unit differs from the order unit, a conversion is applied.
  4. Days late = key date − delivery date (EINDT). With “Overdue only” selected, only positive values remain.
  5. The vendor name is added from LFA1. The result is shown in ALV with subtotals per vendor.

Performance notes

Narrow the EKKO selection by company code and purchasing organization. Read EKET in a single JOIN or FOR ALL ENTRIES. On very large systems, run the report as a nightly background job.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking 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 delays weekly.

Authorization objects

  • M_BEST_BSADisplay authorization by purchasing document type
  • M_BEST_EKODisplay authorization by purchasing organization
  • M_BEST_EKGDisplay authorization by purchasing group
  • M_BEST_WRKDisplay authorization by plant

Frequently asked questions

How is the open order quantity calculated?

For each schedule line, EKET-MENGE (scheduled quantity) minus EKET-WEMNG (quantity delivered). Items flagged as delivery completed (EKPO-ELIKZ) are not treated as open.

Does this report work on S/4HANA?

Yes. EKKO, EKPO and EKET keep the same structure in S/4HANA. For a clean core approach, the I_PurchaseOrderItemAPI01 CDS view can replace EKPO.

Why build a custom report when ME2L exists?

ME2L gives the order list; it does not give days late, total open value per vendor and schedule-line detail on the same screen. The custom report combines them and can distribute the result by email.

Packages that include this solution

MM Package Custom

Purchasing and Payables Control Pack

A ready-made two-report pack that tracks open purchase orders per vendor and overdue payables to the same vendors with one shared vendor selection. …

2 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

Stock Aging Report

A custom ALV report that shows how many days each material has been in stock since its last goods receipt and which age bucket (0–30, 31–90, 91–180, …

MARD · MARA · MAKT · MBEW

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: Open Purchase Orders by Vendor Report