SAP Reference

MBEW

master S/4HANA status: Active

Material Valuation

Identity
Module: MM · Materials ManagementType: transparent
What the badges mean
S/4HANA status: Active
Active and unchanged in S/4HANA.
S/4HANA status: Deprecated
Still readable today, but no longer SAP's strategic path — plan around it.
S/4HANA status: Replaced
Replaced by a new persistence in S/4HANA; the classic name may still answer reads (see read mechanism).
S/4HANA status: Migrating to IBP
Planning scope is moving from APO toward IBP.
S/4HANA status: Active (StRM) · Replaced (EWM)
Path-dependent: active with SAP Stock Room Management, replaced where EWM is the warehouse path.
S/4HANA status: Replaced · Compat View
Compatibility view: the classic table name is redirected to a view over the new persistence — see how the physical model moved.
S/4HANA status: Active · Proxy View
Proxy view: reads route through NSDM proxy/CDS views — see how the physical model moved.
master
Data class: what the table holds — master data, transaction documents, org structure, config, or texts (one row per language — see the quirks guide).
Linked type codes

CLNT — the client key; filter it explicitly and carry it through every join.

NUMC — fixed-width numeric text; keep it a string and keep the leading zeros.

DATS, TIMS — character date (YYYYMMDD) and time (HHMMSS), zero-filled when initial.

CURR, CUKY, QUAN, UNIT — amounts and quantities, meaningful only beside the currency key or unit that qualifies them.

LANG — a language key in a text table — one row per language.

In field listings, K marks a primary-key field, and linked type codes in the Type column jump to the matching quirks-guide section.
Modeling guide
Inventory & stock — What is on hand, where, and what moved it?
Used in the library
Dashboard patterns
D-01Inventory Health

Fields

38 fields · 4 key

The join key is all 4 key fields together — matching on any single one fans out. See composite keys in the quirks guide.

38 fields.

Table fields: key flag, field name, description, data type (linked to the data quirks guide where the type carries a known trap), length, and check-table references. 38 fields.
KeyFieldDescriptionTypeLengthReferences
Primary keyMANDTClientCLNT3T000
Primary keyMATNRMaterial NumberCHAR18 / 40MARA
Primary keyBWKEYValuation AreaCHAR4T001K
Primary keyBWTARValuation TypeCHAR10
VPRSVPrice Control IndicatorCHAR1
VERPRMoving Average Price/Periodic Unit PriceCURR11,2
STPRSStandard PriceCURR11,2
PEINHPrice UnitDEC5
LBKUMTotal Valuated StockQUAN13,3
SALK3Value of Total Valuated StockCURR13,2
BKLASValuation ClassCHAR4
SALKVValue Based on Moving Average Price (Only with Price Control S)CURR13,2
VMKUMTotal Valuated Stock of Previous DayQUAN13,3
VMSALValue of Total Valuated Stock of Previous DayCURR13,2
VMVPRPrice Control Indicator in Previous PeriodCHAR1
VMVERMAP Price of Previous PeriodCURR11,2
VMSTPStandard Price of Previous PeriodCURR11,2
VMPEIPrice Unit of Previous PeriodDEC5
VMBKLValuation Class of Previous PeriodCHAR4
VMSAVValue of Previous PeriodCURR13,2
VJVPRPrice Control Indicator in Previous YearCHAR1
VJVERMAP Price of Previous YearCURR11,2
VJSTPStandard Price of Previous YearCURR11,2
LFGJAFiscal Year of Current PeriodNUMC4
LFMONCurrent Period (Posting Period)NUMC2
BWTTYValuation CategoryCHAR1
STPRVPrevious PriceCURR11,2
LAEPRDate of Last Price ChangeDATS8
ZKPRSFuture PriceCURR11,2
ZKDATDate from Which Future Price Is EffectiveDATS8
BWPRSValuation Price Based on Tax/Commercial LawCURR11,2
BWPS1Valuation Price Based on Tax Law: Level 2CURR11,2
VJBWSValuation Price Based on Tax Law: Level 3CURR11,2
ABWKZLowest Value: Devaluation IndicatorNUMC2
PSTATMaintenance StatusCHAR15
HKMATMaterial OriginCHAR1
EKLASValuation Class for Sales Order StockCHAR4
QKLASValuation Class for Project StockCHAR4

