E2MBEWM (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 E2MBEWM to other SAP tables.
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MSGFN
Function
|
MSGFN |
CHAR
|
3 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
BWKEY
Valuation Area
|
BWKEY |
CHAR
|
4 | 0 | ||||||||||||||||
|
BWTAR
Valuation Type
|
BWTAR_D |
CHAR
|
10 | 0 | ||||||||||||||||
|
LVORM
Deletion Indicator
|
LVORM |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
VPRSV
Price control indicator
|
VPRSV |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
KALKL
Standard Cost Estimate for Current Period
|
KALKL |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
XLIFO
LIFO/FIFO-Relevant
|
XLIFO |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
VPLPR
Character Field of Length 12
|
CHAR12 |
CHAR
|
12 | 0 | ||||||||||||||||
|
MLMAA
Material ledger activated at material level
|
CK_ML_MAAC |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
MLAST
Material Price Determination: Control
|
CK_ML_ABST |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||