FI Report Custom development ALV report

Inventory Net Realizable Value (NRV) and Write-Down Provision Report (IAS 2)

Short answer: A report that compares the cost of inventory by material with the net realizable value calculated from recent sales prices less costs to sell, and calculates the write-down provision needed. Lines such as returns or free-of-charge sales are excluded by rule, and materials without sales are flagged; the result is an audit-ready listing.

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

Why is the standard not enough?

Standard lowest value determination (MRN0, MRN1, MRN2) proposes devaluation based on market price, range of coverage and movement rate; but it does not calculate net realizable value from actual sales invoices, after deducting costs to sell and excluding returns, free-of-charge or intercompany sales. The IAS 2 listing is usually assembled in Excel.

Who uses it? Finance and reporting teams, cost accounting, auditors and IFRS reporting teams.

Closest standard alternatives

  • MB5L List of Stock Values: Balances. Lists stock values by account and material; makes no comparison with sales prices.
  • CKM3 Material Price Analysis. Shows the Material Ledger price analysis; no net realizable value calculation.

Tables used

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

TableRoleJoinSystem
MBEWMaterial ValuationStock quantity, total value, valuation class and price control—ECC + S/4
VBRKBilling Document HeaderInvoice header: date, cancellation, billing type, rate—ECC + S/4
VBRPBilling Document: Item DataInvoice items: material, quantity, net valueVBRP-VBELN = VBRK-VBELNECC + S/4
MARAGeneral Material DataMaterial type, material group, base unitMARA-MATNR = MBEW-MATNRECC + S/4
MAKTMaterial DescriptionsMaterial descriptionMAKT-MATNR = MBEW-MATNRECC + S/4
MARMUnits of Measure for MaterialConversion of sales unit to base unitMARM-MATNR = VBRP-MATNR AND MARM-MEINH = VBRP-VRKMEECC + S/4
T001KValuation AreaLink of valuation area to company codeT001K-BWKEY = MBEW-BWKEYECC + S/4
CKMLCRMaterial Ledger: Period Totals (Values)Material Ledger period price (S/4HANA)—S/4HANA only

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.

BAPIs and functions used

  • CONVERT_TO_LOCAL_CURRENCYTranslate Foreign Currency Amount to Local Currency. Converts the invoice amount to local currency

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
P_BUKRSCompany codeSingle valueT001K-BUKRSYes1000
S_BWKEYValuation area (plant)Range / multipleMBEW-BWKEYNo1000
P_PERIODClosing period / yearSingle value—Yes12.2026
S_FKDATSales price periodRange / multipleVBRK-FKDATYes01.10.2026 – 31.12.2026
S_BKLASValuation classRange / multipleMBEW-BKLASNo7920
P_NOSALEWithout sales: last price / list price / leave emptyRadio button—NoSon fiyat

Output columns

#ColumnSource
1PlantMBEW-BWKEY
2MaterialMBEW-MATNR
3DescriptionMAKT-MAKTX
4Stock quantityMBEW-LBKUM
5Cost valueMBEW-SALK3
6Unit sales priceCalculated Σ VBRP-NETWR (local currency) / Σ VBRP-FKIMG (base unit), excluded invoices left out
7Costs to sell %Calculated Rate set during installation for the material group
8NRVCalculated Unit price × (1 − costs to sell %) × stock quantity
9Write-down neededCalculated max(0, cost value − NRV)
10NoteCalculated No sales, list price used or number of excluded invoices

Sample output

PlantMaterialDescriptionStock quantityCost valueUnit sales priceCosts to sell %NRVWrite-down neededNote
1000MK-NEV-150Duvet cover set double, grey4,2001,890,000520121,921,9200
1000MK-HAV-070Bath towel 70x140, white9,8001,176,000128121,103,87272,128
1000IP-PES-NM60Polyester yarn Nm 6015,5001,069,500666961,620107,8802 return invoices excluded
2000MK-PERDE-OLDCurtain panel, old season1,300247,0009515104,975142,025No sales; last price used
A view built with fictional sample data; not real system data.

How does the report work?

  1. Stock quantity and cost value are taken by valuation area (plant) from MBEW (LBKUM, SALK3) for the closing period; in S/4HANA the Material Ledger price can be read from CKMLCR for actual cost. MBEWH is used for prior periods.
  2. Recent sales price: invoices in the chosen period (VBRK/VBRP) are read per material; cancelled invoices (VBRK-FKSTO), returns and credit memos, billing types excluded during installation and intercompany customers are left out. Unit price = Σ net value (converted to local currency) / Σ billed quantity (converted to the base unit).
  3. Costs to sell: rates defined during installation by material group or product hierarchy (freight, commission, marketing) are deducted from the unit price. The rates are the company’s own data and are reviewed at period end.
  4. NRV = (unit sales price − costs to sell) × stock quantity. Write-down needed = max(0, cost value − NRV).
  5. Materials without sales in the period are flagged separately; for these the program, by selection, looks for the last sales price, uses the list price (price condition) or leaves them for user assessment. For semi-finished goods and raw materials the cost to complete is deducted with the method chosen during installation.
  6. The report totals by material, valuation class and plant; the difference to the prior period provision is shown as the amount to post. In S/4HANA the inventory value can be reconciled with ACDOCA; in ECC the flow with MBEW and BSEG is the same.

Performance notes

Read invoice items in one SELECT aggregated by material for the period and material list (GROUP BY). Convert currency per document with the rate on the invoice header. For many plants run the report in the background and store the result.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Clicking the unit price lists the invoices used in the calculation.
  • Export to Excel The audit listing is exported to Excel.
  • Runs as a background job

Authorization objects

  • K_ML_VADisplay of Material Ledger values
  • V_VBRK_VKOBilling document display by sales organization
  • F_BKPF_BUKFinancial data display by company code

Frequently asked questions

How does it differ from standard lowest value determination?

MRN0-MRN2 propose devaluation based on market price, range of coverage or movement rate and can change the price. This report calculates NRV from actual sales invoices and shows the write-down needed; the posting decision is made in accounting. Both methods can be used together.

Where do the costs to sell rates come from?

The rates come from the company's own cost analysis and are entered in a table by material group or product hierarchy during installation. The program does not suggest rates; check at period end that they are current.

Does the report post the provision?

No, the report calculates the amount and shows the difference to the prior period. The posting is entered by accounting according to the company's provision policy; it can be automated with a separate posting program if needed.

Related reports

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

FI Report Custom ALV report TR

Inventory Book (Envanter Defteri) Report and Print

A custom ALV report and print output that prepares the year-end inventory book from SAP account by account. The closing balance of every balance sheet …

FAGLFLEXT · ACDOCA · SKAT · BSID

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: Inventory Net Realizable Value (NRV) and Write-Down Provision Report (IAS 2)