SAP ABAP Table MGV_MBEW (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	MGV_MBEW	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	TIMESTAMP	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
38	BWPRS	BWPRS	WERT11	CURR	11	2	Valuation price based on tax law: level 1
39	BWPRH	BWPRH	WERT11	CURR	11	2	Valuation price based on commercial law: level 1
40	VJBWS	VJBWS	WERT11	CURR	11	2	Valuation price based on tax law: level 3
41	VJBWH	VJBWH	WERT11	CURR	11	2	Valuation price based on commercial law: level 3
42	VVJSL	VVJSL	WERT13N	CURR	13	2	Value of total valuated stock in year before last
43	VVJLB	VVJLB	MENG13V	QUAN	13	3	Total valuated stock in year before last
44	VVMLB	VVMLB	MENG13V	QUAN	13	3	Total valuated stock in period before last
45	VVSAL	VVSAL	WERT13N	CURR	13	2	Value of total valuated stock in period before last
46	ZPLPR	DZPLPR	WERT11	CURR	11	2	Future planned price
47	ZPLP1	DZPLP1	WERT11	CURR	11	2	Future Planned Price 1
48	ZPLP2	DZPLP2	WERT11	CURR	11	2	Future Planned Price 2
49	ZPLP3	DZPLP3	WERT11	CURR	11	2	Future Planned Price 3
50	ZPLD1	DZPLD1	DATUM	DATS	8	0	Date from Which Future Planned Price 1 Is Valid
51	ZPLD2	DZPLD2	DATUM	DATS	8	0	Date from Which Future Planned Price 2 Is Valid
52	ZPLD3	DZPLD3	DATUM	DATS	8	0	Date from Which Future Planned Price 3 Is Valid
53	PPERZ	PPERZ	BUPER	ACCP	6	0	Period for future standard cost estimate (deactivated)
54	PPERL	PPERL	BUPER	ACCP	6	0	Period for current standard cost estimate (deactivated)
55	PPERV	PPERV	BUPER	ACCP	6	0	Period for previous standard cost estimate (deactivated)
56	KALKZ	KAXKZ	XFELD	CHAR	1	0	Indicator: standard cost estimate for future period
57	KALKL	KALKL	XFELD	CHAR	1	0	Indicator: standard cost estimate for current period
58	KALKV	KALKV	XFELD	CHAR	1	0	Indicator: standard cost estimate for previous period
59	KALSC	KALSC	KALSC	CHAR	6	0	Overhead key (deactivated)
60	XLIFO	XLIFO	LIFO_FIFO	CHAR	1	0	LIFO/FIFO-relevant
61	MYPOL	MYPOOL	LIFO_POOL	CHAR	4	0	Pool number for LIFO valuation	TPOOL
62	BWPH1	BWPH1	WERT11	CURR	11	2	Valuation price based on commercial law: level 2
63	BWPS1	BWPS1	WERT11	CURR	11	2	Valuation price based on tax law: level 2
64	ABWKZ	ABWKZ	NUMC2	NUMC	2	0	Lowest value: devaluation indicator
65	PSTAT	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
66	KALN1	CK_KALNR1	CK_KALNR	NUMC	12	0	Cost Estimate Number - Product Costing
67	KALNR	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure
68	BWVA1	CK_BWVA1	CK_BWVAR	CHAR	3	0	Valuation variant for the future standard cost estimate	TCK05
69	BWVA2	CK_BWVA2	CK_BWVAR	CHAR	3	0	Valuation variant for the current standard cost estimate	TCK05
70	BWVA3	CK_BWVA3	CK_BWVAR	CHAR	3	0	Valuation variant for past standard cost estimate	TCK05
71	VERS1	CK_TVERS1	CK_VERSION	NUMC	2	0	Costing version of the future standard cost estimate
72	VERS2	CK_TVERS2	CK_VERSION	NUMC	2	0	Costing version of the current standard cost estimate
73	VERS3	CK_TVERS3	CK_VERSION	NUMC	2	0	Costing version of the previous standard cost estimate
74	HRKFT	HRKFT	HRKFT	CHAR	4	0	Origin Group as Subdivision of Cost Element	TKKH1
75	KOSGR	CK_KOSGR	CK_KOSGR	CHAR	10	0	Costing overhead group	TCK14
76	PPRDZ	CK_PPRDZ	POPER	NUMC	3	0	Period of future cost estimate
77	PPRDL	CK_PPRDL	POPER	NUMC	3	0	Period of the current cost estimate
78	PPRDV	CK_PPRDV	POPER	NUMC	3	0	Period of the previous cost estimate
79	PDATZ	CK_PDATZ	GJAHR	NUMC	4	0	Future fiscal year
80	PDATL	CK_PDATL	GJAHR	NUMC	4	0	Fiscal year for current cost estimate
81	PDATV	CK_PDATV	GJAHR	NUMC	4	0	Fiscal year of previous cost estimate
82	EKALR	CK_EKALREL	XFELD	CHAR	1	0	Material Is Costed with Quantity Structure
83	VPLPR	VPLPR	WERT11	CURR	11	2	Previous planned price
84	MLMAA	CK_ML_MAAC	XFELD	CHAR	1	0	Material ledger activated at material level
85	MLAST	CK_ML_ABST	CK_ML_ABST	CHAR	1	0	Material Price Determination: Control
86	LPLPR	CK_LPLPR	WERT11	CURR	11	2	Current Planned Price
87	VKSAL	VKSAL	WERT13N	CURR	13	2	Value of Total Valuated Stock at Sales Price
88	HKMAT	HKMAT	HKMAT	CHAR	1	0	Material-related origin
89	SPERW	SPERR	SPERR	CHAR	1	0	Physical inventory blocking indicator
90	KZIWL	KZIWL	INVKZ	CHAR	3	0	Phys. inventory indicator for value-only material
91	WLINL	DLINL	DATS	DATS	8	0	Date of last physical inventory for unrestricted-use stock
92	ABCIW	ABCIN	ABCIN	CHAR	1	0	Physical inventory indicator for cycle counting
93	BWSPA	BWSPA	PRZ32V	DEC	6	2	Valuation margin
94	LPLPX	CK_LPLPX	WERT11V	CURR	11	2	Fixed Portion of Current Planned Price
95	VPLPX	CK_VPLPX	WERT11V	CURR	11	2	Fixed Portion of Previous Planned Price
96	FPLPX	CK_ZPLPX	WERT11V	CURR	11	2	Fixed Portion of Future Planned Price
97	LBWST	CK_LBWST	CK_BWST	CHAR	1	0	Val. strat. for current plan price, sales order/proj. stock
98	VBWST	CK_VBWST	CK_BWST	CHAR	1	0	Valn. strategy for prev. planned price, restricted use stock
99	FBWST	CK_ZBWST	CK_BWST	CHAR	1	0	Valn strategy for future planned price, restr. use stock
100	EKLAS	EKLAS	BKLAS	CHAR	4	0	Valuation Class for Sales Order Stock	T025
101	QKLAS	QKLAS	BKLAS	CHAR	4	0	Valuation Class for Project Stock	T025
102	MTUSE	J_1BMATUSE	J_1BMATUSE	CHAR	1	0	Usage of the material
103	MTORG	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
104	OWNPR	J_1BOWNPRO	XFELD	CHAR	1	0	Produced in-house
105	XBEWM	XBEWW	XFELD	CHAR	1	0	Valuation based on the batch-specific unit of measure
106	BWPEI	BWPEI	PACK3	DEC	5	0	Price unit for valuation prices based on tax/commercial law
107	MBRUE	MBRUE	XFELD	CHAR	1	0	MBEWH rec. already exists for per. before last of MBEW per.
108	OKLAS	OKLAS	BKLAS	CHAR	4	0	Valuation Class for Special Stock at the Vendor	T025
109	OIPPINV	JV_PPINV	JV_PPINV	CHAR	1	0	Prepaid Inventory Flag for Material Valuation Type Segment
110	MATNR_EXT	MATNR_EXT	MATNR_EXT	CHAR	40	0	External Long Material Number
111	MATNR_VERS	MATNR_VERS	MATNR_VERS	CHAR	10	0	Material Version Number

Foreign Keys

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

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