MM Report Custom development ALV report

Purchase Price Variance (PPV) Report by Vendor and Material Group

Short answer: A custom ALV report that compares the unit price on purchase orders with the material's standard or moving average price, the price in the purchasing info record or the price of the previous order from the same vendor. Unit variance, total variance amount and variance percentage are listed with subtotals by vendor and material group.

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

Why is the standard not enough?

ME1P shows the order price history of one info record and ME80FN lists order prices, but neither compares the order price with the material's valuation price or the info record on the same line and calculates a variance amount and percentage. For standard-price materials the price variance only reaches the price difference account after goods receipt and invoice. Purchasing joins the lists in Excel to see the variance at order time by vendor and material group.

Who uses it? Purchasing managers, cost accounting and product costing teams, category managers.

Closest standard alternatives

  • ME1P Purchase Order Price History. Shows the order price history of one info record; gives no variance against the valuation price and no vendor totals.
  • ME80FN General Analyses of Purchasing Documents. Lists order prices; does not calculate a comparison price or a variance percentage.

Tables used

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

TableRoleJoinSystem
EKKOPurchasing Document HeaderOrder header: vendor, order date, currency and exchange rate (driving table)—ECC + S/4
EKPOPurchasing Document ItemOrder item: material, material group, quantity, net price and price unitEKPO-EBELN = EKKO-EBELNECC + S/4
MBEWMaterial ValuationMaterial valuation: standard or moving average priceMBEW-MATNR = EKPO-MATNR AND MBEW-BWKEY = EKPO-WERKSECC + S/4
EINAPurchasing Info Record: General DataPurchasing info record general data (material and vendor)EINA-MATNR = EKPO-MATNR AND EINA-LIFNR = EKKO-LIFNRECC + S/4
EINEPurchasing Info Record: Purchasing Organization DataInfo record purchasing organization data: net priceEINE-INFNR = EINA-INFNR AND EINE-EKORG = EKKO-EKORG AND EINE-WERKS = EKPO-WERKSECC + S/4
LFA1Vendor Master (General Section)Vendor nameLFA1-LIFNR = EKKO-LIFNRECC + S/4

S/4HANA notes

  • MBEW: In S/4HANA the Material Ledger is mandatory and valuation data is read through a compatibility view. Prices remain readable; validate value calculations against the currency and valuation view in use.

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_BUKRSCompany codeRange / multipleEKKO-BUKRSYes1000
S_EKORGPurchasing organizationRange / multipleEKKO-EKORGNo1000
S_BEDATOrder dateRange / multipleEKKO-BEDATYes01.10.2026 – 17.11.2026
S_LIFNRVendorRange / multipleEKKO-LIFNRNo100387
S_MATKLMaterial groupRange / multipleEKPO-MATKLNo01
S_WERKSPlantRange / multipleEKPO-WERKSNo1100
R_BASEComparison base: valuation price / info record / previous orderRadio button—NoMBEW
P_MINPCTMinimum variance to show (%)Single value—No5

Output columns

#ColumnSource
1Purchase orderEKPO-EBELN
2ItemEKPO-EBELP
3Order dateEKKO-BEDAT
4VendorEKKO-LIFNR
5Vendor nameLFA1-NAME1
6MaterialEKPO-MATNR
7Material groupEKPO-MATKL
8PlantEKPO-WERKS
9Order qtyEKPO-MENGE
10Order unit priceCalculated EKPO-NETPR ÷ EKPO-PEINH × EKKO-WKURS (company code currency)
11Valuation priceCalculated MBEW-STPRS if VPRSV = S, MBEW-VERPR if V; ÷ MBEW-PEINH
12Info record priceCalculated EINE-NETPR ÷ EINE-PEINH
13Unit varianceCalculated Order unit price − selected comparison price
14Variance amountCalculated Unit variance × EKPO-MENGE
15Variance (%)Calculated Unit variance ÷ comparison price × 100
16CurrencyCalculated Local currency of the company code

Sample output

Purchase orderItemOrder dateVendorVendor nameMaterialMaterial groupPlantOrder qtyOrder unit priceValuation priceInfo record priceUnit varianceVariance amountVariance (%)Currency
45000131400002010/05/2026100387Delta MetalRM-20400111001,2006661.2062.504.805,7607.80TRY
45000131020001010/12/2026100245Atlas AmbalajPK-11800311003,0001.701.851.70-0.15-450-8.10TRY
45000131770001010/28/2026100512Ege KimyaCH-03150212004009.458.609.100.853409.90TRY
45000131900003011/03/2026100618Marmara KabloEL-77200411006003635.40360.603601.70TRY
A view built with fictional sample data; not real system data.

How does the report work?

  1. EKKO and EKPO are read by company code, purchasing organization, order date, vendor, material group and plant; items without a material number and deleted items (LOEKZ) are excluded.
  2. Order unit price = EKPO-NETPR ÷ EKPO-PEINH; the document currency is converted to company code currency with EKKO-WKURS and the order unit is converted to the base unit with the item’s conversion factor.
  3. The comparison price is chosen by radio button: from MBEW, STPRS when price control (VPRSV) is S and VERPR when it is V, divided by MBEW-PEINH; for the info record, EINA (material + vendor) and EINE (purchasing organization + plant, standard record category) NETPR ÷ PEINH; for the previous order, the last earlier order item for the same material and vendor.
  4. Unit variance = order unit price − comparison price; variance amount = unit variance × EKPO-MENGE; variance % = unit variance ÷ comparison price × 100.
  5. Items whose absolute variance percentage is below the threshold can be hidden; the ALV gives subtotals by vendor and material group and sorts the largest variance amounts first.

Performance notes

Select EKKO by company code and order date; read MBEW, EINA and EINE for the material list in one go. The previous order price option needs an extra EKPO read; one read sorted by material and vendor is enough for it.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document The order number opens ME23N, the material opens the MM03 accounting view and the info record price opens ME13.
  • Export to Excel
  • Runs as a background job

Authorization objects

  • M_BEST_EKOPurchase order display authorization by purchasing organization
  • M_BEST_WRKPurchase order display authorization by plant
  • M_BEST_BSAPurchase order display authorization by document type

Frequently asked questions

Is the valuation price the price on the order date or today's price?

By default the current price in MBEW is used. If orders from past periods must be compared with the price of that period, the price of the period is read from the material valuation history during installation.

Can the variance be shown by condition (discount, freight)?

The report works with the net price. To see which condition causes the variance, the order condition records can be read during installation and the gross price, discount and additional costs shown in separate columns.

Are services and items without a material number included?

No. The valuation price and the info record depend on the material number, so only items with a material are compared. For text items the previous order price option can be adapted to work by material group.

Related reports

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: Purchase Price Variance (PPV) Report by Vendor and Material Group