SAP table MT06E (Material Master Fields: Purchasing)

Field Description Data Type Length Decimals Checktable Data Element
MATKL Material Group CHAR 9 0 MATKL
MEINS Base Unit of Measure UNIT 3 0 MEINS
BSTME Purchase Order Unit of Measure UNIT 3 0 BSTME
AUSME Unit of issue UNIT 3 0 AUSME
MAKTX Material Description CHAR 40 0 MAKTX
MMSTA Plant-Specific Material Status CHAR 2 0 MMSTA
EKGRP Purchasing Group CHAR 3 0 EKGRP
DISPO MRP Controller CHAR 3 0 DISPO
WEBAZ Goods receipt processing time in days DEC 3 0 WEBAZ
UNTTO Underdelivery Tolerance DEC 3 1 UNTTO
UEBTO Overdelivery Tolerance DEC 3 1 UEBTO
UEBTK Unlimited Overdelivery Allowed CHAR 1 0 UEBTK
MAHN1 Reminder level and reminder days (reminders/urging letters) DEC 3 0 MAHNT
MAHN2 Reminder level and reminder days (reminders/urging letters) DEC 3 0 MAHNT
MAHN3 Reminder level and reminder days (reminders/urging letters) DEC 3 0 MAHNT
INSMK Stock Type CHAR 1 0 INSMK
Unrestricted use
S Blocked stock
X Quality inspection
BKLAS Valuation Class CHAR 4 0 BKLAS
BWTTY Valuation Category CHAR 1 0 BWTTY_D
VPRSV Price control indicator CHAR 1 0 VPRSV
S Standard price
V Moving average price/periodic unit price
VERPR Moving Average Price/Periodic Unit Price CURR 11 2 VERPR
STPRS Standard price CURR 11 2 STPRS
PEINH Price unit DEC 5 0 PEINH
BSEXT External Purchase Orders Allowed CHAR 1 0 BSEXT
0 No external purchase orders allowed
1 External purchase orders allowed, but warning issued
2 External purchase orders allowed
BSINT Internal purchase orders allowed CHAR 1 0 BSINT
0 No internal purchase orders allowed
1 Internal purchase orders allowed, but warning issued
2 Internal purchase orders allowed
WERTU Value Updating in Material Master Record CHAR 1 0 WERTU
MENGU Quantity Updating in Material Master Record CHAR 1 0 MENGU
PLIFZ Planned Delivery Time in Days DEC 3 0 PLIFZ
DISST Low-Level Code CHAR 3 0 DISST
DISMM MRP Type CHAR 2 0 DISMM
USEQU Quota arrangement usage CHAR 1 0 USEQU
MTART Material type CHAR 4 0 T134 MTART
BWSCL Source of Supply CHAR 1 0 BWSCL
KZABS Order Acknowledgment Requirement CHAR 1 0 KZABS
EVERS Shipping Instructions CHAR 2 0 T027A EVERS
NTGEW Net weight QUAN 13 3 NTGEW
GEWEI Weight Unit UNIT 3 0 T006 GEWEI
KORDB Indicator: Source list requirement CHAR 1 0 KORDB
STAWN Commodity Code CHAR 17 0 STAWN
KAUTB Indicator: "automatic purchase order allowed" CHAR 1 0 KAUTB
HERKL Country/Region of Origin of Material (Non-Preferential Ori.) CHAR 3 0 HERKL
HERKR Region of Origin of Material (Non-Preferential Origin) CHAR 3 0 HERKR
QMPUR QM in Procurement Is Active CHAR 1 0 QMPUR
SSQSS Control Key for Quality Management in Procurement CHAR 8 0 QSSPUR
QZGTP Certificate Type CHAR 4 0 QZGTYP
QMATV Inspection Setup Exists for Material/Plant CHAR 1 0 QMATV
VABME Variable Purchase Order Unit Active CHAR 1 0 VABME
Not active
1 Active
2 Active with own price
EAN11 International Article Number (EAN/UPC) CHAR 18 0 EAN11
KZREV Revision Level Has Been Assigned to the Material CHAR 1 0 KZREV
BRGEW Gross weight QUAN 13 3 BRGEW
VOLUM Volume QUAN 13 3 VOLUM
VOLEH Volume unit UNIT 3 0 VOLEH
QSSYS Required QM System for Supplier CHAR 4 0 QSSYS_SOLL
KZKFG Configurable Material CHAR 1 0 KZKFG
SATNR Cross-Plant Configurable Material CHAR 40 0 SATNR
ATTYP Material Category CHAR 2 0 ATTYP
Product
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 CHAR 1 0 SOBES
0 Standard external procurement
2 Consignment
3 Subcontracting
7 Stock transfer
9 IS-OIL only: Stock transfer reservation
E Standard in-house production
P Production in plant 2
BESKZ Procurement Type CHAR 1 0 BESKZ
No Procurement
E In-House Production
F External Procurement
X Both Procurement Types
WRK02 Supplying (issuing) plant in case of stock transport order CHAR 4 0 RESWK
PRDHA Product hierarchy CHAR 18 0 PRODH_D
SAISO Season Category CHAR 4 0 SAISO
SAISJ Season Year CHAR 4 0 SAISJ
PLGTP Price Band Category CHAR 2 0 PLGTP
ETIAR Label type CHAR 2 0 ETIAR
ETIFO Label form CHAR 2 0 ETIFO
BWVOR Procurement rule CHAR 1 0 BWVOR
KZPIP Pipeline Handling Mandatory CHAR 1 0 KZPIP
XPIZU Pipeline handling allowed CHAR 1 0 XPIZU
MLMAA Material Ledger Activated at Material Level CHAR 1 0 CK_ML_MAAC
MHDRZ Minimum Remaining Shelf Life DEC 4 0 MHDRZ
MHDHB Total shelf life DEC 4 0 MHDHB
SERVG IS-R service level CHAR 1 0 W_SERVGRD
PRCTR Profit Center CHAR 10 0 PRCTR
SBDKZ Dependent requirements ind. for individual and coll. reqmts CHAR 1 0 SBDKZ
Individual and collective requirements
1 Individual requirements only
2 Collective requirements only
ALTSL Method for Selecting Alternative Bills of Material CHAR 1 0 ALTSL
Selection by order quant.
1 Selection by explosion date
2 Selection by production version
3 Selection only by production version
CUOBJ Internal object number NUMC 18 0 CUOBM
MLGUT Empties Bill of Material CHAR 1 0 W_MITLEERG
STDPD Configurable material CHAR 40 0 STDPD
CUOBF Internal object number NUMC 18 0 CUOBM
LGFSB Default storage location for external procurement CHAR 4 0 LGFSB
MATBF Material in Respect of Which Stock is Managed CHAR 40 0 MATBF
MMSTD Date from Which the Plant-Specific Material Status Is Valid DATS 8 0 MMSTD
MSTAE Cross-Plant Material Status CHAR 2 0 MSTAE
MSTDE Date from which the cross-plant material status is valid DATS 8 0 MSTDE
DATAB Valid-From Date DATS 8 0 DATAB
LIQDT Deletion date DATS 8 0 LIQDT
MRPPP PPC Planning Calendar CHAR 3 0 MRPPP
NRFHG Material qualifies for discount in kind CHAR 1 0 NRFHG
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 CHAR 8 0 MFRGR
STEUC Control code for consumption taxes in foreign trade CHAR 16 0 T604F STEUC
MTUSE Usage of the material CHAR 1 0 J_1BMATUSE
0 Resale
1 Industrialisation
2 Consumption
3 Asset
4 Consumption for Main Activity
MTORG Origin of the material CHAR 1 0 J_1BMATORG
0 National - except indicated for codes 3, 4, 5 or 8
1 Foreign - imported directly
2 Foreign - acquired nationally
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 CHAR 1 0 J_1BOWNPRO
INDUS Material CFOP category CHAR 2 0 J_1BINDUS3
00 material
01 electricity
02 communication
03 transportation
04 animal
MFRPN Manufacturer Part Number CHAR 40 0 MFRPN
MFRNR Manufacturer number CHAR 10 0 MFRNR
BMATN Number of firm's own (internal) inventory-managed material CHAR 40 0 MPMAT
MPROF Mfr part profile CHAR 4 0 MPROF
KZWSM Units of measure usage CHAR 1 0 KZWSO
Alternative unit of measure
A Proportion unit
B Product unit
WMAKG Material Type ID CHAR 1 0 WMAK
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 CHAR 1 0 FABKZ
No JIT
1 Automatically
XCHAR Batch management indicator (internal) CHAR 1 0 XCHAR
XCHPF Batch Management Requirement Indicator CHAR 1 0 XCHPF
IPRKZ Period Indicator for Shelf Life Expiration Date CHAR 1 0 DATTP
Day
1 Week
2 Month
3 Year
TRAGR Transportation Group CHAR 4 0 TRAGR
SERNP Serial Number Profile CHAR 4 0 SERAIL
BFLME Generic Material with Logistical Variants CHAR 1 0 BFLME
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 CHAR 1 0 XBEWW
LADGR Loading Group CHAR 4 0 LADGR
RDPRF Rounding Profile CHAR 4 0 RDPRF
BSTRF Rounding value for purchase order quantity QUAN 13 3 BSTRF
BSTMA Maximum Lot Size QUAN 13 3 BSTMA
BSTMI Minimum Lot Size QUAN 13 3 BSTMI
MEGRU Unit of Measure Group CHAR 4 0 MEGRU
LFRHY Planning Cycle CHAR 3 0 LFRHY
PERKZ Period Indicator CHAR 1 0 PERKZ
Initial value
M Monthly
P Period according to fiscal year variant
T Daily
W Weekly
PERIV Fiscal Year Variant CHAR 2 0 PERIV
PRENC Exemption certificate: Indicator for legal control CHAR 1 0 PRENC
Not Relevant
A Requested
B Accepted
C Request Rejected
EKWSL Purchasing Value Key CHAR 4 0 EKWSL
SGT_COVS Segmentation Strategy CHAR 8 0 SGT_COVS
SGT_STATC Segmentation Status CHAR 1 0 SGT_STATC
SGT_SCOPE Segmentation Strategy Scope CHAR 1 0 SGT_SCOPE
1 Requirement and Stock Segments maintained
2 Only Requirement Segments maintained
SGT_CSGR Segmentation Structure CHAR 4 0 SGT_CSGR
SGT_COVSA Segmentation Strategy CHAR 8 0 SGT_COVSA
SGT_REL Segmentation Relevant CHAR 1 0 SGT_REL
WEORA Acceptance At Origin CHAR 1 0 WEORA
FSH_SEALV Indicator: Use of Season CHAR 1 0 FSH_SEALV
Do not use Season Year / Season
C Season Year / Season / Collection
S Use Season Year / Season
T Season Year / Season / Collection / Theme
FSH_SEAIM Indicator: Season Active in Inventory Management CHAR 1 0 FSH_SEAIM
FSH_MG_ARUN_REQ Supply Assignment (ARun) CHAR 1 0 FSH_MG_ARUN_REQ
ARun Non-Relevant
1 ARun Relevant
IMATN FFF class CHAR 40 0 IMATN
PICNUM Supersession chain number CHAR 40 0 PIC_PICNUM_SUS
CONS_PROCG Consignment Control CHAR 1 0 WRFT_CONS_PROCG WRF_CONS_PROCG
GI_PR_TIME Goods Issue Processing Time in Days DEC 3 0 WRF_PSCD_WABAZ
MULTIPLE_EKGRP Purchasing Across Purchasing Group CHAR 1 0 WRF_POHF_OTHER_EKGRP_ALLOW
REF_SCHEMA Reference Determination Schema CHAR 2 0 WRF_REF_RFS WRF_REF_SCHEMA
MIN_TROC Minimum Target Range of Coverage NUMC 3 0 WRF_FRE_TROC_MIN
MAX_TROC Maximum Target Range of Coverage NUMC 3 0 WRF_FRE_TROC_MAX
TARGET_STOCK Target Stock QUAN 13 3 WRF_FRE_TARGET_STOCK

MT06E foreign key relationships

Table Field Check Table Check Field
0 MT06E CONS_PROCG WRFT_CONS_PROCG Seasonal Procurement: Consignment Control MANDT
1 MT06E EVERS T027A Shipping Instructions, Purchasing EVERS
0 MT06E GEWEI T006 Units of Measurement MANDT
0 MT06E GEWEI T006 Units of Measurement MSEHI
1 MT06E MTART T134 Material Types MANDT
1 MT06E MTART T134 Material Types MTART
0 MT06E REF_SCHEMA WRF_REF_RFS Reference Determination Schema MANDT
0 MT06E REF_SCHEMA WRF_REF_RFS Reference Determination Schema REF_SCHEMA
1 MT06E STEUC T604F Import Processing: Control Code MANDT
1 MT06E STEUC T604F Import Processing: Control Code LAND1