SAP ABAP View MGV_MBEW (Selection MBEW with material version, see: http://material)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ LO-MD-MM (Application Component) Material Master
     ⤷ MGV_MATNR (Package) Material number conversion (long mat. no.)

Basic Data

View Type	D	Database View
Database View	MGV_MBEW
Short Description	Selection MBEW with material version, see: http://material
Root table	MBEW	Material Valuation

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	MBEW	MBEW
2	MATERIALID

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	MBEW	MANDT	JL	EQ				0	0
2	MATERIALID	MANDT	JR	EQ			AND	0	0
3	MBEW	MATNR	JL	EQ				0	0
4	MATERIALID	MATNR_INT	JR	EQ				0	0

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20130529
SAP Release Created in