SAP ABAP Table E3MBEWM (Master material material valuation (MBEW))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PCT (Application Component) Product Catalog
     ⤷ IDOCLOGISTICS (Package) IDoc Interface (logistics segment definitions)

Basic Data

Table Category	INTTAB	Structure
Structure	E3MBEWM	Table Relationship Diagram
Short Description	Master material material valuation (MBEW)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MSGFN	☑	MSGFN	MSGFN	CHAR	3	0	Function
2	BWKEY	☑	BWKEY	BWKEY	CHAR	4	0	Valuation area	*
3	BWTAR	☑	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
4	LVORM	☐	LVORM	XFELD	CHAR	1	0	Deletion Indicator
5	VPRSV	☐	VPRSV	VPRSV	CHAR	1	0	Price control indicator
6	VERPR	☐	VERPR	WERT11V	CURR	11	2	Moving Average Price/Periodic Unit Price
7	STPRS	☐	STPRS	WERT11V	CURR	11	2	Standard price
8	PEINH	☐	PEINH	PACK3	DEC	5	0	Price unit
9	BKLAS	☐	BKLAS	BKLAS	CHAR	4	0	Valuation Class	*
10	VMVPR	☐	VMVPR	VPRSV	CHAR	1	0	Price control indicator for previous period
11	VMVER	☐	VMVER	WERT11V	CURR	11	2	Moving Average Price/Periodic Unit Price in Previous Period
12	VMSTP	☐	VMSTP	WERT11V	CURR	11	2	Standard price in the previous period
13	VMPEI	☐	VMPEI	PACK3	DEC	5	0	Price unit of previous period
14	VMBKL	☐	VMBKL	BKLAS	CHAR	4	0	Valuation class of previous period	*
15	VJVPR	☐	VJVPR	VPRSV	CHAR	1	0	Price control indicator for previous year
16	VJVER	☐	VJVER	WERT11V	CURR	11	2	Moving Average Price/Periodic Unit Price in Previous Year
17	VJSTP	☐	VJSTP	WERT11V	CURR	11	2	Standard price in previous year
18	LFGJA	☐	LFGJA	GJAHR	NUMC	4	0	Fiscal Year of Current Period
19	LFMON	☐	LFMON	MONAT	NUMC	2	0	Current period (posting period)
20	BWTTY	☐	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	*
21	ZKPRS	☐	DZKPRS	WERT11	CURR	11	2	Future price
22	ZKDAT	☐	DZKDAT	DATUM	DATS	8	0	Date as of which the price is valid
23	BWPRS	☐	BWPRS	WERT11	CURR	11	2	Valuation price based on tax law: level 1
24	BWPRH	☐	BWPRH	WERT11	CURR	11	2	Valuation price based on commercial law: level 1
25	VJBWS	☐	VJBWS	WERT11	CURR	11	2	Valuation price based on tax law: level 3
26	VJBWH	☐	VJBWH	WERT11	CURR	11	2	Valuation price based on commercial law: level 3
27	VVJLB	☐	VVJLB	MENG13V	QUAN	13	3	Total valuated stock in year before last
28	VVMLB	☐	VVMLB	MENG13V	QUAN	13	3	Total valuated stock in period before last
29	VVSAL	☐	VVSAL	WERT13N	CURR	13	2	Value of total valuated stock in period before last
30	ZPLPR	☐	DZPLPR	WERT11	CURR	11	2	Future planned price
31	ZPLP1	☐	DZPLP1	WERT11	CURR	11	2	Future Planned Price 1
32	ZPLP2	☐	DZPLP2	WERT11	CURR	11	2	Future Planned Price 2
33	ZPLP3	☐	DZPLP3	WERT11	CURR	11	2	Future Planned Price 3
34	ZPLD1	☐	DZPLD1	DATUM	DATS	8	0	Date from Which Future Planned Price 1 Is Valid
35	ZPLD2	☐	DZPLD2	DATUM	DATS	8	0	Date from Which Future Planned Price 2 Is Valid
36	ZPLD3	☐	DZPLD3	DATUM	DATS	8	0	Date from Which Future Planned Price 3 Is Valid
37	KALKZ	☐	KALKZ	XFELD	CHAR	1	0	Indicator: Standard cost estimate for the period
38	KALKL	☐	KALKL	XFELD	CHAR	1	0	Indicator: standard cost estimate for current period
39	XLIFO	☐	XLIFO	LIFO_FIFO	CHAR	1	0	LIFO/FIFO-relevant
40	MYPOL	☐	MYPOOL	LIFO_POOL	CHAR	4	0	Pool number for LIFO valuation	*
41	BWPH1	☐	BWPH1	WERT11	CURR	11	2	Valuation price based on commercial law: level 2
42	BWPS1	☐	BWPS1	WERT11	CURR	11	2	Valuation price based on tax law: level 2
43	ABWKZ	☐	ABWKZ	NUMC2	NUMC	2	0	Lowest value: devaluation indicator
44	PSTAT	☐	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
45	KALN1	☐	CK_KALNR1	CK_KALNR	NUMC	12	0	Cost Estimate Number - Product Costing	*
46	KALNR	☐	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure	*
47	BWVA1	☐	CK_BWVA1	CK_BWVAR	CHAR	3	0	Valuation variant for the future standard cost estimate	*
48	BWVA2	☐	CK_BWVA2	CK_BWVAR	CHAR	3	0	Valuation variant for the current standard cost estimate	*
49	BWVA3	☐	CK_BWVA3	CK_BWVAR	CHAR	3	0	Valuation variant for past standard cost estimate	*
50	VERS1	☐	CK_TVERS1	CK_VERSION	NUMC	2	0	Costing version of the future standard cost estimate
51	VERS2	☐	CK_TVERS2	CK_VERSION	NUMC	2	0	Costing version of the current standard cost estimate
52	VERS3	☐	CK_TVERS3	CK_VERSION	NUMC	2	0	Costing version of the previous standard cost estimate
53	HRKFT	☐	HRKFT	HRKFT	CHAR	4	0	Origin Group as Subdivision of Cost Element	*
54	KOSGR	☐	CK_KOSGR	CK_KOSGR	CHAR	10	0	Costing overhead group	*
55	PPRDZ	☐	CK_PPRDZ	POPER	NUMC	3	0	Period of future cost estimate
56	PPRDL	☐	CK_PPRDL	POPER	NUMC	3	0	Period of the current cost estimate
57	PPRDV	☐	CK_PPRDV	POPER	NUMC	3	0	Period of the previous cost estimate
58	PDATZ	☐	CK_PDATZ	GJAHR	NUMC	4	0	Future fiscal year
59	PDATL	☐	CK_PDATL	GJAHR	NUMC	4	0	Fiscal year for current cost estimate
60	PDATV	☐	CK_PDATV	GJAHR	NUMC	4	0	Fiscal year of previous cost estimate
61	EKALR	☐	CK_EKALREL	XFELD	CHAR	1	0	Material Is Costed with Quantity Structure
62	VPLPR	☐	VPLPR	WERT11	CURR	11	2	Previous planned price
63	MLMAA	☐	CK_ML_MAAC	XFELD	CHAR	1	0	Material ledger activated at material level
64	MLAST	☐	CK_ML_ABST	CK_ML_ABST	CHAR	1	0	Material Price Determination: Control
65	VJBKL	☐	VJBKL	BKLAS	CHAR	4	0	Valuation class from previous year	*
66	VJPEI	☐	VJPEI	PACK3	DEC	5	0	Price unit of previous year
67	HKMAT	☐	HKMAT	HKMAT	CHAR	1	0	Material-related origin
68	EKLAS	☐	EKLAS	BKLAS	CHAR	4	0	Valuation Class for Sales Order Stock	*
69	QKLAS	☐	QKLAS	BKLAS	CHAR	4	0	Valuation Class for Project Stock	*
70	MTUSE	☐	J_1BMATUSE	J_1BMATUSE	CHAR	1	0	Usage of the material
71	MTORG	☐	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
72	OWNPR	☐	J_1BOWNPRO	XFELD	CHAR	1	0	Produced in-house
73	BWPEI	☐	BWPEI	PACK3	DEC	5	0	Price unit for valuation prices based on tax/commercial law

History

Last changed by/on	SAP	20130529
SAP Release Created in