SAP ABAP Table MT06E (Material Master Fields: Purchasing)

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

Table Category	INTTAB	Structure
Structure	MT06E	Table Relationship Diagram
Short Description	Material Master Fields: Purchasing

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	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
2	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
3	BSTME	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
4	AUSME	☐	AUSME	MEINS	UNIT	3	0	Unit of issue	*
5	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
6	MMSTA	☐	MMSTA	MMSTA	CHAR	2	0	Plant-Specific Material Status	*
7	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	*
8	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	*
9	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
10	UNTTO	☐	UNTTO	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
11	UEBTO	☐	UEBTO	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
12	UEBTK	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
13	MAHN1	☐	MAHNT	MAHNT	DEC	3	0	Reminder level and reminder days (reminders/urging letters)
14	MAHN2	☐	MAHNT	MAHNT	DEC	3	0	Reminder level and reminder days (reminders/urging letters)
15	MAHN3	☐	MAHNT	MAHNT	DEC	3	0	Reminder level and reminder days (reminders/urging letters)
16	INSMK	☐	INSMK	INSMK	CHAR	1	0	Stock Type
17	BKLAS	☐	BKLAS	BKLAS	CHAR	4	0	Valuation Class	*
18	BWTTY	☐	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	*
19	VPRSV	☐	VPRSV	VPRSV	CHAR	1	0	Price control indicator
20	VERPR	☐	VERPR	WERT11V	CURR	11	2	Moving Average Price/Periodic Unit Price
21	STPRS	☐	STPRS	WERT11V	CURR	11	2	Standard price
22	PEINH	☐	PEINH	PACK3	DEC	5	0	Price unit
23	BSEXT	☐	BSEXT	BSEXT	CHAR	1	0	External Purchase Orders Allowed
24	BSINT	☐	BSINT	BSINT	CHAR	1	0	Internal purchase orders allowed
25	WERTU	☐	WERTU	XFELD	CHAR	1	0	Value Updating in Material Master Record
26	MENGU	☐	MENGU	XFELD	CHAR	1	0	Quantity Updating in Material Master Record
27	PLIFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
28	DISST	☐	DISST	DISST	CHAR	3	0	Low-level code
29	DISMM	☐	DISMM	DISMM	CHAR	2	0	MRP Type	*
30	USEQU	☐	USEQU	USEQU	CHAR	1	0	Quota arrangement usage	*
31	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
32	BWSCL	☐	BWSCL	BQSCL	CHAR	1	0	Source of Supply	*
33	KZABS	☐	KZABS	XFELD	CHAR	1	0	Order Acknowledgment Requirement
34	EVERS	☐	EVERS	EVERS	CHAR	2	0	Shipping Instructions	T027A
35	NTGEW	☐	NTGEW	MENG13	QUAN	13	3	Net weight
36	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
37	KORDB	☐	KORDB	XFELD	CHAR	1	0	Indicator: Source list requirement
38	STAWN	☐	STAWN	STAWN	CHAR	17	0	Commodity Code/Import Code Number for Foreign Trade	*
39	KAUTB	☐	KAUTB	FLAG	CHAR	1	0	Indicator: "automatic purchase order allowed"
40	HERKL	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	*
41	HERKR	☐	HERKR	REGIO	CHAR	3	0	Region of origin of material (non-preferential origin)	*
42	QMPUR	☐	QMPUR	XFELD	CHAR	1	0	QM in procurement is active
43	SSQSS	☐	QSSPUR	QSSPUR	CHAR	8	0	Control Key for Quality Management in Procurement	*
44	QZGTP	☐	QZGTYP	QZGTYP	CHAR	4	0	Certificate Type	*
45	QMATV	☐	QMATV	XFELD	CHAR	1	0	Inspection Setup Exists for Material/Plant
46	VABME	☐	VABME	VABME	CHAR	1	0	Variable Purchase Order Unit Active
47	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
48	KZREV	☐	KZREV	XFELD	CHAR	1	0	Indicator: revision level has been assigned to the material
49	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
50	VOLUM	☐	VOLUM	MENG13	QUAN	13	3	Volume
51	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	*
52	QSSYS	☐	QSSYS_SOLL	QSSYS	CHAR	4	0	Required QM system for vendor	*
53	KZKFG	☐	KZKFG	XFELD	CHAR	1	0	Configurable Material
54	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	*
55	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
56	SOBES	☐	SOBES	SOBES	CHAR	1	0	Special procurement type
57	BESKZ	☐	BESKZ	BESKZ	CHAR	1	0	Procurement Type
58	WRK02	☐	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	*
59	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	*
60	SAISO	☐	SAISO	SAISO	CHAR	4	0	Season Category	*
61	SAISJ	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
62	PLGTP	☐	PLGTP	PLGTP	CHAR	2	0	Price band category	*
63	ETIAR	☐	ETIAR	ETIAR	CHAR	2	0	Label type	*
64	ETIFO	☐	ETIFO	ETIFO	CHAR	2	0	Label form	*
65	BWVOR	☐	BWVOR	BWVOR	CHAR	1	0	Procurement rule	*
66	KZPIP	☐	KZPIP	XFELD	CHAR	1	0	Pipeline Handling Mandatory
67	XPIZU	☐	XPIZU	XFELD	CHAR	1	0	Pipeline handling allowed
68	MLMAA	☐	CK_ML_MAAC	XFELD	CHAR	1	0	Material ledger activated at material level
69	MHDRZ	☐	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
70	MHDHB	☐	MHDHB	DEC4	DEC	4	0	Total shelf life
71	SERVG	☐	W_SERVGRD	W_SERVGRD	CHAR	1	0	IS-R service level	*
72	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
73	SBDKZ	☐	SBDKZ	SBDKZ	CHAR	1	0	Dependent requirements ind. for individual and coll. reqmts
74	ALTSL	☐	ALTSL	ALTSL	CHAR	1	0	Method for Selecting Alternative Bills of Material
75	CUOBJ	☐	CUOBM	CUOBJ	NUMC	18	0	Internal object number
76	MLGUT	☐	W_MITLEERG	FLAG	CHAR	1	0	Empties Bill of Material
77	STDPD	☐	STDPD	MATNR	CHAR	18	0	Configurable material	*
78	CUOBF	☐	CUOBM	CUOBJ	NUMC	18	0	Internal object number
79	LGFSB	☐	LGFSB	LGORT	CHAR	4	0	Default storage location for external procurement	*
80	MATBF	☐	MATBF	MATNR	CHAR	18	0	Material in Respect of Which Stock is Managed	*
81	MMSTD	☐	MMSTD	DATUM	DATS	8	0	Date from which the plant-specific material status is valid
82	MSTAE	☐	MSTAE	MMSTA	CHAR	2	0	Cross-Plant Material Status	*
83	MSTDE	☐	MSTDE	DATUM	DATS	8	0	Date from which the cross-plant material status is valid
84	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
85	LIQDT	☐	LIQDT	DATUM	DATS	8	0	Deletion date
86	MRPPP	☐	MRPPP	MRPPP	CHAR	3	0	PPC planning calendar	*
87	NRFHG	☐	NRFHG	NRFHG	CHAR	1	0	Material qualifies for discount in kind
88	MFRGR	☐	MFRGR	MFRGR	CHAR	8	0	Material freight group	*
89	STEUC	☐	STEUC	STEUC	CHAR	16	0	Control code for consumption taxes in foreign trade	T604F
90	MTUSE	☐	J_1BMATUSE	J_1BMATUSE	CHAR	1	0	Usage of the material
91	MTORG	☐	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
92	OWNPR	☐	J_1BOWNPRO	XFELD	CHAR	1	0	Produced in-house
93	INDUS	☐	J_1BINDUS3	J_1BINDUS3	CHAR	2	0	Material CFOP category
94	MFRPN	☐	MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
95	MFRNR	☐	MFRNR	LIFNR	CHAR	10	0	Manufacturer number	*
96	BMATN	☐	MPMAT	MATNR	CHAR	18	0	Number of firm's own (internal) inventory-managed material	*
97	MPROF	☐	MPROF	MPROF	CHAR	4	0	Mfr part profile	*
98	KZWSM	☐	KZWSO	KZWSO	CHAR	1	0	Units of measure usage
99	WMAKG	☐	WMAK	WMAK	CHAR	1	0	Material type ID
100	FABKZ	☐	FABKZ	FABKZ	CHAR	1	0	Indicator: Item Relevant to JIT Delivery Schedules
101	XCHAR	☐	XCHAR	XFELD	CHAR	1	0	Batch management indicator (internal)
102	XCHPF	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
103	IPRKZ	☐	DATTP	DATTP	CHAR	1	0	Period Indicator for Shelf Life Expiration Date
104	TRAGR	☐	TRAGR	TRAGR	CHAR	4	0	Transportation Group	*
105	SERNP	☐	SERAIL	SERAIL	CHAR	4	0	Serial Number Profile	*
106	BFLME	☐	BFLME	BFLME	CHAR	1	0	Generic Material with Logistical Variants
107	XBEWM	☐	XBEWW	XFELD	CHAR	1	0	Valuation based on the batch-specific unit of measure
108	LADGR	☐	LADGR	LADGR	CHAR	4	0	Loading Group	*
109	RDPRF	☐	RDPRF	RDPRF	CHAR	4	0	Rounding Profile	*
110	BSTRF	☐	BSTRF	MENG13	QUAN	13	3	Rounding value for purchase order quantity
111	BSTMA	☐	BSTMA	MENG13	QUAN	13	3	Maximum lot size
112	BSTMI	☐	BSTMI	MENG13	QUAN	13	3	Minimum lot size
113	MEGRU	☐	MEGRU	MEGRU	CHAR	4	0	Unit of Measure Group	*
114	LFRHY	☐	LFRHY	MRPPP	CHAR	3	0	Planning cycle	*
115	PERKZ	☐	PERKZ	PERKZ	CHAR	1	0	Period indicator
116	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
117	PRENC	☐	PRENC	PRENC	CHAR	1	0	Exemption certificate: Indicator for legal control
118	EKWSL	☐	EKWSL	EKWSL	CHAR	4	0	Purchasing Value Key	*
119	.INCLU--AP	☐				0	0	Extension MT06E with New MARC Fields - Seasonal Procurement
120	.INCLUDE	☐				0	0	Seasonal Procurmnt: Include for Consgnmnt Cntrl, Art. Master
121	CONS_PROCG	☐	WRF_CONS_PROCG	WRF_CONS_PROCG	CHAR	1	0	Consignment Control	WRFT_CONS_PROCG
122	.INCLUDE	☐				0	0	MARC Extension with New Fields - Seasonal Procurement
123	GI_PR_TIME	☐	WRF_PSCD_WABAZ	DEC3	DEC	3	0	Goods Issue Processing Time in Days
124	MULTIPLE_EKGRP	☐	WRF_POHF_OTHER_EKGRP_ALLOW	CHAR1_X	CHAR	1	0	Purchasing Across Purchasing Group
125	REF_SCHEMA	☐	WRF_REF_SCHEMA	WRF_REF_SCHEMA	CHAR	2	0	Reference Determination Schema	WRF_REF_RFS
126	MIN_TROC	☐	WRF_FRE_TROC_MIN	WRF_FRE_TROC	NUMC	3	0	Minimum Target Range of Coverage
127	MAX_TROC	☐	WRF_FRE_TROC_MAX	WRF_FRE_TROC	NUMC	3	0	Maximum Target Range of Coverage
128	TARGET_STOCK	☐	WRF_FRE_TARGET_STOCK	MENG13	QUAN	13	3	Target Stock

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MT06E	CONS_PROCG	WRFT_CONS_PROCG	WRF_CONS_PROCG		C	CN
2	MT06E	EVERS	T027A	EVERS
3	MT06E	GEWEI	T006	MSEHI
4	MT06E	MTART	T134	MTART
5	MT06E	REF_SCHEMA	WRF_REF_RFS	REF_SCHEMA
6	MT06E	STEUC	T604F	STEUC	KEY	1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in