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
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| EKKOPurchasing Document Header | Order header: vendor, order date, currency and exchange rate (driving table) | — | ECC + S/4 |
| EKPOPurchasing Document Item | Order item: material, material group, quantity, net price and price unit | EKPO-EBELN = EKKO-EBELN | ECC + S/4 |
| MBEWMaterial Valuation | Material valuation: standard or moving average price | MBEW-MATNR = EKPO-MATNR AND MBEW-BWKEY = EKPO-WERKS | ECC + S/4 |
| EINAPurchasing Info Record: General Data | Purchasing info record general data (material and vendor) | EINA-MATNR = EKPO-MATNR AND EINA-LIFNR = EKKO-LIFNR | ECC + S/4 |
| EINEPurchasing Info Record: Purchasing Organization Data | Info record purchasing organization data: net price | EINE-INFNR = EINA-INFNR AND EINE-EKORG = EKKO-EKORG AND EINE-WERKS = EKPO-WERKS | ECC + S/4 |
| LFA1Vendor Master (General Section) | Vendor name | LFA1-LIFNR = EKKO-LIFNR | ECC + 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
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | EKKO-BUKRS | Yes | 1000 |
| S_EKORG | Purchasing organization | Range / multiple | EKKO-EKORG | No | 1000 |
| S_BEDAT | Order date | Range / multiple | EKKO-BEDAT | Yes | 01.10.2026 – 17.11.2026 |
| S_LIFNR | Vendor | Range / multiple | EKKO-LIFNR | No | 100387 |
| S_MATKL | Material group | Range / multiple | EKPO-MATKL | No | 01 |
| S_WERKS | Plant | Range / multiple | EKPO-WERKS | No | 1100 |
| R_BASE | Comparison base: valuation price / info record / previous order | Radio button | — | No | MBEW |
| P_MINPCT | Minimum variance to show (%) | Single value | — | No | 5 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Purchase order | EKPO-EBELN |
| 2 | Item | EKPO-EBELP |
| 3 | Order date | EKKO-BEDAT |
| 4 | Vendor | EKKO-LIFNR |
| 5 | Vendor name | LFA1-NAME1 |
| 6 | Material | EKPO-MATNR |
| 7 | Material group | EKPO-MATKL |
| 8 | Plant | EKPO-WERKS |
| 9 | Order qty | EKPO-MENGE |
| 10 | Order unit price | Calculated EKPO-NETPR ÷ EKPO-PEINH × EKKO-WKURS (company code currency) |
| 11 | Valuation price | Calculated MBEW-STPRS if VPRSV = S, MBEW-VERPR if V; ÷ MBEW-PEINH |
| 12 | Info record price | Calculated EINE-NETPR ÷ EINE-PEINH |
| 13 | Unit variance | Calculated Order unit price − selected comparison price |
| 14 | Variance amount | Calculated Unit variance × EKPO-MENGE |
| 15 | Variance (%) | Calculated Unit variance ÷ comparison price × 100 |
| 16 | Currency | Calculated Local currency of the company code |
Sample output
| Purchase order | Item | Order date | Vendor | Vendor name | Material | Material group | Plant | Order qty | Order unit price | Valuation price | Info record price | Unit variance | Variance amount | Variance (%) | Currency |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4500013140 | 00020 | 10/05/2026 | 100387 | Delta Metal | RM-2040 | 01 | 1100 | 1,200 | 66 | 61.20 | 62.50 | 4.80 | 5,760 | 7.80 | TRY |
| 4500013102 | 00010 | 10/12/2026 | 100245 | Atlas Ambalaj | PK-1180 | 03 | 1100 | 3,000 | 1.70 | 1.85 | 1.70 | -0.15 | -450 | -8.10 | TRY |
| 4500013177 | 00010 | 10/28/2026 | 100512 | Ege Kimya | CH-0315 | 02 | 1200 | 400 | 9.45 | 8.60 | 9.10 | 0.85 | 340 | 9.90 | TRY |
| 4500013190 | 00030 | 11/03/2026 | 100618 | Marmara Kablo | EL-7720 | 04 | 1100 | 600 | 36 | 35.40 | 36 | 0.60 | 360 | 1.70 | TRY |
How does the report work?
- 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.
- 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.
- 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.
- Unit variance = order unit price − comparison price; variance amount = unit variance × EKPO-MENGE; variance % = unit variance ÷ comparison price × 100.
- 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
Standard vs Current Cost Estimate Comparison by Cost Component
A custom ALV report that compares the released standard cost estimate of all materials in a plant with the current or modified cost estimate by cost …
Blocked Vendor Invoices with Price and Quantity Variance Report
A custom ALV report that lists vendor invoices blocked for payment in invoice verification with the block reason, the received quantity, the price …
Purchasing Contract Utilization and Remaining Balance Report
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 …
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.