SAP ABAP Table TXI_MBEW (Material Valuation)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA-GTF-DRT (Application Component) Data Retention Tool
     ⤷ FA_ILM (Package) Information Lifecycle Management

Basic Data

Table Category	INTTAB	Structure
Structure	TXI_MBEW	Table Relationship Diagram
Short Description	Material Valuation

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Material Valuation
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
4	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	T001K
5	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
6	.INCLUDE	☐				0	0	Data Division MBEW
7	LVORM	☐	LVOBA	XFELD	CHAR	1	0	Deletion flag for all material data of a valuation type
8	.INCLUDE	☐				0	0	Joint Data Part MBEW/EBEW/QBEW: Part 1
9	LBKUM	☐	LBKUM	MENG13V	QUAN	13	3	Total Valuated Stock
10	SALK3	☐	SALK3	WERT13N	CURR	13	2	Value of Total Valuated Stock
11	VPRSV	☐	VPRSV	VPRSV	CHAR	1	0	Price control indicator
12	VERPR	☐	VERPR	WERT11V	CURR	11	2	Moving Average Price/Periodic Unit Price
13	STPRS	☐	STPRS	WERT11V	CURR	11	2	Standard price
14	PEINH	☐	PEINH	PACK3	DEC	5	0	Price unit
15	BKLAS	☐	BKLAS	BKLAS	CHAR	4	0	Valuation Class	T025
16	SALKV	☐	SALKV	WERT13N	CURR	13	2	Value based on moving average price (only with price ctrl S)
17	VMKUM	☐	VMKUM	MENG13V	QUAN	13	3	Total valuated stock in previous period
18	VMSAL	☐	VMSAL	WERT13N	CURR	13	2	Value of total valuated stock in previous period
19	VMVPR	☐	VMVPR	VPRSV	CHAR	1	0	Price control indicator for previous period
20	VMVER	☐	VMVER	WERT11V	CURR	11	2	Moving Average Price/Periodic Unit Price in Previous Period
21	VMSTP	☐	VMSTP	WERT11V	CURR	11	2	Standard price in the previous period
22	VMPEI	☐	VMPEI	PACK3	DEC	5	0	Price unit of previous period
23	VMBKL	☐	VMBKL	BKLAS	CHAR	4	0	Valuation class of previous period	T025
24	VMSAV	☐	VMSAV	WERT13N	CURR	13	2	Value based on moving average price (previous period)
25	VJKUM	☐	VJKUM	MENG13V	QUAN	13	3	Total valuated stock in previous year
26	VJSAL	☐	VJSAL	WERT13N	CURR	13	2	Value of total valuated stock in previous year
27	VJVPR	☐	VJVPR	VPRSV	CHAR	1	0	Price control indicator for previous year
28	VJVER	☐	VJVER	WERT11V	CURR	11	2	Moving Average Price/Periodic Unit Price in Previous Year
29	VJSTP	☐	VJSTP	WERT11V	CURR	11	2	Standard price in previous year
30	VJPEI	☐	VJPEI	PACK3	DEC	5	0	Price unit of previous year
31	VJBKL	☐	VJBKL	BKLAS	CHAR	4	0	Valuation class from previous year	T025
32	VJSAV	☐	VJSAV	WERT13N	CURR	13	2	Value based on moving average price (previous year)
33	LFGJA	☐	LFGJA	GJAHR	NUMC	4	0	Fiscal Year of Current Period
34	LFMON	☐	LFMON	MONAT	NUMC	2	0	Current period (posting period)
35	BWTTY	☐	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	T149
36	STPRV	☐	STPRV	WERT11V	CURR	11	2	Previous price
37	LAEPR	☐	LAEPR	DATUM	DATS	8	0	Date of the last price change
38	ZKPRS	☐	DZKPRS	WERT11	CURR	11	2	Future price
39	ZKDAT	☐	DZKDAT	DATUM	DATS	8	0	Date as of which the price is valid
40	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
41	BWPRS	☐	BWPRS	WERT11	CURR	11	2	Valuation price based on tax law: level 1
42	BWPRH	☐	BWPRH	WERT11	CURR	11	2	Valuation price based on commercial law: level 1
43	VJBWS	☐	VJBWS	WERT11	CURR	11	2	Valuation price based on tax law: level 3
44	VJBWH	☐	VJBWH	WERT11	CURR	11	2	Valuation price based on commercial law: level 3
45	VVJSL	☐	VVJSL	WERT13N	CURR	13	2	Value of total valuated stock in year before last
46	VVJLB	☐	VVJLB	MENG13V	QUAN	13	3	Total valuated stock in year before last
47	VVMLB	☐	VVMLB	MENG13V	QUAN	13	3	Total valuated stock in period before last
48	VVSAL	☐	VVSAL	WERT13N	CURR	13	2	Value of total valuated stock in period before last
49	.INCLUDE	☐				0	0	Joint Data Part MBEW/EBEW/QBEW: Part 2
50	ZPLPR	☐	DZPLPR	WERT11	CURR	11	2	Future planned price
51	ZPLP1	☐	DZPLP1	WERT11	CURR	11	2	Future Planned Price 1
52	ZPLP2	☐	DZPLP2	WERT11	CURR	11	2	Future Planned Price 2
53	ZPLP3	☐	DZPLP3	WERT11	CURR	11	2	Future Planned Price 3
54	ZPLD1	☐	DZPLD1	DATUM	DATS	8	0	Date from Which Future Planned Price 1 Is Valid
55	ZPLD2	☐	DZPLD2	DATUM	DATS	8	0	Date from Which Future Planned Price 2 Is Valid
56	ZPLD3	☐	DZPLD3	DATUM	DATS	8	0	Date from Which Future Planned Price 3 Is Valid
57	PPERZ	☐	PPERZ	BUPER	ACCP	6	0	Period for future standard cost estimate (deactivated)
58	PPERL	☐	PPERL	BUPER	ACCP	6	0	Period for current standard cost estimate (deactivated)
59	PPERV	☐	PPERV	BUPER	ACCP	6	0	Period for previous standard cost estimate (deactivated)
60	.INCLUDE	☐				0	0	Joint Data Part MBEW/EBEW/QBEW: Part 3
61	KALKZ	☐	KAXKZ	XFELD	CHAR	1	0	Indicator: standard cost estimate for future period
62	KALKL	☐	KALKL	XFELD	CHAR	1	0	Indicator: standard cost estimate for current period
63	KALKV	☐	KALKV	XFELD	CHAR	1	0	Indicator: standard cost estimate for previous period
64	KALSC	☐	KALSC	KALSC	CHAR	6	0	Overhead key (deactivated)
65	XLIFO	☐	XLIFO	LIFO_FIFO	CHAR	1	0	LIFO/FIFO-relevant
66	MYPOL	☐	MYPOOL	LIFO_POOL	CHAR	4	0	Pool number for LIFO valuation	TPOOL
67	BWPH1	☐	BWPH1	WERT11	CURR	11	2	Valuation price based on commercial law: level 2
68	BWPS1	☐	BWPS1	WERT11	CURR	11	2	Valuation price based on tax law: level 2
69	ABWKZ	☐	ABWKZ	NUMC2	NUMC	2	0	Lowest value: devaluation indicator
70	PSTAT	☐	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
71	.INCLUDE	☐				0	0	Joint Data Part MBEW/EBEW/QBEW: Part 4
72	KALN1	☐	CK_KALNR1	CK_KALNR	NUMC	12	0	Cost Estimate Number - Product Costing	*
73	KALNR	☐	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure	*
74	.INCLUDE	☐				0	0	Joint Data Part MBEW/EBEW/QBEW: Part 5
75	BWVA1	☐	CK_BWVA1	CK_BWVAR	CHAR	3	0	Valuation variant for the future standard cost estimate	TCK05
76	BWVA2	☐	CK_BWVA2	CK_BWVAR	CHAR	3	0	Valuation variant for the current standard cost estimate	TCK05
77	BWVA3	☐	CK_BWVA3	CK_BWVAR	CHAR	3	0	Valuation variant for past standard cost estimate	TCK05
78	VERS1	☐	CK_TVERS1	CK_VERSION	NUMC	2	0	Costing version of the future standard cost estimate
79	VERS2	☐	CK_TVERS2	CK_VERSION	NUMC	2	0	Costing version of the current standard cost estimate
80	VERS3	☐	CK_TVERS3	CK_VERSION	NUMC	2	0	Costing version of the previous standard cost estimate
81	HRKFT	☐	HRKFT	HRKFT	CHAR	4	0	Origin Group as Subdivision of Cost Element	TKKH1
82	KOSGR	☐	CK_KOSGR	CK_KOSGR	CHAR	10	0	Costing overhead group	TCK14
83	PPRDZ	☐	CK_PPRDZ	POPER	NUMC	3	0	Period of future cost estimate
84	PPRDL	☐	CK_PPRDL	POPER	NUMC	3	0	Period of the current cost estimate
85	PPRDV	☐	CK_PPRDV	POPER	NUMC	3	0	Period of the previous cost estimate
86	PDATZ	☐	CK_PDATZ	GJAHR	NUMC	4	0	Future fiscal year
87	PDATL	☐	CK_PDATL	GJAHR	NUMC	4	0	Fiscal year for current cost estimate
88	PDATV	☐	CK_PDATV	GJAHR	NUMC	4	0	Fiscal year of previous cost estimate
89	EKALR	☐	CK_EKALREL	XFELD	CHAR	1	0	Material Is Costed with Quantity Structure
90	VPLPR	☐	VPLPR	WERT11	CURR	11	2	Previous planned price
91	MLMAA	☐	CK_ML_MAAC	XFELD	CHAR	1	0	Material ledger activated at material level
92	MLAST	☐	CK_ML_ABST	CK_ML_ABST	CHAR	1	0	Material Price Determination: Control
93	LPLPR	☐	CK_LPLPR	WERT11	CURR	11	2	Current Planned Price
94	VKSAL	☐	VKSAL	WERT13N	CURR	13	2	Value of Total Valuated Stock at Sales Price
95	HKMAT	☐	HKMAT	HKMAT	CHAR	1	0	Material-related origin
96	SPERW	☐	SPERR	SPERR	CHAR	1	0	Physical inventory blocking indicator
97	KZIWL	☐	KZIWL	INVKZ	CHAR	3	0	Phys. inventory indicator for value-only material
98	WLINL	☐	DLINL	DATS	DATS	8	0	Date of last physical inventory for unrestricted-use stock
99	ABCIW	☐	ABCIN	ABCIN	CHAR	1	0	Physical inventory indicator for cycle counting	*
100	.INCLUDE	☐				0	0	Joint Data Part MBEW/EBEW/QBEW: Part 6
101	BWSPA	☐	BWSPA	PRZ32V	DEC	6	2	Valuation margin
102	LPLPX	☐	CK_LPLPX	WERT11V	CURR	11	2	Fixed Portion of Current Planned Price
103	VPLPX	☐	CK_VPLPX	WERT11V	CURR	11	2	Fixed Portion of Previous Planned Price
104	FPLPX	☐	CK_ZPLPX	WERT11V	CURR	11	2	Fixed Portion of Future Planned Price
105	LBWST	☐	CK_LBWST	CK_BWST	CHAR	1	0	Val. strat. for current plan price, sales order/proj. stock
106	VBWST	☐	CK_VBWST	CK_BWST	CHAR	1	0	Valn. strategy for prev. planned price, restricted use stock
107	FBWST	☐	CK_ZBWST	CK_BWST	CHAR	1	0	Valn strategy for future planned price, restr. use stock
108	EKLAS	☐	EKLAS	BKLAS	CHAR	4	0	Valuation Class for Sales Order Stock	T025
109	QKLAS	☐	QKLAS	BKLAS	CHAR	4	0	Valuation Class for Project Stock	T025
110	MTUSE	☐	J_1BMATUSE	J_1BMATUSE	CHAR	1	0	Usage of the material
111	MTORG	☐	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
112	OWNPR	☐	J_1BOWNPRO	XFELD	CHAR	1	0	Produced in-house
113	XBEWM	☐	XBEWW	XFELD	CHAR	1	0	Valuation based on the batch-specific unit of measure
114	BWPEI	☐	BWPEI	PACK3	DEC	5	0	Price unit for valuation prices based on tax/commercial law
115	.INCLUDE	☐				0	0	Joint Data Part MBEW/EBEW/QBEW: Part 7
116	MBRUE	☐	MBRUE	XFELD	CHAR	1	0	MBEWH rec. already exists for per. before last of MBEW per.
117	OKLAS	☐	OKLAS	BKLAS	CHAR	4	0	Valuation Class for Special Stock at the Vendor	T025
118	.INCLU--AP	☐				0	0	Joint Venture Extension to MBEW
119	OIPPINV	☐	JV_PPINV	JV_PPINV	CHAR	1	0	Prepaid Inventory Flag for Material Valuation Type Segment
120	LBKUM_QY	☐	UNIT	EINHEIT	UNIT	3	0	Unit
121	SALK3_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
122	VERPR_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
123	STPRS_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
124	SALKV_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
125	VMKUM_QY	☐	UNIT	EINHEIT	UNIT	3	0	Unit
126	VMSAL_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
127	VMVER_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
128	VMSTP_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
129	VMSAV_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
130	VJKUM_QY	☐	UNIT	EINHEIT	UNIT	3	0	Unit
131	VJSAL_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
132	VJVER_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
133	VJSTP_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
134	VJSAV_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
135	STPRV_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
136	ZKPRS_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
137	BWPRS_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
138	BWPRH_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
139	VJBWS_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
140	VJBWH_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
141	VVJSL_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
142	VVJLB_QY	☐	UNIT	EINHEIT	UNIT	3	0	Unit
143	VVMLB_QY	☐	UNIT	EINHEIT	UNIT	3	0	Unit
144	VVSAL_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
145	ZPLPR_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
146	ZPLP1_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
147	ZPLP2_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
148	ZPLP3_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
149	BWPH1_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
150	BWPS1_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
151	VPLPR_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
152	LPLPR_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
153	VKSAL_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
154	LPLPX_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
155	VPLPX_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
156	FPLPX_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TXI_MBEW	BKLAS	T025	BKLAS	REF	C	CN
2	TXI_MBEW	BWKEY	T001K	BWKEY	KEY	1	CN
3	TXI_MBEW	BWTTY	T149	BWTTY	REF	C	CN
4	TXI_MBEW	BWVA1	TCK05	BWVAR	REF	C	CN
5	TXI_MBEW	BWVA2	TCK05	BWVAR	REF	C	CN
6	TXI_MBEW	BWVA3	TCK05	BWVAR	REF	C	CN
7	TXI_MBEW	EKLAS	T025	BKLAS
8	TXI_MBEW	HRKFT	TKKH1	HRKFT	REF	C	CN
9	TXI_MBEW	KOSGR	TCK14	KOSGR	REF	C	CN
10	TXI_MBEW	MANDT	T000	MANDT	KEY	1	CN
11	TXI_MBEW	MATNR	MARA	MATNR	KEY	1	CN
12	TXI_MBEW	MYPOL	TPOOL	MYPOOL	REF	C	CN
13	TXI_MBEW	OKLAS	T025	BKLAS
14	TXI_MBEW	QKLAS	T025	BKLAS
15	TXI_MBEW	VJBKL	T025	BKLAS	REF	C	CN
16	TXI_MBEW	VMBKL	T025	BKLAS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in