MT06E SAP (Material Master Fields: Purchasing) Structure details

Dictionary Type: Structure
Description: Material Master Fields: Purchasing




ABAP Code to SELECT data from MT06E
Related tables to MT06E
Access table MT06E




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
MATKLMaterial Group MATKLCHAR9Assigned to domainMATKLMKLS_WBWG
MEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
BSTMEPurchase Order Unit of Measure BSTMEUNIT3Assigned to domainCUNITMEINS
AUSMEUnit of issue AUSMEUNIT3Assigned to domainCUNITMEINS
MAKTXMaterial Description (Short Text) MAKTXCHAR40TEXT40
MMSTAPlant-Specific Material Status MMSTACHAR2Assigned to domainMMSTA
EKGRPPurchasing Group EKGRPCHAR3Assigned to domainEKGRPEKG
DISPOMRP Controller (Materials Planner) DISPOCHAR3Assigned to domainDISPODGRHS_T024D
WEBAZGoods Receipt Processing Time in Days WEBAZDEC3DEC3
UNTTOUnderdelivery Tolerance Limit UNTTODEC3(1) PRZ21
UEBTOOverdelivery Tolerance Limit UEBTODEC3(1) PRZ21
UEBTKIndicator: Unlimited Overdelivery Allowed UEBTKCHAR1XFELD
MAHN1Reminder level and reminder days (reminders/urging letters) MAHNTDEC3MAHNT
MAHN2Reminder level and reminder days (reminders/urging letters) MAHNTDEC3MAHNT
MAHN3Reminder level and reminder days (reminders/urging letters) MAHNTDEC3MAHNT
INSMKStock Type INSMKCHAR1INSMK
BKLASValuation Class BKLASCHAR4Assigned to domainBKLAS
BWTTYValuation Category BWTTY_DCHAR1Assigned to domainBWTTY
VPRSVPrice control indicator VPRSVCHAR1VPRSV
VERPRMoving Average Price/Periodic Unit Price VERPRCURR11(2) WERT11V
STPRSStandard price STPRSCURR11(2) WERT11V
PEINHPrice Unit PEINHDEC5PACK3
BSEXTExternal Purchase Orders Allowed BSEXTCHAR1BSEXT
BSINTInternal purchase orders allowed BSINTCHAR1BSINT
WERTUValue Update in Material Master Record WERTUCHAR1XFELD
MENGUQuantity Updating in Material Master Record MENGUCHAR1XFELD
PLIFZPlanned Delivery Time in Days PLIFZDEC3DEC3
DISSTLow-Level Code DISSTCHAR3DISST
DISMMMRP Type DISMMCHAR2Assigned to domainDISMM
USEQUQuota arrangement usage USEQUCHAR1Assigned to domainUSEQU
MTARTMaterial Type MTARTCHAR4T134MTARTMTA
BWSCLSource of Supply BWSCLCHAR1Assigned to domainBQSCL
KZABSOrder Acknowledgment Requirement KZABSCHAR1XFELD
EVERSShipping Instructions EVERSCHAR2T027AEVERS
NTGEWNet Weight NTGEWQUAN13(3) MENG13
GEWEIWeight Unit GEWEIUNIT3T006CUNITMEINS
KORDBIndicator: Source list requirement KORDBCHAR1XFELD
STAWNCommodity Code/Import Code Number for Foreign Trade STAWNCHAR17Assigned to domainSTAWN
KAUTBIndicator: 'automatic purchase order allowed' KAUTBCHAR1FLAG
HERKLCountry of origin of the material HERKLCHAR3Assigned to domainLAND1LND
HERKRRegion of origin of material (non-preferential origin) HERKRCHAR3Assigned to domainREGIO
QMPURQM in Procurement is Active QMPURCHAR1XFELD
SSQSSControl Key for Quality Management in Procurement QSSPURCHAR8Assigned to domainQSSPUR
QZGTPCertificate Type QZGTYPCHAR4Assigned to domainQZGTYPQCT
QMATVInspection Setup Exists for Material/Plant QMATVCHAR1XFELD
VABMEVariable Purchase Order Unit Active VABMECHAR1VABME
EAN11International Article Number (EAN/UPC) EAN11CHAR18EAN11EAN11EAN
KZREVRevision Level Has Been Assigned to the Material KZREVCHAR1XFELD
BRGEWGross Weight BRGEWQUAN13(3) MENG13
VOLUMVolume VOLUMQUAN13(3) MENG13
VOLEHVolume unit VOLEHUNIT3Assigned to domainCUNITMEINS
QSSYSRequired QM System for Vendor QSSYS_SOLLCHAR4Assigned to domainQSSYS
KZKFGConfigurable Material KZKFGCHAR1XFELD
SATNRCross-Plant Configurable Material SATNRCHAR18Assigned to domainMATN1MATNR
ATTYPMaterial Category ATTYPCHAR2ATTYPMTY
SOBESSpecial procurement type SOBESCHAR1SOBES
BESKZProcurement Type BESKZCHAR1BESKZMBS
WRK02Supplying (Issuing) Plant in Stock Transport Order RESWKCHAR4Assigned to domainWERKS
PRDHAProduct hierarchy PRODH_DCHAR18Assigned to domainPRODHVPR
SAISOSeason Category SAISOCHAR4Assigned to domainSAISOSAISO
SAISJSeason Year SAISJCHAR4GJAHRCJAHRWMSAISJ
PLGTPPrice Band Category PLGTPCHAR2Assigned to domainPLGTP
ETIARLabel type ETIARCHAR2Assigned to domainETIAR
ETIFOLabel form ETIFOCHAR2Assigned to domainETIFO
BWVORProcurement rule BWVORCHAR1Assigned to domainBWVOR
KZPIPPipeline Handling Mandatory KZPIPCHAR1XFELD
XPIZUPipeline handling allowed XPIZUCHAR1XFELD
MLMAAMaterial ledger activated at material level CK_ML_MAACCHAR1XFELD
MHDRZMinimum Remaining Shelf Life MHDRZDEC4DEC4
MHDHBTotal shelf life MHDHBDEC4DEC4
SERVGIS-R service level W_SERVGRDCHAR1Assigned to domainW_SERVGRD
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
SBDKZDependent requirements ind. for individual and coll. reqmts SBDKZCHAR1SBDKZ
ALTSLMethod for Selecting Alternative Bills of Material ALTSLCHAR1ALTSL
CUOBJInternal object number CUOBMNUMC18CUOBJ
MLGUTEmpties Bill of Material W_MITLEERGCHAR1FLAG
STDPDConfigurable material STDPDCHAR18Assigned to domainMATN1MATNR
CUOBFInternal object number CUOBMNUMC18CUOBJ
LGFSBDefault storage location for external procurement LGFSBCHAR4Assigned to domainLGORT
MATBFMaterial in Respect of Which Stock is Managed MATBFCHAR18Assigned to domainMATN1MATNR
MMSTDDate from which the plant-specific material status is valid MMSTDDATS8DATUM
MSTAECross-Plant Material Status MSTAECHAR2Assigned to domainMMSTA
MSTDEDate from which the cross-plant material status is valid MSTDEDATS8DATUM
DATABValid-From Date DATABDATS8DATUM
LIQDTDeletion date LIQDTDATS8DATUM
MRPPPPPC planning calendar MRPPPCHAR3Assigned to domainMRPPP
NRFHGMaterial qualifies for discount in kind NRFHGCHAR1NRFHG
MFRGRMaterial freight group MFRGRCHAR8Assigned to domainMFRGR
STEUCControl code for consumption taxes in foreign trade STEUCCHAR16T604FSTEUC
MTUSEUsage of the material J_1BMATUSECHAR1J_1BMATUSE
MTORGOrigin of the material J_1BMATORGCHAR1J_1BMATORG
OWNPRProduced in-house J_1BOWNPROCHAR1XFELD
INDUSMaterial CFOP category J_1BINDUS3CHAR2ALPHAJ_1BINDUS3
MFRPNManufacturer Part Number MFRPNCHAR40CHAR40
MFRNRNumber of a Manufacturer MFRNRCHAR10Assigned to domainALPHALIFNR
BMATNNumber of firm's own (internal) inventory-managed material MPMATCHAR18Assigned to domainMATN1MATNRMAT
MPROFManufacturer Part Profile MPROFCHAR4Assigned to domainMPROF
KZWSMUnits of measure usage KZWSOCHAR1KZWSO
WMAKGMaterial type ID WMAKCHAR1WMAK
FABKZIndicator: Item Relevant to JIT Delivery Schedules FABKZCHAR1FABKZ
XCHARBatch management indicator (internal) XCHARCHAR1XFELD
XCHPFBatch management requirement indicator XCHPFCHAR1XFELD
IPRKZPeriod Indicator for Shelf Life Expiration Date DATTPCHAR1PERKZDATTPH_PERDKZ
TRAGRTransportation Group TRAGRCHAR4Assigned to domainTRAGR
SERNPSerial Number Profile SERAILCHAR4Assigned to domainSERAIL
BFLMEGeneric Material with Logistical Variants BFLMECHAR1BFLME
XBEWMValuation based on the batch-specific unit of measure XBEWWCHAR1XFELD
LADGRLoading Group LADGRCHAR4Assigned to domainLADGR
RDPRFRounding Profile RDPRFCHAR4Assigned to domainRDPRF
BSTRFRounding value for purchase order quantity BSTRFQUAN13(3) MENG13
BSTMAMaximum Lot Size BSTMAQUAN13(3) MENG13
BSTMIMinimum Lot Size BSTMIQUAN13(3) MENG13
MEGRUUnit of Measure Group MEGRUCHAR4Assigned to domainMEGRU
LFRHYPlanning cycle LFRHYCHAR3Assigned to domainMRPPP
PERKZPeriod Indicator PERKZCHAR1PERKZPKZ
PERIVFiscal Year Variant PERIVCHAR2Assigned to domainPERIV
PRENCExemption certificate: Indicator for legal control PRENCCHAR1PRENC
EKWSLPurchasing Value Key EKWSLCHAR4Assigned to domainEKWSL
.INCLU--AP 0
IMATNFFF class IMATNCHAR18Assigned to domainMATN1MATNR
PICNUMSupersession chain number PIC_PICNUM_SUSCHAR18ALPHAPIC_PICNUMPIC_PICNUM
.INCLU--AP 0
CONS_PROCGConsignment Control WRF_CONS_PROCGCHAR1WRFT_CONS_PROCGWRF_CONS_PROCG
GI_PR_TIMEGoods Issue Processing Time in Days WRF_PSCD_WABAZDEC3DEC3
MULTIPLE_EKGRPPurchasing Across Purchasing Group WRF_POHF_OTHER_EKGRP_ALLOWCHAR1CHAR1_X
REF_SCHEMAReference Determination Schema WRF_REF_SCHEMACHAR2WRF_REF_RFSWRF_REF_SCHEMA
MIN_TROCMinimum Target Range of Coverage WRF_FRE_TROC_MINNUMC3WRF_FRE_TROC
MAX_TROCMaximum Target Range of Coverage WRF_FRE_TROC_MAXNUMC3WRF_FRE_TROC
TARGET_STOCKTarget Stock WRF_FRE_TARGET_STOCKQUAN13(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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!