SAP ABAP View MGV_EBEW (Selection EBEW witm 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_EBEW
Short Description	Selection EBEW witm material version, see: http://material ?
Root table	EBEW	Sales Order Stock Valuation

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EBEW	MANDT	JL	EQ				0	0
2	MATERIALID	MANDT	JR	EQ			AND	0	0
3	EBEW	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	*	EBEW	*		☐		☐
2	MANDT	EBEW	MANDT		☐	MANDT	☐	Client
3	MATNR	EBEW	MATNR		☐	MATNR	☐	Material Number
4	BWKEY	EBEW	BWKEY		☐	BWKEY	☐	Valuation area
5	BWTAR	EBEW	BWTAR		☐	BWTAR_D	☐	Valuation type
6	SOBKZ	EBEW	SOBKZ		☐	SOBKZ	☐	Special Stock Indicator
7	VBELN	EBEW	VBELN		☐	VBELN	☐	Sales and Distribution Document Number
8	POSNR	EBEW	POSNR		☐	POSNR	☐	Item number of the SD document
9	LBKUM	EBEW	LBKUM		☐	LBKUM	☐	Total Valuated Stock
10	SALK3	EBEW	SALK3		☐	SALK3	☐	Value of Total Valuated Stock
11	VPRSV	EBEW	VPRSV		☐	VPRSV	☐	Price control indicator
12	VERPR	EBEW	VERPR		☐	VERPR	☐	Moving Average Price/Periodic Unit Price
13	STPRS	EBEW	STPRS		☐	STPRS	☐	Standard price
14	PEINH	EBEW	PEINH		☐	PEINH	☐	Price unit
15	BKLAS	EBEW	BKLAS		☐	BKLAS	☐	Valuation Class
16	SALKV	EBEW	SALKV		☐	SALKV	☐	Value based on moving average price (only with price ctrl S)
17	VMKUM	EBEW	VMKUM		☐	VMKUM	☐	Total valuated stock in previous period
18	VMSAL	EBEW	VMSAL		☐	VMSAL	☐	Value of total valuated stock in previous period
19	VMVPR	EBEW	VMVPR		☐	VMVPR	☐	Price control indicator for previous period
20	VMVER	EBEW	VMVER		☐	VMVER	☐	Moving Average Price/Periodic Unit Price in Previous Period
21	VMSTP	EBEW	VMSTP		☐	VMSTP	☐	Standard price in the previous period
22	VMPEI	EBEW	VMPEI		☐	VMPEI	☐	Price unit of previous period
23	VMBKL	EBEW	VMBKL		☐	VMBKL	☐	Valuation class of previous period
24	VMSAV	EBEW	VMSAV		☐	VMSAV	☐	Value based on moving average price (previous period)
25	VJKUM	EBEW	VJKUM		☐	VJKUM	☐	Total valuated stock in previous year
26	VJSAL	EBEW	VJSAL		☐	VJSAL	☐	Value of total valuated stock in previous year
27	VJVPR	EBEW	VJVPR		☐	VJVPR	☐	Price control indicator for previous year
28	VJVER	EBEW	VJVER		☐	VJVER	☐	Moving Average Price/Periodic Unit Price in Previous Year
29	VJSTP	EBEW	VJSTP		☐	VJSTP	☐	Standard price in previous year
30	VJPEI	EBEW	VJPEI		☐	VJPEI	☐	Price unit of previous year
31	VJBKL	EBEW	VJBKL		☐	VJBKL	☐	Valuation class from previous year
32	VJSAV	EBEW	VJSAV		☐	VJSAV	☐	Value based on moving average price (previous year)
33	LFGJA	EBEW	LFGJA		☐	LFGJA	☐	Fiscal Year of Current Period
34	LFMON	EBEW	LFMON		☐	LFMON	☐	Current period (posting period)
35	BWTTY	EBEW	BWTTY		☐	BWTTY_D	☐	Valuation Category
36	STPRV	EBEW	STPRV		☐	STPRV	☐	Previous price
37	LAEPR	EBEW	LAEPR		☐	LAEPR	☐	Date of the last price change
38	ZKPRS	EBEW	ZKPRS		☐	DZKPRS	☐	Future price
39	ZKDAT	EBEW	ZKDAT		☐	DZKDAT	☐	Date as of which the price is valid
40	TIMESTAMP	EBEW	TIMESTAMP		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
41	ZPLPR	EBEW	ZPLPR		☐	DZPLPR	☐	Future planned price
42	KALKZ	EBEW	KALKZ		☐	KAXKZ	☐	Indicator: standard cost estimate for future period
43	KALKL	EBEW	KALKL		☐	KALKL	☐	Indicator: standard cost estimate for current period
44	KALKV	EBEW	KALKV		☐	KALKV	☐	Indicator: standard cost estimate for previous period
45	KALN1	EBEW	KALN1		☐	CK_KALNR1	☐	Cost Estimate Number - Product Costing
46	BWVA1	EBEW	BWVA1		☐	CK_BWVA1	☐	Valuation variant for the future standard cost estimate
47	BWVA2	EBEW	BWVA2		☐	CK_BWVA2	☐	Valuation variant for the current standard cost estimate
48	BWVA3	EBEW	BWVA3		☐	CK_BWVA3	☐	Valuation variant for past standard cost estimate
49	VERS1	EBEW	VERS1		☐	CK_TVERS1	☐	Costing version of the future standard cost estimate
50	VERS2	EBEW	VERS2		☐	CK_TVERS2	☐	Costing version of the current standard cost estimate
51	VERS3	EBEW	VERS3		☐	CK_TVERS3	☐	Costing version of the previous standard cost estimate
52	HRKFT	EBEW	HRKFT		☐	HRKFT	☐	Origin Group as Subdivision of Cost Element
53	KOSGR	EBEW	KOSGR		☐	CK_KOSGR	☐	Costing overhead group
54	PPRDZ	EBEW	PPRDZ		☐	CK_PPRDZ	☐	Period of future cost estimate
55	PPRDL	EBEW	PPRDL		☐	CK_PPRDL	☐	Period of the current cost estimate
56	PPRDV	EBEW	PPRDV		☐	CK_PPRDV	☐	Period of the previous cost estimate
57	PDATZ	EBEW	PDATZ		☐	CK_PDATZ	☐	Future fiscal year
58	PDATL	EBEW	PDATL		☐	CK_PDATL	☐	Fiscal year for current cost estimate
59	PDATV	EBEW	PDATV		☐	CK_PDATV	☐	Fiscal year of previous cost estimate
60	EKALR	EBEW	EKALR		☐	CK_EKALREL	☐	Material Is Costed with Quantity Structure
61	VPLPR	EBEW	VPLPR		☐	VPLPR	☐	Previous planned price
62	MLMAA	EBEW	MLMAA		☐	CK_ML_MAAC	☐	Material ledger activated at material level
63	MLAST	EBEW	MLAST		☐	CK_ML_ABST	☐	Material Price Determination: Control
64	LPLPR	EBEW	LPLPR		☐	CK_LPLPR	☐	Current Planned Price
65	VKSAL	EBEW	VKSAL		☐	VKSAL	☐	Value of Total Valuated Stock at Sales Price
66	HKMAT	EBEW	HKMAT		☐	HKMAT	☐	Material-related origin
67	BWSPA	EBEW	BWSPA		☐	BWSPA	☐	Valuation margin
68	LPLPX	EBEW	LPLPX		☐	CK_LPLPX	☐	Fixed Portion of Current Planned Price
69	VPLPX	EBEW	VPLPX		☐	CK_VPLPX	☐	Fixed Portion of Previous Planned Price
70	FPLPX	EBEW	FPLPX		☐	CK_ZPLPX	☐	Fixed Portion of Future Planned Price
71	LBWST	EBEW	LBWST		☐	CK_LBWST	☐	Val. strat. for current plan price, sales order/proj. stock
72	VBWST	EBEW	VBWST		☐	CK_VBWST	☐	Valn. strategy for prev. planned price, restricted use stock
73	FBWST	EBEW	FBWST		☐	CK_ZBWST	☐	Valn strategy for future planned price, restr. use stock
74	MBRUE	EBEW	MBRUE		☐	MBRUE	☐	MBEWH rec. already exists for per. before last of MBEW per.
75	OKLAS	EBEW	OKLAS		☐	OKLAS	☐	Valuation Class for Special Stock at the Vendor
76	MATNR_EXT	MATERIALID	MATNR_EXT		☐	MATNR_EXT	☐	External Long Material Number
77	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	20060920
SAP Release Created in