SAP ABAP Table MBEWV (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	MBEWV	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

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

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	MANDT	MANDT	CLNT	3	0	Client	T000
2	MATNR	MATNR	MATNR	CHAR	18	0	Material Number	MARA
3	BWKEY	BWKEY	BWKEY	CHAR	4	0	Valuation area	T001K
4	BWTAR	BWTAR_D	BWTAR	CHAR	10	0	Valuation type
5	LVORM	LVOBA	XFELD	CHAR	1	0	Deletion flag for all material data of a valuation type
6	LBKUM	LBKUM	MENG13V	QUAN	13	3	Total Valuated Stock
7	SALK3	SALK3	WERT13N	CURR	13	2	Value of Total Valuated Stock
8	VPRSV	VPRSV	VPRSV	CHAR	1	0	Price control indicator
9	VERPR	VERPR	WERT11V	CURR	11	2	Moving Average Price/Periodic Unit Price
10	STPRS	STPRS	WERT11V	CURR	11	2	Standard price
11	PEINH	PEINH	PACK3	DEC	5	0	Price unit
12	BKLAS	BKLAS	BKLAS	CHAR	4	0	Valuation Class	T025
13	SALKV	SALKV	WERT13N	CURR	13	2	Value based on moving average price (only with price ctrl S)
14	VMKUM	VMKUM	MENG13V	QUAN	13	3	Total valuated stock in previous period
15	VMSAL	VMSAL	WERT13N	CURR	13	2	Value of total valuated stock in previous period
16	VMVPR	VMVPR	VPRSV	CHAR	1	0	Price control indicator for previous period
17	VMVER	VMVER	WERT11V	CURR	11	2	Moving Average Price/Periodic Unit Price in Previous Period
18	VMSTP	VMSTP	WERT11V	CURR	11	2	Standard price in the previous period
19	VMPEI	VMPEI	PACK3	DEC	5	0	Price unit of previous period
20	VMBKL	VMBKL	BKLAS	CHAR	4	0	Valuation class of previous period	T025
21	VMSAV	VMSAV	WERT13N	CURR	13	2	Value based on moving average price (previous period)
22	VJKUM	VJKUM	MENG13V	QUAN	13	3	Total valuated stock in previous year
23	VJSAL	VJSAL	WERT13N	CURR	13	2	Value of total valuated stock in previous year
24	VJVPR	VJVPR	VPRSV	CHAR	1	0	Price control indicator for previous year
25	VJVER	VJVER	WERT11V	CURR	11	2	Moving Average Price/Periodic Unit Price in Previous Year
26	VJSTP	VJSTP	WERT11V	CURR	11	2	Standard price in previous year
27	VJPEI	VJPEI	PACK3	DEC	5	0	Price unit of previous year
28	VJBKL	VJBKL	BKLAS	CHAR	4	0	Valuation class from previous year	T025
29	VJSAV	VJSAV	WERT13N	CURR	13	2	Value based on moving average price (previous year)
30	LFGJA	LFGJA	GJAHR	NUMC	4	0	Fiscal Year of Current Period
31	LFMON	LFMON	MONAT	NUMC	2	0	Current period (posting period)
32	BWTTY	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	T149
33	STPRV	STPRV	WERT11V	CURR	11	2	Previous price
34	LAEPR	LAEPR	DATUM	DATS	8	0	Date of the last price change
35	ZKPRS	DZKPRS	WERT11	CURR	11	2	Future price
36	ZKDAT	DZKDAT	DATUM	DATS	8	0	Date as of which the price is valid
37	BWPRS	BWPRS	WERT11	CURR	11	2	Valuation price based on tax law: level 1
38	BWPRH	BWPRH	WERT11	CURR	11	2	Valuation price based on commercial law: level 1
39	VJBWS	VJBWS	WERT11	CURR	11	2	Valuation price based on tax law: level 3
40	VJBWH	VJBWH	WERT11	CURR	11	2	Valuation price based on commercial law: level 3
41	VVJSL	VVJSL	WERT13N	CURR	13	2	Value of total valuated stock in year before last
42	VVJLB	VVJLB	MENG13V	QUAN	13	3	Total valuated stock in year before last
43	VVMLB	VVMLB	MENG13V	QUAN	13	3	Total valuated stock in period before last
44	VVSAL	VVSAL	WERT13N	CURR	13	2	Value of total valuated stock in period before last
45	ZPLPR	DZPLPR	WERT11	CURR	11	2	Future planned price
46	ZPLP1	DZPLP1	WERT11	CURR	11	2	Future Planned Price 1
47	ZPLP2	DZPLP2	WERT11	CURR	11	2	Future Planned Price 2
48	ZPLP3	DZPLP3	WERT11	CURR	11	2	Future Planned Price 3
49	ZPLD1	DZPLD1	DATUM	DATS	8	0	Date from Which Future Planned Price 1 Is Valid
50	ZPLD2	DZPLD2	DATUM	DATS	8	0	Date from Which Future Planned Price 2 Is Valid
51	ZPLD3	DZPLD3	DATUM	DATS	8	0	Date from Which Future Planned Price 3 Is Valid
52	KALKZ	KAXKZ	XFELD	CHAR	1	0	Indicator: standard cost estimate for future period
53	KALKL	KALKL	XFELD	CHAR	1	0	Indicator: standard cost estimate for current period
54	KALKV	KALKV	XFELD	CHAR	1	0	Indicator: standard cost estimate for previous period
55	XLIFO	XLIFO	LIFO_FIFO	CHAR	1	0	LIFO/FIFO-relevant
56	MYPOL	MYPOOL	LIFO_POOL	CHAR	4	0	Pool number for LIFO valuation	TPOOL
57	BWPH1	BWPH1	WERT11	CURR	11	2	Valuation price based on commercial law: level 2
58	BWPS1	BWPS1	WERT11	CURR	11	2	Valuation price based on tax law: level 2
59	ABWKZ	ABWKZ	NUMC2	NUMC	2	0	Lowest value: devaluation indicator
60	PSTAT	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
61	KALN1	CK_KALNR1	CK_KALNR	NUMC	12	0	Cost Estimate Number - Product Costing
62	KALNR	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure
63	BWVA1	CK_BWVA1	CK_BWVAR	CHAR	3	0	Valuation variant for the future standard cost estimate	TCK05
64	BWVA2	CK_BWVA2	CK_BWVAR	CHAR	3	0	Valuation variant for the current standard cost estimate	TCK05
65	BWVA3	CK_BWVA3	CK_BWVAR	CHAR	3	0	Valuation variant for past standard cost estimate	TCK05
66	VERS1	CK_TVERS1	CK_VERSION	NUMC	2	0	Costing version of the future standard cost estimate
67	VERS2	CK_TVERS2	CK_VERSION	NUMC	2	0	Costing version of the current standard cost estimate
68	VERS3	CK_TVERS3	CK_VERSION	NUMC	2	0	Costing version of the previous standard cost estimate
69	HRKFT	HRKFT	HRKFT	CHAR	4	0	Origin Group as Subdivision of Cost Element	TKKH1
70	KOSGR	CK_KOSGR	CK_KOSGR	CHAR	10	0	Costing overhead group	TCK14
71	PPRDZ	CK_PPRDZ	POPER	NUMC	3	0	Period of future cost estimate
72	PPRDL	CK_PPRDL	POPER	NUMC	3	0	Period of the current cost estimate
73	PPRDV	CK_PPRDV	POPER	NUMC	3	0	Period of the previous cost estimate
74	PDATZ	CK_PDATZ	GJAHR	NUMC	4	0	Future fiscal year
75	PDATL	CK_PDATL	GJAHR	NUMC	4	0	Fiscal year for current cost estimate
76	PDATV	CK_PDATV	GJAHR	NUMC	4	0	Fiscal year of previous cost estimate
77	EKALR	CK_EKALREL	XFELD	CHAR	1	0	Material Is Costed with Quantity Structure
78	VPLPR	VPLPR	WERT11	CURR	11	2	Previous planned price
79	HKMAT	HKMAT	HKMAT	CHAR	1	0	Material-related origin
80	BWMOD	BWMOD	CHAR4	CHAR	4	0	Valuation grouping code
81	BUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
82	MLMAA	CK_ML_MAAC	XFELD	CHAR	1	0	Material ledger activated at material level
83	MLAST	CK_ML_ABST	CK_ML_ABST	CHAR	1	0	Material Price Determination: Control
84	LPLPR	CK_LPLPR	WERT11	CURR	11	2	Current Planned Price
85	VKSAL	VKSAL	WERT13N	CURR	13	2	Value of Total Valuated Stock at Sales Price
86	SPERW	SPERR	SPERR	CHAR	1	0	Physical inventory blocking indicator
87	KZIWL	KZIWL	INVKZ	CHAR	3	0	Phys. inventory indicator for value-only material
88	WLINL	DLINL	DATS	DATS	8	0	Date of last physical inventory for unrestricted-use stock
89	ABCIW	ABCIN	ABCIN	CHAR	1	0	Physical inventory indicator for cycle counting
90	BWSPA	BWSPA	PRZ32V	DEC	6	2	Valuation margin
91	LPLPX	CK_LPLPX	WERT11V	CURR	11	2	Fixed Portion of Current Planned Price
92	VPLPX	CK_VPLPX	WERT11V	CURR	11	2	Fixed Portion of Previous Planned Price
93	FPLPX	CK_ZPLPX	WERT11V	CURR	11	2	Fixed Portion of Future Planned Price
94	LBWST	CK_LBWST	CK_BWST	CHAR	1	0	Val. strat. for current plan price, sales order/proj. stock
95	VBWST	CK_VBWST	CK_BWST	CHAR	1	0	Valn. strategy for prev. planned price, restricted use stock
96	FBWST	CK_ZBWST	CK_BWST	CHAR	1	0	Valn strategy for future planned price, restr. use stock
97	EKLAS	EKLAS	BKLAS	CHAR	4	0	Valuation Class for Sales Order Stock	T025
98	QKLAS	QKLAS	BKLAS	CHAR	4	0	Valuation Class for Project Stock	T025
99	MTUSE	J_1BMATUSE	J_1BMATUSE	CHAR	1	0	Usage of the material
100	MTORG	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
101	OWNPR	J_1BOWNPRO	XFELD	CHAR	1	0	Produced in-house
102	XBEWM	XBEWW	XFELD	CHAR	1	0	Valuation based on the batch-specific unit of measure
103	BWPEI	BWPEI	PACK3	DEC	5	0	Price unit for valuation prices based on tax/commercial law
104	OKLAS	OKLAS	BKLAS	CHAR	4	0	Valuation Class for Special Stock at the Vendor	T025

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right

1	MBEWV	BKLAS	T025	BKLAS	REF	C	CN
2	MBEWV	BUKRS	T001	BUKRS	REF	1	CN
3	MBEWV	BWKEY	T001K	BWKEY	KEY	1	CN
4	MBEWV	BWTTY	T149	BWTTY	REF	C	CN
5	MBEWV	BWVA1	TCK05	BWVAR	REF	C	CN
6	MBEWV	BWVA2	TCK05	BWVAR	REF	C	CN
7	MBEWV	BWVA3	TCK05	BWVAR	REF	C	CN
8	MBEWV	EKLAS	T025	BKLAS
9	MBEWV	HRKFT	TKKH1	HRKFT	REF	C	CN
10	MBEWV	KOSGR	TCK14	KOSGR	REF	C	CN
11	MBEWV	MANDT	T000	MANDT	KEY	1	CN
12	MBEWV	MATNR	MARA	MATNR	KEY	1	CN
13	MBEWV	MYPOL	TPOOL	MYPOOL	REF	C	CN
14	MBEWV	OKLAS	T025	BKLAS
15	MBEWV	QKLAS	T025	BKLAS
16	MBEWV	VJBKL	T025	BKLAS	REF	C	CN
17	MBEWV	VMBKL	T025	BKLAS	REF	C	CN