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
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
X Yes
NULL No
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
S Standard price
V Moving average price/periodic unit price
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
S Standard price
V Moving average price/periodic unit price
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
S Standard price
V Moving average price/periodic unit price
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
X Yes
NULL No
KALKL Standard Cost Estimate for Current Period KALKL CHAR 1 0
X Yes
NULL No
KALKV Indicator: standard cost estimate for previous period KALKV CHAR 1 0
X Yes
NULL No
KALSC Overhead key (deactivated) KALSC CHAR 6 0
XLIFO LIFO/FIFO-Relevant XLIFO CHAR 1 0
X LIFO and FIFO Relevant
NULL Not LIFO/FIFO Relevant
1 LIFO-relevant
2 FIFO-relevant
3 LIFO- and FIFO-relevant (obsolete)
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
X Yes
NULL No
VPLPR Previous planned price VPLPR CURR 11 2
MLMAA Material ledger activated at material level CK_ML_MAAC CHAR 1 0
X Yes
NULL No
MLAST Material Price Determination: Control CK_ML_ABST CHAR 1 0
2 Transaction-Based
3 Single-/Multilevel
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
NULL No material-related origin
X Keep costs/quantities under material number
SPERW Physical Inventory Blocking Indicator SPERR CHAR 1 0
NULL No physical inventory defined for material
X Due to phys. inv., material is blocked for movements
A Physical inventory not yet completed for material
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
1 Value from Product Cost Estimate for Sales Order
2 Value from Production Order Cost Estimate
3 Value from Make-to-Stock Inventory
4 Value from Make-to-Order Stock Segment
5 Value from Unit Cost Estimate for Sales Order
6 Value from User Exit
7 Value from Unit Cost Estimate for WBS Component
8 Value from Cost Estimate for a Configurable Material
9 Value from Production Lot Cost Estimate
VBWST Valuation Strategy for Previous Plan Price, Special Stock CK_VBWST CHAR 1 0
1 Value from Product Cost Estimate for Sales Order
2 Value from Production Order Cost Estimate
3 Value from Make-to-Stock Inventory
4 Value from Make-to-Order Stock Segment
5 Value from Unit Cost Estimate for Sales Order
6 Value from User Exit
7 Value from Unit Cost Estimate for WBS Component
8 Value from Cost Estimate for a Configurable Material
9 Value from Production Lot Cost Estimate
FBWST Valuation Strategy for Future Planned Price, Special Stock CK_ZBWST CHAR 1 0
1 Value from Product Cost Estimate for Sales Order
2 Value from Production Order Cost Estimate
3 Value from Make-to-Stock Inventory
4 Value from Make-to-Order Stock Segment
5 Value from Unit Cost Estimate for Sales Order
6 Value from User Exit
7 Value from Unit Cost Estimate for WBS Component
8 Value from Cost Estimate for a Configurable Material
9 Value from Production Lot Cost Estimate
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
0 Resale
1 Industrialisation
2 Consumption
3 Asset
MTORG Origin of the material J_1BMATORG CHAR 1 0
1 Foreign - imported directly
2 Foreign - acquired nationally
0 National - except indicated for codes 3, 4, 5 or 8
3 National - with import content over 40% and below/equal 70%
4 National - production with tax incentive
5 National - with import content less than or equal to 40%
6 Foreign - imp direct,no similar nat.,Res.CAMEX & nat.gas
7 Foreign - acquired nat.,no similar nat.,Res.CAMEX & nat.gas
8 National - with import content over 70%
OWNPR Produced in-house J_1BOWNPRO CHAR 1 0
X Yes
NULL No
XBEWM Valuation based on the batch-specific unit of measure XBEWW CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
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
NULL No - Material is not Prepaid Inventory
X Yes - Material is Prepaid Inventory
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