SE11 ABAP Dictionary SE11 MVER

Popular:

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

MVER

Material Consumption

SAP SAP Transparent Table 58 Fields

Primary Key:

MANDT MATNR WERKS GJAHR PERKZ ZAHLR

#	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	WERKS	KEY	Plant	CHAR	4	-	T001W	Plant
4	GJAHR	KEY	Fiscal Yr	NUMC	4	-	-	Fiscal Year
5	PERKZ	KEY	Period Ind	CHAR	1	-	-	Period Indicator
6	ZAHLR	KEY	Number	NUMC	2	-	-	Number of follow-on records in Table MVER
7	GSV01	-	Tot. cons.	QUAN	13	3	-	Total consumption
8	GSV02	-	Tot. cons.	QUAN	13	3	-	Total consumption
9	GSV03	-	Tot. cons.	QUAN	13	3	-	Total consumption
10	GSV04	-	Tot. cons.	QUAN	13	3	-	Total consumption
11	GSV05	-	Tot. cons.	QUAN	13	3	-	Total consumption
12	GSV06	-	Tot. cons.	QUAN	13	3	-	Total consumption
13	GSV07	-	Tot. cons.	QUAN	13	3	-	Total consumption
14	GSV08	-	Tot. cons.	QUAN	13	3	-	Total consumption
15	GSV09	-	Tot. cons.	QUAN	13	3	-	Total consumption
16	GSV10	-	Tot. cons.	QUAN	13	3	-	Total consumption
17	GSV11	-	Tot. cons.	QUAN	13	3	-	Total consumption
18	GSV12	-	Tot. cons.	QUAN	13	3	-	Total consumption
19	GSV13	-	Tot. cons.	QUAN	13	3	-	Total consumption
20	UNV01	-	Unpl.cons.	QUAN	13	3	-	Unplanned consumption
21	UNV02	-	Unpl.cons.	QUAN	13	3	-	Unplanned consumption
22	UNV03	-	Unpl.cons.	QUAN	13	3	-	Unplanned consumption
23	UNV04	-	Unpl.cons.	QUAN	13	3	-	Unplanned consumption
24	UNV05	-	Unpl.cons.	QUAN	13	3	-	Unplanned consumption
25	UNV06	-	Unpl.cons.	QUAN	13	3	-	Unplanned consumption
26	UNV07	-	Unpl.cons.	QUAN	13	3	-	Unplanned consumption
27	UNV08	-	Unpl.cons.	QUAN	13	3	-	Unplanned consumption
28	UNV09	-	Unpl.cons.	QUAN	13	3	-	Unplanned consumption
29	UNV10	-	Unpl.cons.	QUAN	13	3	-	Unplanned consumption
30	UNV11	-	Unpl.cons.	QUAN	13	3	-	Unplanned consumption
31	UNV12	-	Unpl.cons.	QUAN	13	3	-	Unplanned consumption
32	UNV13	-	Unpl.cons.	QUAN	13	3	-	Unplanned consumption
33	MGV01	-	CorTotCons	QUAN	13	3	-	Manually corrected total consumption
34	MGV02	-	CorTotCons	QUAN	13	3	-	Manually corrected total consumption
35	MGV03	-	CorTotCons	QUAN	13	3	-	Manually corrected total consumption
36	MGV04	-	CorTotCons	QUAN	13	3	-	Manually corrected total consumption
37	MGV05	-	CorTotCons	QUAN	13	3	-	Manually corrected total consumption
38	MGV06	-	CorTotCons	QUAN	13	3	-	Manually corrected total consumption
39	MGV07	-	CorTotCons	QUAN	13	3	-	Manually corrected total consumption
40	MGV08	-	CorTotCons	QUAN	13	3	-	Manually corrected total consumption
41	MGV09	-	CorTotCons	QUAN	13	3	-	Manually corrected total consumption
42	MGV10	-	CorTotCons	QUAN	13	3	-	Manually corrected total consumption
43	MGV11	-	CorTotCons	QUAN	13	3	-	Manually corrected total consumption
44	MGV12	-	CorTotCons	QUAN	13	3	-	Manually corrected total consumption
45	MGV13	-	CorTotCons	QUAN	13	3	-	Manually corrected total consumption
46	MUV01	-	CorUnplCon	QUAN	13	3	-	Manually corrected unplanned consumption
47	MUV02	-	CorUnplCon	QUAN	13	3	-	Manually corrected unplanned consumption
48	MUV03	-	CorUnplCon	QUAN	13	3	-	Manually corrected unplanned consumption
49	MUV04	-	CorUnplCon	QUAN	13	3	-	Manually corrected unplanned consumption
50	MUV05	-	CorUnplCon	QUAN	13	3	-	Manually corrected unplanned consumption
51	MUV06	-	CorUnplCon	QUAN	13	3	-	Manually corrected unplanned consumption
52	MUV07	-	CorUnplCon	QUAN	13	3	-	Manually corrected unplanned consumption
53	MUV08	-	CorUnplCon	QUAN	13	3	-	Manually corrected unplanned consumption
54	MUV09	-	CorUnplCon	QUAN	13	3	-	Manually corrected unplanned consumption
55	MUV10	-	CorUnplCon	QUAN	13	3	-	Manually corrected unplanned consumption
56	MUV11	-	CorUnplCon	QUAN	13	3	-	Manually corrected unplanned consumption
57	MUV12	-	CorUnplCon	QUAN	13	3	-	Manually corrected unplanned consumption
58	MUV13	-	CorUnplCon	QUAN	13	3	-	Manually corrected unplanned consumption

Related References & SQL

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

Interactive ERD Diagrams

SAP MM - Goods Receipt Relation →

Standard T-Codes

SE11 SE16

Related Tables

MARA T001W MKPF MSEG EKBE S031 S011 S013

ANSI SQL Query

SELECT a.MATNR,
       a.WERKS,
       a.GJAHR,
       a.PERKZ,
       a.ZAHLR,
       a.GSV01,
       a.GSV02
FROM MVER AS a
WHERE a.MATNR = 'FG-100'
  AND a.WERKS = '0001';

ABAP OpenSQL (7.40+)

SELECT a~matnr,
       a~werks,
       a~gjahr,
       a~perkz,
       a~zahlr,
       a~gsv01,
       a~gsv02
  FROM mver AS a
  WHERE a~matnr = 'fg-100'
  and a~werks = '0001'
  INTO TABLE @DATA(lt_mver)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 MVER

MVER

Dictionary Fields Fields

Related References & SQL