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

> 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.

- Type: Report, Custom development, ALV report
- Module: MM
- Estimated effort: M (4–6 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/purchase-price-variance-by-vendor-and-material-group-report/


## 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.

### Closest standard alternatives

- ME1P: Shows the order price history of one info record; gives no variance against the valuation price and no vendor totals.
- ME80FN: Lists order prices; does not calculate a comparison price or a variance percentage.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| EKKO | Order header: vendor, order date, currency and exchange rate (driving table) | Read | - | ECC + S/4 |
| EKPO | Order item: material, material group, quantity, net price and price unit | Read | EKPO-EBELN = EKKO-EBELN | ECC + S/4 |
| MBEW | Material valuation: standard or moving average price | Read | MBEW-MATNR = EKPO-MATNR AND MBEW-BWKEY = EKPO-WERKS | ECC + S/4 |
| EINA | Purchasing info record general data (material and vendor) | Read | EINA-MATNR = EKPO-MATNR AND EINA-LIFNR = EKKO-LIFNR | ECC + S/4 |
| EINE | Info record purchasing organization data: net price | Read | EINE-INFNR = EINA-INFNR AND EINE-EKORG = EKKO-EKORG AND EINE-WERKS = EKPO-WERKS | ECC + S/4 |
| LFA1 | Vendor name | Read | LFA1-LIFNR = EKKO-LIFNR | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | EKKO-BUKRS | Yes |
| S_EKORG | Purchasing organization | Range / multiple | EKKO-EKORG | No |
| S_BEDAT | Order date | Range / multiple | EKKO-BEDAT | Yes |
| S_LIFNR | Vendor | Range / multiple | EKKO-LIFNR | No |
| S_MATKL | Material group | Range / multiple | EKPO-MATKL | No |
| S_WERKS | Plant | Range / multiple | EKPO-WERKS | No |
| R_BASE | Comparison base: valuation price / info record / previous order | Radio button | - | No |
| P_MINPCT | Minimum variance to show (%) | Single value | - | No |

## Output columns

| Column | Source |
|---|---|
| Purchase order | EKPO-EBELN |
| Item | EKPO-EBELP |
| Order date | EKKO-BEDAT |
| Vendor | EKKO-LIFNR |
| Vendor name | LFA1-NAME1 |
| Material | EKPO-MATNR |
| Material group | EKPO-MATKL |
| Plant | EKPO-WERKS |
| Order qty | EKPO-MENGE |
| Order unit price | Calculated: EKPO-NETPR ÷ EKPO-PEINH × EKKO-WKURS (company code currency) |
| Valuation price | Calculated: MBEW-STPRS if VPRSV = S, MBEW-VERPR if V; ÷ MBEW-PEINH |
| Info record price | Calculated: EINE-NETPR ÷ EINE-PEINH |
| Unit variance | Calculated: Order unit price − selected comparison price |
| Variance amount | Calculated: Unit variance × EKPO-MENGE |
| Variance (%) | Calculated: Unit variance ÷ comparison price × 100 |
| Currency | Calculated: Local currency of the company code |

## 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.

## Authorization objects

- M_BEST_EKO: Purchase order display authorization by purchasing organization
- M_BEST_WRK: Purchase order display authorization by plant
- M_BEST_BSA: Purchase 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=mm-purchase-price-variance
