MT06E SAP (Material Master Fields: Purchasing) Structure details
Description: Material Master Fields: Purchasing
Structure field list including key, data, relationships and ABAP select examples
MT06E is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Material Master Fields: Purchasing" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_MT06E TYPE MT06E.
The MT06E table consists of various fields, each holding specific information or linking keys about Material Master Fields: Purchasing data available in SAP. These include MEINS (Base Unit of Measure), BSTME (Purchase Order Unit of Measure), AUSME (Unit of issue), MAKTX (Material Description (Short Text)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP MT06E structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
BSTME | Purchase Order Unit of Measure | BSTME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
AUSME | Unit of issue | AUSME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 | ||||
MMSTA | Plant-Specific Material Status | MMSTA | CHAR | 2 | Assigned to domain | MMSTA | |||
EKGRP | Purchasing Group | EKGRP | CHAR | 3 | Assigned to domain | EKGRP | EKG | ||
DISPO | MRP Controller (Materials Planner) | DISPO | CHAR | 3 | Assigned to domain | DISPO | DGR | HS_T024D | |
WEBAZ | Goods Receipt Processing Time in Days | WEBAZ | DEC | 3 | DEC3 | ||||
UNTTO | Underdelivery Tolerance Limit | UNTTO | DEC | 3(1) | PRZ21 | ||||
UEBTO | Overdelivery Tolerance Limit | UEBTO | DEC | 3(1) | PRZ21 | ||||
UEBTK | Indicator: Unlimited Overdelivery Allowed | UEBTK | CHAR | 1 | XFELD | ||||
MAHN1 | Reminder level and reminder days (reminders/urging letters) | MAHNT | DEC | 3 | MAHNT | ||||
MAHN2 | Reminder level and reminder days (reminders/urging letters) | MAHNT | DEC | 3 | MAHNT | ||||
MAHN3 | Reminder level and reminder days (reminders/urging letters) | MAHNT | DEC | 3 | MAHNT | ||||
INSMK | Stock Type | INSMK | CHAR | 1 | INSMK | ||||
BKLAS | Valuation Class | BKLAS | CHAR | 4 | Assigned to domain | BKLAS | |||
BWTTY | Valuation Category | BWTTY_D | CHAR | 1 | Assigned to domain | BWTTY | |||
VPRSV | Price control indicator | VPRSV | CHAR | 1 | VPRSV | ||||
VERPR | Moving Average Price/Periodic Unit Price | VERPR | CURR | 11(2) | WERT11V | ||||
STPRS | Standard price | STPRS | CURR | 11(2) | WERT11V | ||||
PEINH | Price Unit | PEINH | DEC | 5 | PACK3 | ||||
BSEXT | External Purchase Orders Allowed | BSEXT | CHAR | 1 | BSEXT | ||||
BSINT | Internal purchase orders allowed | BSINT | CHAR | 1 | BSINT | ||||
WERTU | Value Update in Material Master Record | WERTU | CHAR | 1 | XFELD | ||||
MENGU | Quantity Updating in Material Master Record | MENGU | CHAR | 1 | XFELD | ||||
PLIFZ | Planned Delivery Time in Days | PLIFZ | DEC | 3 | DEC3 | ||||
DISST | Low-Level Code | DISST | CHAR | 3 | DISST | ||||
DISMM | MRP Type | DISMM | CHAR | 2 | Assigned to domain | DISMM | |||
USEQU | Quota arrangement usage | USEQU | CHAR | 1 | Assigned to domain | USEQU | |||
MTART | Material Type | MTART | CHAR | 4 | T134 | MTART | MTA | ||
BWSCL | Source of Supply | BWSCL | CHAR | 1 | Assigned to domain | BQSCL | |||
KZABS | Order Acknowledgment Requirement | KZABS | CHAR | 1 | XFELD | ||||
EVERS | Shipping Instructions | EVERS | CHAR | 2 | T027A | EVERS | |||
NTGEW | Net Weight | NTGEW | QUAN | 13(3) | MENG13 | ||||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
KORDB | Indicator: Source list requirement | KORDB | CHAR | 1 | XFELD | ||||
STAWN | Commodity Code/Import Code Number for Foreign Trade | STAWN | CHAR | 17 | Assigned to domain | STAWN | |||
KAUTB | Indicator: 'automatic purchase order allowed' | KAUTB | CHAR | 1 | FLAG | ||||
HERKL | Country of origin of the material | HERKL | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
HERKR | Region of origin of material (non-preferential origin) | HERKR | CHAR | 3 | Assigned to domain | REGIO | |||
QMPUR | QM in Procurement is Active | QMPUR | CHAR | 1 | XFELD | ||||
SSQSS | Control Key for Quality Management in Procurement | QSSPUR | CHAR | 8 | Assigned to domain | QSSPUR | |||
QZGTP | Certificate Type | QZGTYP | CHAR | 4 | Assigned to domain | QZGTYP | QCT | ||
QMATV | Inspection Setup Exists for Material/Plant | QMATV | CHAR | 1 | XFELD | ||||
VABME | Variable Purchase Order Unit Active | VABME | CHAR | 1 | VABME | ||||
EAN11 | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | EAN11 | EAN11 | EAN | ||
KZREV | Revision Level Has Been Assigned to the Material | KZREV | CHAR | 1 | XFELD | ||||
BRGEW | Gross Weight | BRGEW | QUAN | 13(3) | MENG13 | ||||
VOLUM | Volume | VOLUM | QUAN | 13(3) | MENG13 | ||||
VOLEH | Volume unit | VOLEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
QSSYS | Required QM System for Vendor | QSSYS_SOLL | CHAR | 4 | Assigned to domain | QSSYS | |||
KZKFG | Configurable Material | KZKFG | CHAR | 1 | XFELD | ||||
SATNR | Cross-Plant Configurable Material | SATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
ATTYP | Material Category | ATTYP | CHAR | 2 | ATTYP | MTY | |||
SOBES | Special procurement type | SOBES | CHAR | 1 | SOBES | ||||
BESKZ | Procurement Type | BESKZ | CHAR | 1 | BESKZ | MBS | |||
WRK02 | Supplying (Issuing) Plant in Stock Transport Order | RESWK | CHAR | 4 | Assigned to domain | WERKS | |||
PRDHA | Product hierarchy | PRODH_D | CHAR | 18 | Assigned to domain | PRODH | VPR | ||
SAISO | Season Category | SAISO | CHAR | 4 | Assigned to domain | SAISO | SAISO | ||
SAISJ | Season Year | SAISJ | CHAR | 4 | GJAHR | CJAHR | WMSAISJ | ||
PLGTP | Price Band Category | PLGTP | CHAR | 2 | Assigned to domain | PLGTP | |||
ETIAR | Label type | ETIAR | CHAR | 2 | Assigned to domain | ETIAR | |||
ETIFO | Label form | ETIFO | CHAR | 2 | Assigned to domain | ETIFO | |||
BWVOR | Procurement rule | BWVOR | CHAR | 1 | Assigned to domain | BWVOR | |||
KZPIP | Pipeline Handling Mandatory | KZPIP | CHAR | 1 | XFELD | ||||
XPIZU | Pipeline handling allowed | XPIZU | CHAR | 1 | XFELD | ||||
MLMAA | Material ledger activated at material level | CK_ML_MAAC | CHAR | 1 | XFELD | ||||
MHDRZ | Minimum Remaining Shelf Life | MHDRZ | DEC | 4 | DEC4 | ||||
MHDHB | Total shelf life | MHDHB | DEC | 4 | DEC4 | ||||
SERVG | IS-R service level | W_SERVGRD | CHAR | 1 | Assigned to domain | W_SERVGRD | |||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
SBDKZ | Dependent requirements ind. for individual and coll. reqmts | SBDKZ | CHAR | 1 | SBDKZ | ||||
ALTSL | Method for Selecting Alternative Bills of Material | ALTSL | CHAR | 1 | ALTSL | ||||
CUOBJ | Internal object number | CUOBM | NUMC | 18 | CUOBJ | ||||
MLGUT | Empties Bill of Material | W_MITLEERG | CHAR | 1 | FLAG | ||||
STDPD | Configurable material | STDPD | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
CUOBF | Internal object number | CUOBM | NUMC | 18 | CUOBJ | ||||
LGFSB | Default storage location for external procurement | LGFSB | CHAR | 4 | Assigned to domain | LGORT | |||
MATBF | Material in Respect of Which Stock is Managed | MATBF | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
MMSTD | Date from which the plant-specific material status is valid | MMSTD | DATS | 8 | DATUM | ||||
MSTAE | Cross-Plant Material Status | MSTAE | CHAR | 2 | Assigned to domain | MMSTA | |||
MSTDE | Date from which the cross-plant material status is valid | MSTDE | DATS | 8 | DATUM | ||||
DATAB | Valid-From Date | DATAB | DATS | 8 | DATUM | ||||
LIQDT | Deletion date | LIQDT | DATS | 8 | DATUM | ||||
MRPPP | PPC planning calendar | MRPPP | CHAR | 3 | Assigned to domain | MRPPP | |||
NRFHG | Material qualifies for discount in kind | NRFHG | CHAR | 1 | NRFHG | ||||
MFRGR | Material freight group | MFRGR | CHAR | 8 | Assigned to domain | MFRGR | |||
STEUC | Control code for consumption taxes in foreign trade | STEUC | CHAR | 16 | T604F | STEUC | |||
MTUSE | Usage of the material | J_1BMATUSE | CHAR | 1 | J_1BMATUSE | ||||
MTORG | Origin of the material | J_1BMATORG | CHAR | 1 | J_1BMATORG | ||||
OWNPR | Produced in-house | J_1BOWNPRO | CHAR | 1 | XFELD | ||||
INDUS | Material CFOP category | J_1BINDUS3 | CHAR | 2 | ALPHA | J_1BINDUS3 | |||
MFRPN | Manufacturer Part Number | MFRPN | CHAR | 40 | CHAR40 | ||||
MFRNR | Number of a Manufacturer | MFRNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
BMATN | Number of firm's own (internal) inventory-managed material | MPMAT | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
MPROF | Manufacturer Part Profile | MPROF | CHAR | 4 | Assigned to domain | MPROF | |||
KZWSM | Units of measure usage | KZWSO | CHAR | 1 | KZWSO | ||||
WMAKG | Material type ID | WMAK | CHAR | 1 | WMAK | ||||
FABKZ | Indicator: Item Relevant to JIT Delivery Schedules | FABKZ | CHAR | 1 | FABKZ | ||||
XCHAR | Batch management indicator (internal) | XCHAR | CHAR | 1 | XFELD | ||||
XCHPF | Batch management requirement indicator | XCHPF | CHAR | 1 | XFELD | ||||
IPRKZ | Period Indicator for Shelf Life Expiration Date | DATTP | CHAR | 1 | PERKZ | DATTP | H_PERDKZ | ||
TRAGR | Transportation Group | TRAGR | CHAR | 4 | Assigned to domain | TRAGR | |||
SERNP | Serial Number Profile | SERAIL | CHAR | 4 | Assigned to domain | SERAIL | |||
BFLME | Generic Material with Logistical Variants | BFLME | CHAR | 1 | BFLME | ||||
XBEWM | Valuation based on the batch-specific unit of measure | XBEWW | CHAR | 1 | XFELD | ||||
LADGR | Loading Group | LADGR | CHAR | 4 | Assigned to domain | LADGR | |||
RDPRF | Rounding Profile | RDPRF | CHAR | 4 | Assigned to domain | RDPRF | |||
BSTRF | Rounding value for purchase order quantity | BSTRF | QUAN | 13(3) | MENG13 | ||||
BSTMA | Maximum Lot Size | BSTMA | QUAN | 13(3) | MENG13 | ||||
BSTMI | Minimum Lot Size | BSTMI | QUAN | 13(3) | MENG13 | ||||
MEGRU | Unit of Measure Group | MEGRU | CHAR | 4 | Assigned to domain | MEGRU | |||
LFRHY | Planning cycle | LFRHY | CHAR | 3 | Assigned to domain | MRPPP | |||
PERKZ | Period Indicator | PERKZ | CHAR | 1 | PERKZ | PKZ | |||
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | Assigned to domain | PERIV | |||
PRENC | Exemption certificate: Indicator for legal control | PRENC | CHAR | 1 | PRENC | ||||
EKWSL | Purchasing Value Key | EKWSL | CHAR | 4 | Assigned to domain | EKWSL | |||
.INCLU--AP | 0 | ||||||||
IMATN | FFF class | IMATN | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
PICNUM | Supersession chain number | PIC_PICNUM_SUS | CHAR | 18 | ALPHA | PIC_PICNUM | PIC_PICNUM | ||
.INCLU--AP | 0 | ||||||||
CONS_PROCG | Consignment Control | WRF_CONS_PROCG | CHAR | 1 | WRFT_CONS_PROCG | WRF_CONS_PROCG | |||
GI_PR_TIME | Goods Issue Processing Time in Days | WRF_PSCD_WABAZ | DEC | 3 | DEC3 | ||||
MULTIPLE_EKGRP | Purchasing Across Purchasing Group | WRF_POHF_OTHER_EKGRP_ALLOW | CHAR | 1 | CHAR1_X | ||||
REF_SCHEMA | Reference Determination Schema | WRF_REF_SCHEMA | CHAR | 2 | WRF_REF_RFS | WRF_REF_SCHEMA | |||
MIN_TROC | Minimum Target Range of Coverage | WRF_FRE_TROC_MIN | NUMC | 3 | WRF_FRE_TROC | ||||
MAX_TROC | Maximum Target Range of Coverage | WRF_FRE_TROC_MAX | NUMC | 3 | WRF_FRE_TROC | ||||
TARGET_STOCK | Target Stock | WRF_FRE_TARGET_STOCK | QUAN | 13(3) | MENG13 |
Key field | Non-key field |
How do I retrieve data from SAP structure MT06E using ABAP code?
As MT06E is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MT06E as there is no data to select.How to access SAP table MT06E
Within an ECC or HANA version of SAP you can also view further information about MT06E and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects