1. Home
  2. Resources
  3. SAP Tables
  4. MT06E - Material Master Fields: Purchasing

SAP Table MT06E

Material Master Fields: Purchasing

MT06E (Material Master Fields: Purchasing) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MT06E to other SAP tables.

MT06E table fields

Field Data element Checktable Datatype Length Decimals
MATKL Material Group MATKL CHAR 9 0
MEINS Base Unit of Measure MEINS UNIT 3 0
BSTME Purchase Order Unit of Measure BSTME UNIT 3 0
AUSME Unit of issue AUSME UNIT 3 0
MAKTX Material Description (Short Text) MAKTX CHAR 40 0
MMSTA Plant-Specific Material Status MMSTA CHAR 2 0
EKGRP Purchasing Group EKGRP CHAR 3 0
DISPO MRP Controller (Materials Planner) DISPO CHAR 3 0
WEBAZ Goods Receipt Processing Time in Days WEBAZ DEC 3 0
UNTTO Underdelivery Tolerance Limit UNTTO DEC 3 1
UEBTO Overdelivery Tolerance Limit UEBTO DEC 3 1
UEBTK Indicator: Unlimited Overdelivery Allowed UEBTK CHAR 1 0
X Yes
NULL No
MAHN1 Reminder level and reminder days (reminders/urging letters) MAHNT DEC 3 0
MAHN2 Reminder level and reminder days (reminders/urging letters) MAHNT DEC 3 0
MAHN3 Reminder level and reminder days (reminders/urging letters) MAHNT DEC 3 0
INSMK Stock Type INSMK CHAR 1 0
NULL Unrestricted use
X Quality inspection
S Blocked stock
BKLAS Valuation Class BKLAS CHAR 4 0
BWTTY Valuation Category BWTTY_D CHAR 1 0
VPRSV Price control indicator VPRSV CHAR 1 0
S Standard price
V Moving average price/periodic unit price
VERPR Moving Average Price/Periodic Unit Price VERPR CURR 11 2
STPRS Standard price STPRS CURR 11 2
PEINH Price Unit PEINH DEC 5 0
BSEXT External Purchase Orders Allowed BSEXT CHAR 1 0
0 No external purchase orders allowed
1 External purchase orders allowed, but warning issued
2 External purchase orders allowed
BSINT Internal purchase orders allowed BSINT CHAR 1 0
0 No internal purchase orders allowed
1 Internal purchase orders allowed, but warning issued
2 Internal purchase orders allowed
WERTU Value Update in Material Master Record WERTU CHAR 1 0
X Yes
NULL No
MENGU Quantity Updating in Material Master Record MENGU CHAR 1 0
X Yes
NULL No
PLIFZ Planned Delivery Time in Days PLIFZ DEC 3 0
DISST Low-Level Code DISST CHAR 3 0
DISMM MRP Type DISMM CHAR 2 0
USEQU Quota arrangement usage USEQU CHAR 1 0
MTART Material Type MTART T134 CHAR 4 0
BWSCL Source of Supply BWSCL CHAR 1 0
KZABS Order Acknowledgment Requirement KZABS CHAR 1 0
X Yes
NULL No
EVERS Shipping Instructions EVERS T027A CHAR 2 0
NTGEW Net Weight NTGEW QUAN 13 3
GEWEI Weight Unit GEWEI T006 UNIT 3 0
KORDB Indicator: Source list requirement KORDB CHAR 1 0
X Yes
NULL No
STAWN Commodity Code/Import Code Number for Foreign Trade STAWN CHAR 17 0
KAUTB Indicator: "automatic purchase order allowed" KAUTB CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
HERKL Country of origin of the material HERKL CHAR 3 0
HERKR Region of origin of material (non-preferential origin) HERKR CHAR 3 0
QMPUR QM in Procurement is Active QMPUR CHAR 1 0
X Yes
NULL No
SSQSS Control Key for Quality Management in Procurement QSSPUR CHAR 8 0
QZGTP Certificate Type QZGTYP CHAR 4 0
QMATV Inspection Setup Exists for Material/Plant QMATV CHAR 1 0
X Yes
NULL No
VABME Variable Purchase Order Unit Active VABME CHAR 1 0
NULL Not active
1 Active
2 Active with own price
EAN11 International Article Number (EAN/UPC) EAN11 CHAR 18 0
KZREV Revision Level Has Been Assigned to the Material KZREV CHAR 1 0
X Yes
NULL No
BRGEW Gross Weight BRGEW QUAN 13 3
VOLUM Volume VOLUM QUAN 13 3
VOLEH Volume unit VOLEH UNIT 3 0
QSSYS Required QM System for Vendor QSSYS_SOLL CHAR 4 0
KZKFG Configurable Material KZKFG CHAR 1 0
X Yes
NULL No
SATNR Cross-Plant Configurable Material SATNR CHAR 18 0
ATTYP Material Category ATTYP CHAR 2 0
NULL Single material (industry)
00 Single material
01 Generic material
02 Variant
10 Sales set
11 Prepack
12 Display
20 Material group material
21 Hierarchy material
22 Group material
30 Material group reference material
SOBES Special procurement type SOBES CHAR 1 0
0 Standard external procurement
2 Consignment
3 Subcontracting
7 Stock transfer
E Standard in-house production
P Production in plant 2
9 IS-OIL only: Stock transfer reservation
BESKZ Procurement Type BESKZ CHAR 1 0
E In-house production
F External procurement
NULL No procurement
X Both procurement types
WRK02 Supplying (Issuing) Plant in Stock Transport Order RESWK CHAR 4 0
PRDHA Product hierarchy PRODH_D CHAR 18 0
SAISO Season Category SAISO CHAR 4 0
SAISJ Season Year SAISJ CHAR 4 0
PLGTP Price Band Category PLGTP CHAR 2 0
ETIAR Label type ETIAR CHAR 2 0
ETIFO Label form ETIFO CHAR 2 0
BWVOR Procurement rule BWVOR CHAR 1 0
KZPIP Pipeline Handling Mandatory KZPIP CHAR 1 0
X Yes
NULL No
XPIZU Pipeline handling allowed XPIZU CHAR 1 0
X Yes
NULL No
MLMAA Material ledger activated at material level CK_ML_MAAC CHAR 1 0
X Yes
NULL No
MHDRZ Minimum Remaining Shelf Life MHDRZ DEC 4 0
MHDHB Total shelf life MHDHB DEC 4 0
SERVG IS-R service level W_SERVGRD CHAR 1 0
PRCTR Profit Center PRCTR CHAR 10 0
SBDKZ Dependent requirements ind. for individual and coll. reqmts SBDKZ CHAR 1 0
NULL Individual and collective requirements
1 Individual requirements only
2 Collective requirements only
ALTSL Method for Selecting Alternative Bills of Material ALTSL CHAR 1 0
NULL Selection by order quant.
1 Selection by explosion date
2 Selection by production version
3 Selection only by production version
CUOBJ Internal object number CUOBM NUMC 18 0
MLGUT Empties Bill of Material W_MITLEERG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
STDPD Configurable material STDPD CHAR 18 0
CUOBF Internal object number CUOBM NUMC 18 0
LGFSB Default storage location for external procurement LGFSB CHAR 4 0
MATBF Material in Respect of Which Stock is Managed MATBF CHAR 18 0
MMSTD Date from which the plant-specific material status is valid MMSTD DATS 8 0
MSTAE Cross-Plant Material Status MSTAE CHAR 2 0
MSTDE Date from which the cross-plant material status is valid MSTDE DATS 8 0
DATAB Valid-From Date DATAB DATS 8 0
LIQDT Deletion date LIQDT DATS 8 0
MRPPP PPC planning calendar MRPPP CHAR 3 0
NRFHG Material qualifies for discount in kind NRFHG CHAR 1 0
NULL Not eligible for discount in kind
1 Eligible for discount in kind for purchasing and sales
2 Eligible for discount in kind only for purchasing
3 Eligible for discount in kind only for sales
MFRGR Material freight group MFRGR CHAR 8 0
STEUC Control code for consumption taxes in foreign trade STEUC T604F CHAR 16 0
MTUSE Usage of the material J_1BMATUSE CHAR 1 0
0 Resale
1 Industrialisation
2 Consumption
3 Asset
MTORG Origin of the material J_1BMATORG CHAR 1 0
1 Foreign - imported directly
2 Foreign - acquired nationally
0 National - except indicated for codes 3, 4, 5 or 8
3 National - with import content over 40% and below/equal 70%
4 National - production with tax incentive
5 National - with import content less than or equal to 40%
6 Foreign - imp direct,no similar nat.,Res.CAMEX & nat.gas
7 Foreign - acquired nat.,no similar nat.,Res.CAMEX & nat.gas
8 National - with import content over 70%
OWNPR Produced in-house J_1BOWNPRO CHAR 1 0
X Yes
NULL No
INDUS Material CFOP category J_1BINDUS3 CHAR 2 0
00 material
01 electricity
02 communication
03 transportation
04 animal
MFRPN Manufacturer Part Number MFRPN CHAR 40 0
MFRNR Number of a Manufacturer MFRNR CHAR 10 0
BMATN Number of firm's own (internal) inventory-managed material MPMAT CHAR 18 0
MPROF Manufacturer Part Profile MPROF CHAR 4 0
KZWSM Units of measure usage KZWSO CHAR 1 0
NULL Alternative unit of measure
A Proportion unit
B Product unit
WMAKG Material type ID WMAK CHAR 1 0
NULL General material type
1 Material type for value-only materials
2 Material type for empties
3 Material type for catalog variants
4 Material type for perishables
5 Material type for additionals
6 Material type for coupons
FABKZ Indicator: Item Relevant to JIT Delivery Schedules FABKZ CHAR 1 0
NULL No JIT
1 Automatically
XCHAR Batch management indicator (internal) XCHAR CHAR 1 0
X Yes
NULL No
XCHPF Batch management requirement indicator XCHPF CHAR 1 0
X Yes
NULL No
IPRKZ Period Indicator for Shelf Life Expiration Date DATTP CHAR 1 0
TRAGR Transportation Group TRAGR CHAR 4 0
SERNP Serial Number Profile SERAIL CHAR 4 0
BFLME Generic Material with Logistical Variants BFLME CHAR 1 0
NULL Material is not a logistical variant
1 Generic material with logistical variants
2 Sales variant
3 Procurement variant
XBEWM Valuation based on the batch-specific unit of measure XBEWW CHAR 1 0
X Yes
NULL No
LADGR Loading Group LADGR CHAR 4 0
RDPRF Rounding Profile RDPRF CHAR 4 0
BSTRF Rounding value for purchase order quantity BSTRF QUAN 13 3
BSTMA Maximum Lot Size BSTMA QUAN 13 3
BSTMI Minimum Lot Size BSTMI QUAN 13 3
MEGRU Unit of Measure Group MEGRU CHAR 4 0
LFRHY Planning cycle LFRHY CHAR 3 0
PERKZ Period Indicator PERKZ CHAR 1 0
P Period according to fiscal year variant
M Monthly
W Weekly
T Daily
NULL Initial value
PERIV Fiscal Year Variant PERIV CHAR 2 0
PRENC Exemption certificate: Indicator for legal control PRENC CHAR 1 0
NULL Not Relevant
A Applied for
B Accepted
C Request Rejected
EKWSL Purchasing Value Key EKWSL CHAR 4 0
OITAXGRP Excise Duty Group OIH_TAXGRP OIH2 CHAR 2 0
OIOILCON Oil content in a material as a percentage OIH_OILCON DEC 5 2
0 Range of permissible values for Mineral Oil Content %
OIEDCODE Customs tariff number OIH_EDCODE CHAR 12 0
CMETH Quantity Conversion Method OIB_CMETH CHAR 1 0
NULL Standard Conversion
1 Quantity Conversion (Oil, Natural Gas,...) with Conv. Group
2 Std Conv. with Tax Group/Without UoM Group (only IS-OIL-TDP)
OITRIND Transfer sign for plant-to-plant transfers OIH_TRIND CHAR 1 0
NULL SAP standard procedure
1 SAP standard procedure with tracking records for statistics
2 IS-OIL plant to plant transfers with tracking records
CONS_PROCG Consignment Control WRF_CONS_PROCG WRFT_CONS_PROCG CHAR 1 0
GI_PR_TIME Goods Issue Processing Time in Days WRF_PSCD_WABAZ DEC 3 0
MULTIPLE_EKGRP Purchasing Across Purchasing Group WRF_POHF_OTHER_EKGRP_ALLOW CHAR 1 0
NULL Not Selected
X Selected
REF_SCHEMA Reference Determination Schema WRF_REF_SCHEMA WRF_REF_RFS CHAR 2 0
MIN_TROC Minimum Target Range of Coverage WRF_FRE_TROC_MIN NUMC 3 0
MAX_TROC Maximum Target Range of Coverage WRF_FRE_TROC_MAX NUMC 3 0
TARGET_STOCK Target Stock WRF_FRE_TARGET_STOCK QUAN 13 3

MT06E foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MT06E CONS_PROCG MT06E CONS_PROCG WRFT_CONS_PROCG Seasonal Procurement: Consignment Control WRF_CONS_PROCG
MT06E CONS_PROCG SYST MANDT WRFT_CONS_PROCG Seasonal Procurement: Consignment Control MANDT
MT06E EVERS SYST MANDT T027A Shipping Instructions, Purchasing MANDT
MT06E EVERS MT06E EVERS T027A Shipping Instructions, Purchasing EVERS
MT06E GEWEI SYST MANDT T006 Units of Measurement MANDT
MT06E GEWEI MT06E GEWEI T006 Units of Measurement MSEHI
MT06E MTART SYST MANDT T134 Material Types MANDT
MT06E MTART MT06E MTART T134 Material Types MTART
MT06E OITAXGRP MT06E OITAXGRP OIH2 Excise duty tax group (IS-Oil TDP standard/core object) TAXGRP
MT06E OITAXGRP SYST MANDT OIH2 Excise duty tax group (IS-Oil TDP standard/core object) MANDT
MT06E REF_SCHEMA SYST MANDT WRF_REF_RFS Reference Determination Schema MANDT
MT06E REF_SCHEMA MT06E REF_SCHEMA WRF_REF_RFS Reference Determination Schema REF_SCHEMA
MT06E STEUC SYST MANDT T604F Import Processing: Control Code MANDT
MT06E STEUC 'BR' T604F Import Processing: Control Code LAND1
MT06E STEUC MT06E STEUC T604F Import Processing: Control Code STEUC