1. Home
  2. Resources
  3. SAP Tables
  4. E1MBEWM - Master material material valuation (MBEW)

SAP Table E1MBEWM

Master material material valuation (MBEW)

E1MBEWM (Master material material valuation (MBEW)) 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 E1MBEWM to other SAP tables.

E1MBEWM table fields

Field Data element Checktable Datatype Length Decimals
MSGFN Function MSGFN CHAR 3 0
003 Delete: Message contains objects to be deleted
004 Change: Message contains changes
005 Replace: This message replaces previous messages
009 Original: First message for process
023 Wait/Adjust: Data should not be imported
018 Resend
BWKEY Valuation Area BWKEY CHAR 4 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
LVORM Deletion Indicator LVORM CHAR 1 0
X Yes
NULL No
VPRSV Price control indicator VPRSV CHAR 1 0
S Standard price
V Moving average price/periodic unit price
VERPR Character Field of Length 12 CHAR12 CHAR 12 0
STPRS Character Field of Length 12 CHAR12 CHAR 12 0
PEINH R/2 table CHAR5 CHAR 5 0
BKLAS Valuation Class BKLAS CHAR 4 0
VMVPR Price Control Indicator in Previous Period VMVPR CHAR 1 0
S Standard price
V Moving average price/periodic unit price
VMVER Character Field of Length 12 CHAR12 CHAR 12 0
VMSTP Character Field of Length 12 CHAR12 CHAR 12 0
VMPEI R/2 table CHAR5 CHAR 5 0
VMBKL Valuation Class in Previous Period VMBKL CHAR 4 0
VJVPR Price Control Indicator in Previous Year VJVPR CHAR 1 0
S Standard price
V Moving average price/periodic unit price
VJVER Character Field of Length 12 CHAR12 CHAR 12 0
VJSTP Character Field of Length 12 CHAR12 CHAR 12 0
LFGJA Not More Closely Defined Area, Possibly Used for Patchlevels CHAR4 CHAR 4 0
LFMON Version Number Component CHAR2 CHAR 2 0
BWTTY Valuation Category BWTTY_D CHAR 1 0
ZKPRS Character Field of Length 12 CHAR12 CHAR 12 0
ZKDAT Character field, 8 characters long CHAR8 CHAR 8 0
BWPRS Character Field of Length 12 CHAR12 CHAR 12 0
BWPRH Character Field of Length 12 CHAR12 CHAR 12 0
VJBWS Character Field of Length 12 CHAR12 CHAR 12 0
VJBWH Character Field of Length 12 CHAR12 CHAR 12 0
VVJLB Char 15 CHAR15 CHAR 15 0
VVMLB Char 15 CHAR15 CHAR 15 0
VVSAL Char 15 CHAR15 CHAR 15 0
ZPLPR Character Field of Length 12 CHAR12 CHAR 12 0
ZPLP1 Character Field of Length 12 CHAR12 CHAR 12 0
ZPLP2 Character Field of Length 12 CHAR12 CHAR 12 0
ZPLP3 Character Field of Length 12 CHAR12 CHAR 12 0
ZPLD1 Character field, 8 characters long CHAR8 CHAR 8 0
ZPLD2 Character field, 8 characters long CHAR8 CHAR 8 0
ZPLD3 Character field, 8 characters long CHAR8 CHAR 8 0
KALKZ Indicator: Standard cost estimate for the period KALKZ CHAR 1 0
X Yes
NULL No
KALKL Standard Cost Estimate for Current Period KALKL CHAR 1 0
X Yes
NULL No
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 CHAR 4 0
BWPH1 Character Field of Length 12 CHAR12 CHAR 12 0
BWPS1 Character Field of Length 12 CHAR12 CHAR 12 0
ABWKZ Version Number Component CHAR2 CHAR 2 0
PSTAT Maintenance status PSTAT_D CHAR 15 0
KALN1 Character Field of Length 12 CHAR12 CHAR 12 0
KALNR Character Field of Length 12 CHAR12 CHAR 12 0
BWVA1 Valuation Variant for Future Standard Cost Estimate CK_BWVA1 CHAR 3 0
BWVA2 Valuation Variant for Current Standard Cost Estimate CK_BWVA2 CHAR 3 0
BWVA3 Valuation Variant for Previous Standard Cost Estimate CK_BWVA3 CHAR 3 0
VERS1 Version Number Component CHAR2 CHAR 2 0
VERS2 Version Number Component CHAR2 CHAR 2 0
VERS3 Version Number Component CHAR2 CHAR 2 0
HRKFT Origin Group as Subdivision of Cost Element HRKFT CHAR 4 0
KOSGR Costing Overhead Group CK_KOSGR CHAR 10 0
PPRDZ 3-Byte field CHAR3 CHAR 3 0
PPRDL 3-Byte field CHAR3 CHAR 3 0
PPRDV 3-Byte field CHAR3 CHAR 3 0
PDATZ Not More Closely Defined Area, Possibly Used for Patchlevels CHAR4 CHAR 4 0
PDATL Not More Closely Defined Area, Possibly Used for Patchlevels CHAR4 CHAR 4 0
PDATV Not More Closely Defined Area, Possibly Used for Patchlevels CHAR4 CHAR 4 0
EKALR Material Is Costed with Quantity Structure CK_EKALREL CHAR 1 0
X Yes
NULL No
VPLPR Character Field of Length 12 CHAR12 CHAR 12 0
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
VJBKL Valuation Class in Previous Year VJBKL CHAR 4 0
VJPEI Character Field With Field Length 7 CHAR07 CHAR 7 0
HKMAT Material-related origin HKMAT CHAR 1 0
NULL No material-related origin
X Keep costs/quantities under material number
EKLAS CHAR 4 0
QKLAS CHAR 4 0
MTUSE CHAR 1 0
MTORG CHAR 1 0
OWNPR CHAR 1 0
BWPEI CHAR 6 0
CON_FIN_VALLEVEL CHAR 3 0
CON_FIN_VALPROC CHAR 3 0