SAP Table MBEW
Material Valuation
MBEW (Material Valuation) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link MBEW to other SAP tables.
MBEW table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||||||||
|
MATNR
Material Number
|
MATNR | MARA |
CHAR
|
18 | 0 | |||||||||||||||||||||
|
BWKEY
Valuation Area
|
BWKEY | T001K |
CHAR
|
4 | 0 | |||||||||||||||||||||
|
BWTAR
Valuation Type
|
BWTAR_D |
CHAR
|
10 | 0 | ||||||||||||||||||||||
|
LVORM
Deletion flag for all material data of a valuation type
|
LVOBA |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
LBKUM
Total Valuated Stock
|
LBKUM |
QUAN
|
13 | 3 | ||||||||||||||||||||||
|
SALK3
Value of Total Valuated Stock
|
SALK3 |
CURR
|
13 | 2 | ||||||||||||||||||||||
|
VPRSV
Price control indicator
|
VPRSV |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
VERPR
Moving Average Price/Periodic Unit Price
|
VERPR |
CURR
|
11 | 2 | ||||||||||||||||||||||
|
STPRS
Standard price
|
STPRS |
CURR
|
11 | 2 | ||||||||||||||||||||||
|
PEINH
Price Unit
|
PEINH |
DEC
|
5 | 0 | ||||||||||||||||||||||
|
BKLAS
Valuation Class
|
BKLAS | T025 |
CHAR
|
4 | 0 | |||||||||||||||||||||
|
SALKV
Value based on moving average price (only with price ctrl S)
|
SALKV |
CURR
|
13 | 2 | ||||||||||||||||||||||
|
VMKUM
Total valuated stock in previous period
|
VMKUM |
QUAN
|
13 | 3 | ||||||||||||||||||||||
|
VMSAL
Value of total valuated stock in previous period
|
VMSAL |
CURR
|
13 | 2 | ||||||||||||||||||||||
|
VMVPR
Price Control Indicator in Previous Period
|
VMVPR |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
VMVER
Moving Average Price/Periodic Unit Price in Previous Period
|
VMVER |
CURR
|
11 | 2 | ||||||||||||||||||||||
|
VMSTP
Standard price in the previous period
|
VMSTP |
CURR
|
11 | 2 | ||||||||||||||||||||||
|
VMPEI
Price unit of previous period
|
VMPEI |
DEC
|
5 | 0 | ||||||||||||||||||||||
|
VMBKL
Valuation Class in Previous Period
|
VMBKL | T025 |
CHAR
|
4 | 0 | |||||||||||||||||||||
|
VMSAV
Value based on moving average price (previous period)
|
VMSAV |
CURR
|
13 | 2 | ||||||||||||||||||||||
|
VJKUM
Total Valuated Stock in Previous Year
|
VJKUM |
QUAN
|
13 | 3 | ||||||||||||||||||||||
|
VJSAL
Value of total valuated stock in previous year
|
VJSAL |
CURR
|
13 | 2 | ||||||||||||||||||||||
|
VJVPR
Price Control Indicator in Previous Year
|
VJVPR |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
VJVER
Moving Average Price/Periodic Unit Price in Previous Year
|
VJVER |
CURR
|
11 | 2 | ||||||||||||||||||||||
|
VJSTP
Standard price in previous year
|
VJSTP |
CURR
|
11 | 2 | ||||||||||||||||||||||
|
VJPEI
Price unit of previous year
|
VJPEI |
DEC
|
5 | 0 | ||||||||||||||||||||||
|
VJBKL
Valuation Class in Previous Year
|
VJBKL | T025 |
CHAR
|
4 | 0 | |||||||||||||||||||||
|
VJSAV
Value based on moving average price (previous year)
|
VJSAV |
CURR
|
13 | 2 | ||||||||||||||||||||||
|
LFGJA
Fiscal Year of Current Period
|
LFGJA |
NUMC
|
4 | 0 | ||||||||||||||||||||||
|
LFMON
Current period (posting period)
|
LFMON |
NUMC
|
2 | 0 | ||||||||||||||||||||||
|
BWTTY
Valuation Category
|
BWTTY_D | T149 |
CHAR
|
1 | 0 | |||||||||||||||||||||
|
STPRV
Previous price
|
STPRV |
CURR
|
11 | 2 | ||||||||||||||||||||||
|
LAEPR
Date of the last price change
|
LAEPR |
DATS
|
8 | 0 | ||||||||||||||||||||||
|
ZKPRS
Future price
|
DZKPRS |
CURR
|
11 | 2 | ||||||||||||||||||||||
|
ZKDAT
Date as of which the price is valid
|
DZKDAT |
DATS
|
8 | 0 | ||||||||||||||||||||||
|
TIMESTAMP
UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
|
TIMESTAMP |
DEC
|
15 | 0 | ||||||||||||||||||||||
|
BWPRS
Valuation price based on tax law: level 1
|
BWPRS |
CURR
|
11 | 2 | ||||||||||||||||||||||
|
BWPRH
Valuation price based on commercial law: level 1
|
BWPRH |
CURR
|
11 | 2 | ||||||||||||||||||||||
|
VJBWS
Valuation price based on tax law: level 3
|
VJBWS |
CURR
|
11 | 2 | ||||||||||||||||||||||
|
VJBWH
Valuation price based on commercial law: level 3
|
VJBWH |
CURR
|
11 | 2 | ||||||||||||||||||||||
|
VVJSL
Value of total valuated stock in year before last
|
VVJSL |
CURR
|
13 | 2 | ||||||||||||||||||||||
|
VVJLB
Total valuated stock in year before last
|
VVJLB |
QUAN
|
13 | 3 | ||||||||||||||||||||||
|
VVMLB
Total valuated stock in period before last
|
VVMLB |
QUAN
|
13 | 3 | ||||||||||||||||||||||
|
VVSAL
Value of total valuated stock in period before last
|
VVSAL |
CURR
|
13 | 2 | ||||||||||||||||||||||
|
ZPLPR
Future planned price
|
DZPLPR |
CURR
|
11 | 2 | ||||||||||||||||||||||
|
ZPLP1
Future Planned Price 1
|
DZPLP1 |
CURR
|
11 | 2 | ||||||||||||||||||||||
|
ZPLP2
Future Planned Price 2
|
DZPLP2 |
CURR
|
11 | 2 | ||||||||||||||||||||||
|
ZPLP3
Future Planned Price 3
|
DZPLP3 |
CURR
|
11 | 2 | ||||||||||||||||||||||
|
ZPLD1
Date from Which Future Planned Price 1 Is Valid
|
DZPLD1 |
DATS
|
8 | 0 | ||||||||||||||||||||||
|
ZPLD2
Date from Which Future Planned Price 2 Is Valid
|
DZPLD2 |
DATS
|
8 | 0 | ||||||||||||||||||||||
|
ZPLD3
Date from Which Future Planned Price 3 Is Valid
|
DZPLD3 |
DATS
|
8 | 0 | ||||||||||||||||||||||
|
PPERZ
Period for future standard cost estimate (deactivated)
|
PPERZ |
ACCP
|
6 | 0 | ||||||||||||||||||||||
|
PPERL
Period for current standard cost estimate (deactivated)
|
PPERL |
ACCP
|
6 | 0 | ||||||||||||||||||||||
|
PPERV
Period for previous standard cost estimate (deactivated)
|
PPERV |
ACCP
|
6 | 0 | ||||||||||||||||||||||
|
KALKZ
Indicator: standard cost estimate for future period
|
KAXKZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
KALKL
Standard Cost Estimate for Current Period
|
KALKL |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
KALKV
Indicator: standard cost estimate for previous period
|
KALKV |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
KALSC
Overhead key (deactivated)
|
KALSC |
CHAR
|
6 | 0 | ||||||||||||||||||||||
|
XLIFO
LIFO/FIFO-Relevant
|
XLIFO |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
MYPOL
Pool number for LIFO valuation
|
MYPOOL | TPOOL |
CHAR
|
4 | 0 | |||||||||||||||||||||
|
BWPH1
Valuation price based on commercial law: level 2
|
BWPH1 |
CURR
|
11 | 2 | ||||||||||||||||||||||
|
BWPS1
Valuation price based on tax law: level 2
|
BWPS1 |
CURR
|
11 | 2 | ||||||||||||||||||||||
|
ABWKZ
Lowest value: devaluation indicator
|
ABWKZ |
NUMC
|
2 | 0 | ||||||||||||||||||||||
|
PSTAT
Maintenance status
|
PSTAT_D |
CHAR
|
15 | 0 | ||||||||||||||||||||||
|
KALN1
Cost Estimate Number - Product Costing
|
CK_KALNR1 |
NUMC
|
12 | 0 | ||||||||||||||||||||||
|
KALNR
Cost Estimate Number for Cost Est. w/o Qty Structure
|
CK_KALNR |
NUMC
|
12 | 0 | ||||||||||||||||||||||
|
BWVA1
Valuation Variant for Future Standard Cost Estimate
|
CK_BWVA1 | TCK05 |
CHAR
|
3 | 0 | |||||||||||||||||||||
|
BWVA2
Valuation Variant for Current Standard Cost Estimate
|
CK_BWVA2 | TCK05 |
CHAR
|
3 | 0 | |||||||||||||||||||||
|
BWVA3
Valuation Variant for Previous Standard Cost Estimate
|
CK_BWVA3 | TCK05 |
CHAR
|
3 | 0 | |||||||||||||||||||||
|
VERS1
Costing Version of Future Standard Cost Estimate
|
CK_TVERS1 |
NUMC
|
2 | 0 | ||||||||||||||||||||||
|
VERS2
Costing Version of Current Standard Cost Estimate
|
CK_TVERS2 |
NUMC
|
2 | 0 | ||||||||||||||||||||||
|
VERS3
Costing Version of Previous Standard Cost Estimate
|
CK_TVERS3 |
NUMC
|
2 | 0 | ||||||||||||||||||||||
|
HRKFT
Origin Group as Subdivision of Cost Element
|
HRKFT | TKKH1 |
CHAR
|
4 | 0 | |||||||||||||||||||||
|
KOSGR
Costing Overhead Group
|
CK_KOSGR | TCK14 |
CHAR
|
10 | 0 | |||||||||||||||||||||
|
PPRDZ
Period of Future Standard Cost Estimate
|
CK_PPRDZ |
NUMC
|
3 | 0 | ||||||||||||||||||||||
|
PPRDL
Period of Current Standard Cost Estimate
|
CK_PPRDL |
NUMC
|
3 | 0 | ||||||||||||||||||||||
|
PPRDV
Period of Previous Standard Cost Estimate
|
CK_PPRDV |
NUMC
|
3 | 0 | ||||||||||||||||||||||
|
PDATZ
Fiscal Year of Future Standard Cost Estimate
|
CK_PDATZ |
NUMC
|
4 | 0 | ||||||||||||||||||||||
|
PDATL
Fiscal Year of Current Standard Cost Estimate
|
CK_PDATL |
NUMC
|
4 | 0 | ||||||||||||||||||||||
|
PDATV
Fiscal Year of Previous Standard Cost Estimate
|
CK_PDATV |
NUMC
|
4 | 0 | ||||||||||||||||||||||
|
EKALR
Material Is Costed with Quantity Structure
|
CK_EKALREL |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
VPLPR
Previous planned price
|
VPLPR |
CURR
|
11 | 2 | ||||||||||||||||||||||
|
MLMAA
Material ledger activated at material level
|
CK_ML_MAAC |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
MLAST
Material Price Determination: Control
|
CK_ML_ABST |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
LPLPR
Current Planned Price
|
CK_LPLPR |
CURR
|
11 | 2 | ||||||||||||||||||||||
|
VKSAL
Value of Total Valuated Stock at Sales Price
|
VKSAL |
CURR
|
13 | 2 | ||||||||||||||||||||||
|
HKMAT
Material-related origin
|
HKMAT |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
SPERW
Physical Inventory Blocking Indicator
|
SPERR |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
KZIWL
Phys. inventory indicator for value-only material
|
KZIWL |
CHAR
|
3 | 0 | ||||||||||||||||||||||
|
WLINL
Date of Last Posted Count for Unrestricted-Use Stock
|
DLINL |
DATS
|
8 | 0 | ||||||||||||||||||||||
|
ABCIW
Physical inventory indicator for cycle counting
|
ABCIN |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
BWSPA
Valuation margin
|
BWSPA |
DEC
|
6 | 2 | ||||||||||||||||||||||
|
LPLPX
Fixed Portion of Current Planned Price
|
CK_LPLPX |
CURR
|
11 | 2 | ||||||||||||||||||||||
|
VPLPX
Fixed Portion of Previous Planned Price
|
CK_VPLPX |
CURR
|
11 | 2 | ||||||||||||||||||||||
|
FPLPX
Fixed Portion of Future Planned Price
|
CK_ZPLPX |
CURR
|
11 | 2 | ||||||||||||||||||||||
|
LBWST
Val. Strat. for Current Plan Price, Sales Order/Proj. Stock
|
CK_LBWST |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
VBWST
Valuation Strategy for Previous Plan Price, Special Stock
|
CK_VBWST |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
FBWST
Valuation Strategy for Future Planned Price, Special Stock
|
CK_ZBWST |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
EKLAS
Valuation Class for Sales Order Stock
|
EKLAS | T025 |
CHAR
|
4 | 0 | |||||||||||||||||||||
|
QKLAS
Valuation Class for Project Stock
|
QKLAS | T025 |
CHAR
|
4 | 0 | |||||||||||||||||||||
|
MTUSE
Usage of the material
|
J_1BMATUSE |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
MTORG
Origin of the material
|
J_1BMATORG |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
OWNPR
Produced in-house
|
J_1BOWNPRO |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
XBEWM
Valuation based on the batch-specific unit of measure
|
XBEWW |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
BWPEI
Price unit for valuation prices based on tax/commercial law
|
BWPEI |
DEC
|
5 | 0 | ||||||||||||||||||||||
|
MBRUE
MBEWH rec. already exists for per. before last of MBEW per.
|
MBRUE |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
OKLAS
Valuation Class for Special Stock at the Vendor
|
OKLAS | T025 |
CHAR
|
4 | 0 | |||||||||||||||||||||
|
OICURVAL
Current value
|
OIH_CURVAL |
CURR
|
13 | 2 | ||||||||||||||||||||||
|
OICURDATE
Current date
|
OIH_CURDAT |
DATS
|
8 | 0 | ||||||||||||||||||||||
|
OICURQTY
Current quantity
|
OIH_CURQTY |
QUAN
|
13 | 3 | ||||||||||||||||||||||
|
OICURUT
Current unit of measure
|
OIH_CURUT |
UNIT
|
3 | 0 | ||||||||||||||||||||||
|
OIFUTVAL
Future value
|
OIH_FUTVAL |
CURR
|
13 | 2 | ||||||||||||||||||||||
|
OIFUTDATE
Future date
|
OIH_FUTDAT |
DATS
|
8 | 0 | ||||||||||||||||||||||
|
OIFUTQTY
Future quantity
|
OIH_FUTQTY |
QUAN
|
13 | 3 | ||||||||||||||||||||||
|
OIFUTUT
Future unit of measure
|
OIH_FUTUT |
UNIT
|
3 | 0 | ||||||||||||||||||||||
|
OINVALQTY
Not to be used!!! (non valuated quantity)
|
OIH_NVALQT |
QUAN
|
13 | 3 | ||||||||||||||||||||||
|
OIREQUAT
Quantity to be revaluated
|
OIH_REQUAT |
QUAN
|
13 | 3 | ||||||||||||||||||||||
|
OITAXKEY
Excise Duty Status
|
OIH_TAXKEY | OIH4 |
CHAR
|
2 | 0 | |||||||||||||||||||||
|
OIHANTYP
Excise Duty Handling Type
|
OIH_HANTYP | OIH5 |
CHAR
|
2 | 0 | |||||||||||||||||||||
|
OIHMTXGR
Material tax group
|
OIH_J1B_MTXGR | OIH2M_J1B |
CHAR
|
4 | 0 | |||||||||||||||||||||
|
OIPPINV
Prepaid Inventory Flag for Material Valuation Type Segment
|
JV_PPINV |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
CON_FIN_VALLEVEL
Valuation Level
|
CON_FIN_VALLEVEL |
CHAR
|
3 | 0 | ||||||||||||||||||||||
|
CON_FIN_VALPROC
Valuation Procedure
|
CON_FIN_VALPROC |
CHAR
|
3 | 0 | ||||||||||||||||||||||
MBEW foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| MBEW | BKLAS | MBEW | MANDT |
T025
Valuation Classes
|
MANDT |
| MBEW | BKLAS | MBEW | BKLAS |
T025
Valuation Classes
|
BKLAS |
| MBEW | BWKEY | MBEW | MANDT |
T001K
Valuation area
|
MANDT |
| MBEW | BWKEY | MBEW | BWKEY |
T001K
Valuation area
|
BWKEY |
| MBEW | BWTTY | MBEW | MANDT |
T149
Valuation type/valuation class
|
MANDT |
| MBEW | BWTTY | MBEW | BWKEY |
T149
Valuation type/valuation class
|
BWKEY |
| MBEW | BWTTY | MBEW | BWTTY |
T149
Valuation type/valuation class
|
BWTTY |
| MBEW | BWVA1 | MBEW | BWVA1 |
TCK05
Valuation Variants in Costing
|
BWVAR |
| MBEW | BWVA1 | MBEW | MANDT |
TCK05
Valuation Variants in Costing
|
MANDT |
| MBEW | BWVA2 | MBEW | MANDT |
TCK05
Valuation Variants in Costing
|
MANDT |
| MBEW | BWVA2 | MBEW | BWVA2 |
TCK05
Valuation Variants in Costing
|
BWVAR |
| MBEW | BWVA3 | MBEW | MANDT |
TCK05
Valuation Variants in Costing
|
MANDT |
| MBEW | BWVA3 | MBEW | BWVA3 |
TCK05
Valuation Variants in Costing
|
BWVAR |
| MBEW | EKLAS | SYST | MANDT |
T025
Valuation Classes
|
MANDT |
| MBEW | EKLAS | MBEW | EKLAS |
T025
Valuation Classes
|
BKLAS |
| MBEW | HRKFT | MBEW | HRKFT |
TKKH1
Origin in CO Object
|
HRKFT |
| MBEW | HRKFT | MBEW | MANDT |
TKKH1
Origin in CO Object
|
MANDT |
| MBEW | HRKFT | RM03M | KOKRS |
TKKH1
Origin in CO Object
|
KOKRS |
| MBEW | HRKFT | '02' |
TKKH1
Origin in CO Object
|
KOATY | |
| MBEW | KOSGR | MBEW | MANDT |
TCK14
Overhead Groups
|
MANDT |
| MBEW | KOSGR | MBEW | BWKEY |
TCK14
Overhead Groups
|
BWKEY |
| MBEW | KOSGR | MBEW | KOSGR |
TCK14
Overhead Groups
|
KOSGR |
| MBEW | MANDT | MBEW | MANDT |
T000
Clients
|
MANDT |
| MBEW | MATNR | MBEW | MANDT |
MARA
General Material Data
|
MANDT |
| MBEW | MATNR | MBEW | MATNR |
MARA
General Material Data
|
MATNR |
| MBEW | MYPOL | MBEW | MANDT |
TPOOL
Master Record, LIFO Pools
|
MANDT |
| MBEW | MYPOL | MYMS | MYKEY |
TPOOL
Master Record, LIFO Pools
|
MYKEY |
| MBEW | MYPOL | MBEW | MYPOL |
TPOOL
Master Record, LIFO Pools
|
MYPOOL |
| MBEW | OIHANTYP | SYST | MANDT |
OIH5
Definition of Excise Duty Handling Type (IS-OIL-TDP)
|
MANDT |
| MBEW | OIHANTYP | MBEW | OIHANTYP |
OIH5
Definition of Excise Duty Handling Type (IS-OIL-TDP)
|
HANTYP |
| MBEW | OIHMTXGR | SYST | MANDT |
OIH2M_J1B
Check table for material tax group
|
MANDT |
| MBEW | OIHMTXGR | MBEW | OIHMTXGR |
OIH2M_J1B
Check table for material tax group
|
OIHMTXGR |
| MBEW | OITAXKEY | SYST | MANDT |
OIH4
Excise duty tax status (IS-Oil TDP standard/core object)
|
MANDT |
| MBEW | OITAXKEY | MBEW | OITAXKEY |
OIH4
Excise duty tax status (IS-Oil TDP standard/core object)
|
TAXKEY |
| MBEW | OKLAS | MBEW | OKLAS |
T025
Valuation Classes
|
BKLAS |
| MBEW | OKLAS | SYST | MANDT |
T025
Valuation Classes
|
MANDT |
| MBEW | QKLAS | SYST | MANDT |
T025
Valuation Classes
|
MANDT |
| MBEW | QKLAS | MBEW | QKLAS |
T025
Valuation Classes
|
BKLAS |
| MBEW | VJBKL | MBEW | MANDT |
T025
Valuation Classes
|
MANDT |
| MBEW | VJBKL | MBEW | VJBKL |
T025
Valuation Classes
|
BKLAS |
| MBEW | VMBKL | MBEW | VMBKL |
T025
Valuation Classes
|
BKLAS |
| MBEW | VMBKL | MBEW | MANDT |
T025
Valuation Classes
|
MANDT |