SAP ABAP View MBEWV (View for Logical Databases)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MG (Package) Application development R/3 material master prior to 3.0

Basic Data

View Type	S	Structure view, data selection not possible
Structure view, data selection not possible	MBEWV
Short Description	View for Logical Databases
Root table	MBEW	Material Valuation

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	MBEW	MBEW
2	T001K	MBEW	BWKEY	E

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

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

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