SE11 ABAP Dictionary SE11 MBEW

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

MBEW

Material Valuation

SAP SAP Transparent Table 109 Fields

Primary Key:

MANDT MATNR BWKEY BWTAR

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	MATNR	KEY	Material	CHAR	18	-	MARA	Material Number
3	BWKEY	KEY	Val. Area	CHAR	4	-	-	Valuation Area
4	BWTAR	KEY	Val. Type	CHAR	10	-	-	Valuation Type
5	LVORM	-	Val. type	CHAR	1	-	-	Deletion flag for all material data of a valuation type
6	LBKUM	-	TotalStock	QUAN	13	3	-	Total Valuated Stock
7	SALK3	-	Total Val.	CURR	13	2	-	Value of Total Valuated Stock
8	VPRSV	-	Price ctrl	CHAR	1	-	-	Price control indicator
9	VERPR	-	MvAvgPrice	CURR	11	2	-	Moving Average Price/Periodic Unit Price
10	STPRS	-	Std price	CURR	11	2	-	Standard price
11	PEINH	-	/	DEC	5	-	-	Price Unit
12	BKLAS	-	Val. Class	CHAR	4	-	-	Valuation Class
13	SALKV	-	Value	CURR	13	2	-	Value based on moving average price (only with price ctrl S)
14	VMKUM	-	TotalStock	QUAN	13	3	-	Total valuated stock in previous period
15	VMSAL	-	Total val.	CURR	13	2	-	Value of total valuated stock in previous period
16	VMVPR	-	Price ctrl	CHAR	1	-	-	Price Control Indicator in Previous Period
17	VMVER	-	MvAvgPrice	CURR	11	2	-	Moving Average Price/Periodic Unit Price in Previous Period
18	VMSTP	-	Std price	CURR	11	2	-	Standard price in the previous period
19	VMPEI	-	Per	DEC	5	-	-	Price unit of previous period
20	VMBKL	-	VClass PP	CHAR	4	-	-	Valuation Class in Previous Period
21	VMSAV	-	ValPrevPer	CURR	13	2	-	Value based on moving average price (previous period)
22	VJKUM	-	TotalStock	QUAN	13	3	-	Total Valuated Stock in Previous Year
23	VJSAL	-	Total val.	CURR	13	2	-	Value of total valuated stock in previous year
24	VJVPR	-	Price ctrl	CHAR	1	-	-	Price Control Indicator in Previous Year
25	VJVER	-	MvAvgPrice	CURR	11	2	-	Moving Average Price/Periodic Unit Price in Previous Year
26	VJSTP	-	Std price	CURR	11	2	-	Standard price in previous year
27	VJPEI	-	Per	DEC	5	-	-	Price unit of previous year
28	VJBKL	-	VClass PY	CHAR	4	-	-	Valuation Class in Previous Year
29	VJSAV	-	Val.pr.yr	CURR	13	2	-	Value based on moving average price (previous year)
30	LFGJA	-	Year	NUMC	4	-	-	Fiscal Year of Current Period
31	LFMON	-	Period	NUMC	2	-	-	Current period (posting period)
32	BWTTY	-	Val. Cat.	CHAR	1	-	-	Valuation Category
33	STPRV	-	Prev.price	CURR	11	2	-	Previous price
34	LAEPR	-	Last chng.	DATS	8	-	-	Date of the last price change
35	ZKPRS	-	Fut. price	CURR	11	2	-	Future price
36	ZKDAT	-	Valid From	DATS	8	-	-	Date as of which the price is valid
37	TIMESTAMP	-	Time Stamp	DEC	15	-	-	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
38	BWPRS	-	Tax prc.1	CURR	11	2	-	Valuation price based on tax law: level 1
39	BWPRH	-	Comm.pr.1	CURR	11	2	-	Valuation price based on commercial law: level 1
40	VJBWS	-	Tax pr. 3	CURR	11	2	-	Valuation price based on tax law: level 3
41	VJBWH	-	Coml pr. 3	CURR	11	2	-	Valuation price based on commercial law: level 3
42	VVJSL	-	Value	CURR	13	2	-	Value of total valuated stock in year before last
43	VVJLB	-	TotalStock	QUAN	13	3	-	Total valuated stock in year before last
44	VVMLB	-	TotalStock	QUAN	13	3	-	Total valuated stock in period before last
45	VVSAL	-	Value	CURR	13	2	-	Value of total valuated stock in period before last
46	ZPLPR	-	Plnd price	CURR	11	2	-	Future planned price
47	ZPLP1	-	PlndPrice1	CURR	11	2	-	Future Planned Price 1
48	ZPLP2	-	PlndPrice2	CURR	11	2	-	Future Planned Price 2
49	ZPLP3	-	PlndPrice3	CURR	11	2	-	Future Planned Price 3
50	ZPLD1	-	PP date 1	DATS	8	-	-	Date from Which Future Planned Price 1 Is Valid
51	ZPLD2	-	PP date 2	DATS	8	-	-	Date from Which Future Planned Price 2 Is Valid
52	ZPLD3	-	PP date 3	DATS	8	-	-	Date from Which Future Planned Price 3 Is Valid
53	PPERZ	-	Fut. c/e	ACCP	6	-	-	Period for future standard cost estimate (deactivated)
54	PPERL	-	Curr. c/e	ACCP	6	-	-	Period for current standard cost estimate (deactivated)
55	PPERV	-	Prev. c/e	ACCP	6	-	-	Period for previous standard cost estimate (deactivated)
56	KALKZ	-	Future c/e	CHAR	1	-	-	Indicator: standard cost estimate for future period
57	KALKL	-	CurCostEst	CHAR	1	-	-	Standard Cost Estimate for Current Period
58	KALKV	-	Prev. c/e	CHAR	1	-	-	Indicator: standard cost estimate for previous period
59	KALSC	-	Overhead	CHAR	6	-	-	Overhead key (deactivated)
60	XLIFO	-	LIFO/FIFO	CHAR	1	-	-	LIFO/FIFO-Relevant
61	MYPOL	-	Pool	CHAR	4	-	-	Pool number for LIFO valuation
62	BWPH1	-	Comm.pr.2	CURR	11	2	-	Valuation price based on commercial law: level 2
63	BWPS1	-	Tax pr. 2	CURR	11	2	-	Valuation price based on tax law: level 2
64	ABWKZ	-	Deval.ind.	NUMC	2	-	-	Lowest value: devaluation indicator
65	PSTAT	-	Status	CHAR	15	-	-	Maintenance status
66	KALN1	-	ProdCstgNo	NUMC	12	-	-	Cost Estimate Number - Product Costing
67	KALNR	-	CENo	NUMC	12	-	-	Cost Estimate Number for Cost Est. w/o Qty Structure
68	BWVA1	-	Val. Var.	CHAR	3	-	-	Valuation Variant for Future Standard Cost Estimate
69	BWVA2	-	Val. Var.	CHAR	3	-	-	Valuation Variant for Current Standard Cost Estimate
70	BWVA3	-	Val. Var.	CHAR	3	-	-	Valuation Variant for Previous Standard Cost Estimate
71	VERS1	-	Version	NUMC	2	-	-	Costing Version of Future Standard Cost Estimate
72	VERS2	-	Version	NUMC	2	-	-	Costing Version of Current Standard Cost Estimate
73	VERS3	-	Version	NUMC	2	-	-	Costing Version of Previous Standard Cost Estimate
74	HRKFT	-	Orig.group	CHAR	4	-	-	Origin Group as Subdivision of Cost Element
75	KOSGR	-	Ovrhd Grp	CHAR	10	-	-	Costing Overhead Group
76	PPRDZ	-	PostingPer	NUMC	3	-	-	Period of Future Standard Cost Estimate
77	PPRDL	-	Curr. Per.	NUMC	3	-	-	Period of Current Standard Cost Estimate
78	PPRDV	-	Prev. Per.	NUMC	3	-	-	Period of Previous Standard Cost Estimate
79	PDATZ	-	Fut. FYear	NUMC	4	-	-	Fiscal Year of Future Standard Cost Estimate
80	PDATL	-	Crnt FYear	NUMC	4	-	-	Fiscal Year of Current Standard Cost Estimate
81	PDATV	-	Prev.FYear	NUMC	4	-	-	Fiscal Year of Previous Standard Cost Estimate
82	EKALR	-	With QS	CHAR	1	-	-	Material Is Costed with Quantity Structure
83	VPLPR	-	Prev. plnd	CURR	11	2	-	Previous planned price
84	MLMAA	-	ML act.	CHAR	1	-	-	Material ledger activated at material level
85	MLAST	-	Price Det.	CHAR	1	-	-	Material Price Determination: Control
86	LPLPR	-	CrtPlanPrc	CURR	11	2	-	Current Planned Price
87	VKSAL	-	Tot.SP val	CURR	13	2	-	Value of Total Valuated Stock at Sales Price
88	HKMAT	-	Mat.origin	CHAR	1	-	-	Material-related origin
89	SPERW	-	Inv.Block	CHAR	1	-	-	Physical Inventory Blocking Indicator
90	KZIWL	-	PI VO mat.	CHAR	3	-	-	Phys. inventory indicator for value-only material
91	WLINL	-	PhyInvDate	DATS	8	-	-	Date of Last Posted Count for Unrestricted-Use Stock
92	ABCIW	-	CC ph.inv.	CHAR	1	-	-	Physical inventory indicator for cycle counting
93	BWSPA	-	Val.margin	DEC	6	2	-	Valuation margin
94	LPLPX	-	Fx CurPlPr	CURR	11	2	-	Fixed Portion of Current Planned Price
95	VPLPX	-	PrPlanPrFx	CURR	11	2	-	Fixed Portion of Previous Planned Price
96	FPLPX	-	FutPlPrcFx	CURR	11	2	-	Fixed Portion of Future Planned Price
97	LBWST	-	Curr.Val.	CHAR	1	-	-	Val. Strat. for Current Plan Price, Sales Order/Proj. Stock
98	VBWST	-	Prev. Val.	CHAR	1	-	-	Valuation Strategy for Previous Plan Price, Special Stock
99	FBWST	-	FutureValn	CHAR	1	-	-	Valuation Strategy for Future Planned Price, Special Stock
100	EKLAS	-	Val. class	CHAR	4	-	-	Valuation Class for Sales Order Stock
101	QKLAS	-	Val. class	CHAR	4	-	-	Valuation Class for Project Stock
102	MTUSE	-	Usage	CHAR	1	-	-	Usage of the material
103	MTORG	-	Origin	CHAR	1	-	-	Origin of the material
104	OWNPR	-	Produced	CHAR	1	-	-	Produced in-house
105	XBEWM	-	Val. Un.	CHAR	1	-	-	Valuation based on the batch-specific unit of measure
106	BWPEI	-	Price unit	DEC	5	-	-	Price unit for valuation prices based on tax/commercial law
107	MBRUE	-	MBEWH rec. already exists for per. before last of MBEW per.	CHAR	1	-	-	MBEWH rec. already exists for per. before last of MBEW per.
108	OKLAS	-	Val. class	CHAR	4	-	-	Valuation Class for Special Stock at the Vendor
109	OIPPINV	-	Pre Pd Inv	CHAR	1	-	-	Prepaid Inventory Flag for Material Valuation Type Segment

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk MBEW.

Interactive ERD Diagrams

SAP MM - Master Data Relation →

Standard T-Codes

MM03 MR21 MB5L

Related Tables

MARA MAKT MARM MARC MLAN

ANSI SQL Query

SELECT a.MATNR,
       a.BWKEY,
       a.BWTAR,
       a.LVORM,
       a.LBKUM,
       a.SALK3,
       a.VPRSV
FROM MBEW AS a
WHERE a.MATNR = 'FG-100'
  AND a.BWKEY = '0001';

ABAP OpenSQL (7.40+)

SELECT a~matnr,
       a~bwkey,
       a~bwtar,
       a~lvorm,
       a~lbkum,
       a~salk3,
       a~vprsv
  FROM mbew AS a
  WHERE a~matnr = 'fg-100'
  and a~bwkey = '0001'
  INTO TABLE @DATA(lt_mbew)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 MBEW

MBEW

Dictionary Fields Fields

Related References & SQL