MT61D SAP (Material Master: MRP) Structure details

Dictionary Type: Structure
Description: Material Master: MRP




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




Structure field list including key, data, relationships and ABAP select examples

MT61D 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: MRP" 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_MT61D TYPE MT61D.

The MT61D table consists of various fields, each holding specific information or linking keys about Material Master: MRP data available in SAP. These include WERKS (Plant), LVORM (Deletion Indicator), MAKTX (Material Description (Short Text)), MTART (Material Type).. 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 MT61D 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
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
LVORMDeletion Indicator LVORMCHAR1XFELD
MAKTXMaterial Description (Short Text) MAKTXCHAR40TEXT40
MTARTMaterial Type MTARTCHAR4T134MTARTMTA
MATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
MMSTAPlant-Specific Material Status MMSTACHAR2T141MMSTA
DISMMMRP Type DISMMCHAR2T438ADISMM
BESKZProcurement Type BESKZCHAR1BESKZMBS
SOBSLSpecial procurement type SOBSLCHAR2T460ASOBSL
MISKZMixed MRP indicator MISKZCHAR1MISKZ
DISSTLow-Level Code DISSTCHAR3DISST
SBDKZDependent requirements ind. for individual and coll. reqmts SBDKZCHAR1SBDKZ
KZBEDIndicator for Requirements Grouping KZBEDCHAR1KZBED
DISPOMRP Controller (Materials Planner) DISPOCHAR3T024DDISPODGRHS_T024D
EKGRPPurchasing Group EKGRPCHAR3T024EKGRPEKG
KZDIEIndicator: MRP controller is buyer (deactivated) KZDIECHAR1XFELD
DZEITIn-house production time DZEITDEC3DEC3
BEARZProcessing time BEARZDEC5(2) DEC3_2
RUEZTSetup and teardown time RUEZTDEC5(2) DEC3_2
TRANZInteroperation time TRANZDEC5(2) DEC3_2
BASMGBase quantity BASMGQUAN13(3) MENG13
FHORIScheduling Margin Key for Floats FHORICHAR3T436AFHORI
PLIFZPlanned Delivery Time in Days PLIFZDEC3DEC3
WEBAZGoods Receipt Processing Time in Days WEBAZDEC3DEC3
WZEITTotal replenishment lead time (in workdays) WZEITDEC3DEC3
PFREIIndicator: automatic fixing of planned orders PFREICHAR1XFELD
DISLSLot size (materials planning) DISLSCHAR2T439ADISLS
BSTFEFixed lot size BSTFEQUAN13(3) MENG13
BSTMIMinimum Lot Size BSTMIQUAN13(3) MENG13
BSTMAMaximum Lot Size BSTMAQUAN13(3) MENG13
BSTRFRounding value for purchase order quantity BSTRFQUAN13(3) MENG13
MABSTMaximum stock level MABSTQUAN13(3) MENG13
AUSSSAssembly scrap in percent AUSSSDEC5(2) DEC3_2
EISBESafety Stock EISBEQUAN13(3) MENG13
MINBEReorder Point MINBEQUAN13(3) MENG13
LOSFXOrdering costs LOSFXCURR11(2) WERT11
LAGPRStorage costs indicator LAGPRCHAR1T439LLAGPR
PROKZForecast indicator PROKZCHAR1PROKZ
PERKZPeriod Indicator PERKZCHAR1PERKZPKZ
AUFTLSplitting Indicator AUFTLCHAR1T439PAUFTL
KZAUSDiscontinuation indicator KZAUSCHAR1KZAUS
AUSDTEffective-Out Date AUSDTDATS8DATUM
NFMATFollow-Up Material NFMATCHAR18MARAMATN1MATNRMAT
ALTSLMethod for Selecting Alternative Bills of Material ALTSLCHAR1ALTSL
BKLASValuation Class BKLASCHAR4T025BKLAS
VPRSVPrice control indicator VPRSVCHAR1VPRSV
VERPRMoving Average Price/Periodic Unit Price VERPRCURR11(2) WERT11V
STPRSStandard price STPRSCURR11(2) WERT11V
PEINHPrice Unit PEINHDEC5PACK3
UMLMCStock in Transfer (Plant to Plant) UMLMEQUAN13(3) MENG13V
USEQUQuota arrangement usage USEQUCHAR1TMQ2USEQU
PERIVFiscal Year Variant PERIVCHAR2T009PERIV
MTVFPChecking Group for Availability Check MTVFPCHAR2TMVFMTVFP
WERTUValue Update in Material Master Record WERTUCHAR1XFELD
MENGUQuantity Updating in Material Master Record MENGUCHAR1XFELD
SAUFTInd.: Repetitive mfg allowed SA_SAUFTCHAR1XFELD
MRPPPPPC planning calendar MRPPPCHAR3T439GMRPPP
LFRHYPlanning cycle LFRHYCHAR3T439GMRPPP
DISGRMRP Group DISGRCHAR4T438MDISGR
PSTATMaintenance status PSTAT_DCHAR15PSTAT
VRMODConsumption mode VRMODCHAR1VRMOD
VINT1Consumption period: backward VINT1NUMC3VRINT
VINT2Consumption period: forward VINT2NUMC3VRINT
FXHORPlanning time fence FXHORNUMC3FXHOR
QMATVInspection Setup Exists for Material/Plant QMATVCHAR1XFELD
PRGRPPlanning material VPMATCHAR18MARAMATN1MATNR
PRWRKPlanning plant VPWRKCHAR4T001WWERKS
UMREFConversion factor: quantities UMREFFFLTP16(16) FLTP
PRBMEBase unit of measure for product group PRBMEUNIT3T006CUNITMEINS
TAKZTTakt time TAKZTDEC3DEC3
FEVORProduction Supervisor FEVORCHAR3T024FFEVORCFV
RWPRORange of coverage profile RWPROCHAR3T438RRWPRO
KZREVRevision Level Has Been Assigned to the Material KZREVCHAR1XFELD
KZKFGConfigurable Material KZKFGCHAR1XFELD
STDPDConfigurable material STDPDCHAR18MARAMATN1MATNR
CUOBJInternal object number CUOBMNUMC18CUOBJ
CUOBFInternal object number CUOBMNUMC18CUOBJ
LGPROIssue Storage Location LGPROCHAR4T001LLGORT
SFEPRRepetitive manufacturing profile SFEPRCHAR4T437SSFEPR
RDPRFRounding Profile RDPRFCHAR4Assigned to domainRDPRF
STRGRPlanning strategy group STRGRCHAR2T461PSTRGR
LGFSBDefault storage location for external procurement LGFSBCHAR4T001LLGORT
BSTMEPurchase Order Unit of Measure BSTMEUNIT3T006CUNITMEINS
AUSMEUnit of issue AUSMEUNIT3T006CUNITMEINS
EXPMEUnit of measure for commodity code (foreign trade) EXPMEUNIT3T006CUNITMEINS
FRTMEProduction unit FRTMEUNIT3T006CUNITMEINS
SERNPSerial Number Profile SERAILCHAR4T377PSERAIL
EPRIOWithdrawal sequence group for stocks EPRIOCHAR4Assigned to domainEPRIO
CUOBVInternal object number of configurable material for planning CUOBVNUMC18CUOBJ
BSEXTExternal Purchase Orders Allowed BSEXTCHAR1BSEXT
BSINTInternal purchase orders allowed BSINTCHAR1BSINT
KZGRPGrouping indicator KZGRPCHAR1KZGRP
INSMKStock Type INSMKCHAR1INSMK
RESVPPeriod of adjustment for planned independent requirements RESVPDEC3RESVP
XCHPFBatch management requirement indicator XCHPFCHAR1XFELD
TRAMEStock in Transit TRAMEQUAN13(3) MENG13V
SHFLGSafety time indicator (with or without safety time) SHFLGCHAR1SHFLG
SHZETSafety time (in workdays) SHZETNUMC2NUMC2
MDACHAction control: planned order processing MDACHCHAR2T46ACMDACH
BWSCLSource of Supply BWSCLCHAR1Assigned to domainBQSCL
SPARTDivision SPARTCHAR2Assigned to domainSPARTSPAC_SPART
ATTYPMaterial Category ATTYPCHAR2ATTYPMTY
SATNRCross-Plant Configurable Material SATNRCHAR18Assigned to domainMATN1MATNR
KZWSMUnits of measure usage KZWSOCHAR1KZWSO
FABKZIndicator: Item Relevant to JIT Delivery Schedules FABKZCHAR1FABKZ
SERLVLevel of Explicitness for Serial Number SERLVCHAR1SERLV
VSPVBProposed Supply Area in Material Master Record VSPVBCHAR10PVBEPRVBE
DPLFSFair share rule DPLFSCHAR2DPLFS
DPLPUIndicator: push distribution DPLPUCHAR1DPLPU
DPLHODeployment horizon in days DPLHODEC3DEC3
MMSTDDate from which the plant-specific material status is valid MMSTDDATS8DATUM
MSTAECross-Plant Material Status MSTAECHAR2T141MMSTA
MSTDEDate from which the cross-plant material status is valid MSTDEDATS8DATUM
MFRPNManufacturer Part Number MFRPNCHAR40CHAR40
MFRNRNumber of a Manufacturer MFRNRCHAR10Assigned to domainALPHALIFNR
MPROFManufacturer Part Profile MPROFCHAR4Assigned to domainMPROF
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
KZEFFAssign effectivity parameter values/ override change numbers CC_MTEFFCHAR1XFELD
MAABCABC Indicator MAABCCHAR1TMABCMAABC
SHPROPeriod Profile for Safety Time SHPROCHAR3Assigned to domainSHPRO
DIBERIndicator: MRP area exists DIBERCHAR1XFELD
AHDISMRP relevancy for dependent requirements AHDISCHAR1AHDIS
APOKZIndicator: Is material relevant for APO APOKZCHAR1APOKZ
SCHGTIndicator: Bulk Material SCHGTCHAR1XFELD
BERIDMRP Area BERIDCHAR10Assigned to domainBERIDBERID
KZPSPIndicator for cross-project material KZPSPCHAR1KZPSP
EISLOMinimum Safety Stock EISLOQUAN13(3) MENG13
BFLMEGeneric Material with Logistical Variants BFLMECHAR1BFLME
BWESBValuated Goods Receipt Blocked Stock BWESBQUAN13(3) MENG13V
.INCLU--AP 0
IMATNFFF class IMATNCHAR18Assigned to domainMATN1MATNR
PICNUMSupersession chain number PIC_PICNUM_SUSCHAR18ALPHAPIC_PICNUMPIC_PICNUM

Key field Non-key field



How do I retrieve data from SAP structure MT61D using ABAP code?

As MT61D 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 MT61D as there is no data to select.

How to access SAP table MT61D

Within an ECC or HANA version of SAP you can also view further information about MT61D 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!