SAP ABAP View MGV_QBEW (Selection QBEW 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_QBEW
Short Description	Selection QBEW with material version, see: http://material
Root table	QBEW	Project Stock Valuation

Table

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

Join Conditions

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