SAP ABAP Table MBEWUN (Generated Table for View)

Basic Data

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

Delivery and Maintenance

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

Foreign Keys

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

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