Lengths shown as ECC / S/4HANA where the extended material number applies.

Linked type codes in the Type column jump to the matching section of the SAP data quirks guide.

Field provenance: hand-curated.

Boilerplate SQL

Starting point for reading MBEW on Databricks. Set your Unity Catalog location and filter values below — they’re substituted into the SQL and the copy button.

Query parameters

4 parameters not filled: <catalog>, <schema>, <MANDT>, <MATNR>

-- ============================================================
-- Table  : MBEW Material Valuation
-- Purpose: Column-selected read of MBEW — auto-generated from field metadata
-- Grain  : One row per MATNR + BWKEY + BWTAR
-- Notes  : Auto-generated skeleton. For multi-table transaction query patterns, see the linked t-codes on this page. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- ============================================================
SELECT
  mb.MANDT AS "Client",
  mb.MATNR AS "Material Number",
  mb.BWKEY AS "Valuation Area",
  mb.BWTAR AS "Valuation Type",
  mb.VPRSV AS "Price Control Indicator",
  mb.VERPR AS "Moving Average Price/Periodic Unit Price",
  mb.STPRS AS "Standard Price",
  mb.PEINH AS "Price Unit",
  mb.LBKUM AS "Total Valuated Stock",
  mb.SALK3 AS "Value of Total Valuated Stock",
  mb.BKLAS AS "Valuation Class",
  mb.SALKV AS "Value Based on Moving Average Price (Only with Price Control S)",
  mb.VMKUM AS "Total Valuated Stock of Previous Day",
  mb.VMSAL AS "Value of Total Valuated Stock of Previous Day",
  mb.VMVPR AS "Price Control Indicator in Previous Period",
  mb.VMVER AS "MAP Price of Previous Period",
  mb.VMSTP AS "Standard Price of Previous Period",
  mb.VMPEI AS "Price Unit of Previous Period",
  mb.VMBKL AS "Valuation Class of Previous Period",
  mb.VMSAV AS "Value of Previous Period",
  mb.VJVPR AS "Price Control Indicator in Previous Year",
  mb.VJVER AS "MAP Price of Previous Year",
  mb.VJSTP AS "Standard Price of Previous Year",
  mb.LFGJA AS "Fiscal Year of Current Period",
  mb.LFMON AS "Current Period (Posting Period)",
  mb.BWTTY AS "Valuation Category",
  mb.STPRV AS "Previous Price",
  mb.LAEPR AS "Date of Last Price Change",
  mb.ZKPRS AS "Future Price",
  mb.ZKDAT AS "Date from Which Future Price Is Effective",
  mb.BWPRS AS "Valuation Price Based on Tax/Commercial Law",
  mb.BWPS1 AS "Valuation Price Based on Tax Law: Level 2",
  mb.VJBWS AS "Valuation Price Based on Tax Law: Level 3",
  mb.ABWKZ AS "Lowest Value: Devaluation Indicator",
  mb.PSTAT AS "Maintenance Status",
  mb.HKMAT AS "Material Origin",
  mb.EKLAS AS "Valuation Class for Sales Order Stock",
  mb.QKLAS AS "Valuation Class for Project Stock"
FROM <catalog>.<schema>.mbew mb
WHERE
  mb.MANDT = '<MANDT>'
  -- AND mb.MATNR = '<MATNR>'
ORDER BY mb.MATNR;

Verified August 2026

More query patterns: MM01 MM02 MM03

Relationships

Diagram of 1-hop neighbors — join details below.

Join details

  • MARAMBEWforeign key · 1:N
    ON mara.MATNR = mbew.MATNR

Transaction Codes That Use This Table

R read · W write · R/W read + write

More Materials Management tables