SAP ABAP View J_1AMBEW (MBEW and Inflation Enhancement)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CA-GTF-CSC (Application Component) Country-Specific Objects
     ⤷ J1AI (Package) Extended inflation FI

Basic Data

View Type	D	Database View
Database View	J_1AMBEW
Short Description	MBEW and Inflation Enhancement
Root table	MBEW	Material Valuation

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	MBEW	MBEW
2	MARA
3	T001K

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	MARA	MANDT	JL	EQ				0	0
2	MBEW	MANDT	JR	EQ			AND	0	0
3	MARA	MATNR	JL	EQ				0	0
4	MBEW	MATNR	JR	EQ			AND	0	0
5	T001K	MANDT	JL	EQ				0	0
6	MBEW	MANDT	JR	EQ			AND	0	0
7	T001K	BWKEY	JL	EQ				0	0
8	MBEW	BWKEY	JR	EQ				0	0

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	PPERZ	MBEW	PPERZ		☐	PPERZ	☐	Period for future standard cost estimate (deactivated)
53	PPERL	MBEW	PPERL		☐	PPERL	☐	Period for current standard cost estimate (deactivated)
54	PPERV	MBEW	PPERV		☐	PPERV	☐	Period for previous standard cost estimate (deactivated)
55	KALKZ	MBEW	KALKZ		☐	KAXKZ	☐	Indicator: standard cost estimate for future period
56	KALKL	MBEW	KALKL		☐	KALKL	☐	Indicator: standard cost estimate for current period
57	KALKV	MBEW	KALKV		☐	KALKV	☐	Indicator: standard cost estimate for previous period
58	KALSC	MBEW	KALSC		☐	KALSC	☐	Overhead key (deactivated)
59	XLIFO	MBEW	XLIFO		☐	XLIFO	☐	LIFO/FIFO-relevant
60	MYPOL	MBEW	MYPOL		☐	MYPOOL	☐	Pool number for LIFO valuation
61	BWPH1	MBEW	BWPH1		☐	BWPH1	☐	Valuation price based on commercial law: level 2
62	BWPS1	MBEW	BWPS1		☐	BWPS1	☐	Valuation price based on tax law: level 2
63	ABWKZ	MBEW	ABWKZ		☐	ABWKZ	☐	Lowest value: devaluation indicator
64	PSTAT	MBEW	PSTAT		☐	PSTAT_D	☐	Maintenance status
65	KALN1	MBEW	KALN1		☐	CK_KALNR1	☐	Cost Estimate Number - Product Costing
66	KALNR	MBEW	KALNR		☐	CK_KALNR	☐	Cost Estimate Number for Cost Est. w/o Qty Structure
67	BWVA1	MBEW	BWVA1		☐	CK_BWVA1	☐	Valuation variant for the future standard cost estimate
68	BWVA2	MBEW	BWVA2		☐	CK_BWVA2	☐	Valuation variant for the current standard cost estimate
69	BWVA3	MBEW	BWVA3		☐	CK_BWVA3	☐	Valuation variant for past standard cost estimate
70	VERS1	MBEW	VERS1		☐	CK_TVERS1	☐	Costing version of the future standard cost estimate
71	VERS2	MBEW	VERS2		☐	CK_TVERS2	☐	Costing version of the current standard cost estimate
72	VERS3	MBEW	VERS3		☐	CK_TVERS3	☐	Costing version of the previous standard cost estimate
73	HRKFT	MBEW	HRKFT		☐	HRKFT	☐	Origin Group as Subdivision of Cost Element
74	KOSGR	MBEW	KOSGR		☐	CK_KOSGR	☐	Costing overhead group
75	PPRDZ	MBEW	PPRDZ		☐	CK_PPRDZ	☐	Period of future cost estimate
76	PPRDL	MBEW	PPRDL		☐	CK_PPRDL	☐	Period of the current cost estimate
77	PPRDV	MBEW	PPRDV		☐	CK_PPRDV	☐	Period of the previous cost estimate
78	PDATZ	MBEW	PDATZ		☐	CK_PDATZ	☐	Future fiscal year
79	PDATL	MBEW	PDATL		☐	CK_PDATL	☐	Fiscal year for current cost estimate
80	PDATV	MBEW	PDATV		☐	CK_PDATV	☐	Fiscal year of previous cost estimate
81	EKALR	MBEW	EKALR		☐	CK_EKALREL	☐	Material Is Costed with Quantity Structure
82	VPLPR	MBEW	VPLPR		☐	VPLPR	☐	Previous planned price
83	MLMAA	MBEW	MLMAA		☐	CK_ML_MAAC	☐	Material ledger activated at material level
84	MLAST	MBEW	MLAST		☐	CK_ML_ABST	☐	Material Price Determination: Control
85	LPLPR	MBEW	LPLPR		☐	CK_LPLPR	☐	Current Planned Price
86	VKSAL	MBEW	VKSAL		☐	VKSAL	☐	Value of Total Valuated Stock at Sales Price
87	HKMAT	MBEW	HKMAT		☐	HKMAT	☐	Material-related origin
88	SPERW	MBEW	SPERW		☐	SPERR	☐	Physical inventory blocking indicator
89	KZIWL	MBEW	KZIWL		☐	KZIWL	☐	Phys. inventory indicator for value-only material
90	WLINL	MBEW	WLINL		☐	DLINL	☐	Date of last physical inventory for unrestricted-use stock
91	ABCIW	MBEW	ABCIW		☐	ABCIN	☐	Physical inventory indicator for cycle counting
92	BWSPA	MBEW	BWSPA		☐	BWSPA	☐	Valuation margin
93	MTART	MARA	MTART		☐	MTART	☐	Material type
94	MEINS	MARA	MEINS		☐	MEINS	☐	Base Unit of Measure
95	BUKRS	T001K	BUKRS		☐	BUKRS	☐	Company Code

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	20140121
SAP Release Created in