SAP table MT06A (Material Master View: Group Data for 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
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
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
MTART Material type CHAR 4 0 T134 MTART
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
QMPUR QM in Procurement Is Active CHAR 1 0 QMPUR
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
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
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
BWSCL Source of Supply CHAR 1 0 BWSCL
KZPIP Pipeline Handling Mandatory CHAR 1 0 KZPIP
MHDRZ Minimum Remaining Shelf Life DEC 4 0 MHDRZ
MHDHB Total shelf life DEC 4 0 MHDHB
MLGUT Empties Bill of Material CHAR 1 0 W_MITLEERG
CUOBF Internal object number NUMC 18 0 CUOBM
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
MAGRV Material Group: Packaging Materials CHAR 4 0 TVEGR MAGRV
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
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
KZGVH Packaging Material is Closed Packaging CHAR 1 0 KZGVH
BMATN Number of firm's own (internal) inventory-managed material CHAR 40 0 MPMAT
MPROF Mfr part profile CHAR 4 0 MPROF
MFRPN Manufacturer Part Number CHAR 40 0 MFRPN
MFRNR Manufacturer number CHAR 10 0 MFRNR
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
MTPOS_MARA General item category group CHAR 4 0 MTPOS_MARA
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
RAUBE Storage conditions CHAR 2 0 RAUBE
TEMPB Temperature conditions indicator CHAR 2 0 TEMPB
PROFL Dangerous Goods Indicator Profile CHAR 3 0 ADGE_PROFL
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
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
IMATN FFF class CHAR 40 0 * IMATN
PICNUM Supersession chain number CHAR 40 0 PIC_PICNUM_SUS
COLOR Characteristic Value for Colors of Variants CHAR 18 0 WRF_COLOR
SIZE1 Characteristic Value for Main Sizes of Variants CHAR 18 0 WRF_SIZE1
SIZE2 Characteristic Value for Second Size for Variants CHAR 18 0 WRF_SIZE2

MT06A foreign key relationships

Table Field Check Table Check Field
0 MT06A EVERS T027A Shipping Instructions, Purchasing EVERS
1 MT06A GEWEI T006 Units of Measurement MANDT
1 MT06A GEWEI T006 Units of Measurement MSEHI
0 MT06A MAGRV TVEGR Material Group: Packaging Materials MANDT
0 MT06A MAGRV TVEGR Material Group: Packaging Materials MAGRV
1 MT06A MTART T134 Material Types MANDT
1 MT06A MTART T134 Material Types MTART
0 MT06A STEUC T604F Import Processing: Control Code MANDT
0 MT06A STEUC T604F Import Processing: Control Code LAND1