1. Home
  2. Resources
  3. SAP Tables
  4. MT61D - Material Master: MRP

SAP Table MT61D

Material Master: MRP

MT61D (Material Master: MRP) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MT61D to other SAP tables.

MT61D table fields

Field Data element Checktable Datatype Length Decimals
MATNR Material Number MATNR MARA CHAR 18 0
WERKS Plant WERKS_D T001W CHAR 4 0
LVORM Deletion Indicator LVORM CHAR 1 0
X Yes
NULL No
MAKTX Material Description (Short Text) MAKTX CHAR 40 0
MTART Material Type MTART T134 CHAR 4 0
MATKL Material Group MATKL T023 CHAR 9 0
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
MMSTA Plant-Specific Material Status MMSTA T141 CHAR 2 0
DISMM MRP Type DISMM T438A CHAR 2 0
BESKZ Procurement Type BESKZ CHAR 1 0
E In-house production
F External procurement
NULL No procurement
X Both procurement types
SOBSL Special procurement type SOBSL T460A CHAR 2 0
MISKZ Mixed MRP indicator MISKZ CHAR 1 0
1 Subassembly planning with final assembly
2 Gross requirements planning
3 Subassembly planning without final assembly
DISST Low-Level Code DISST CHAR 3 0
SBDKZ Dependent requirements ind. for individual and coll. reqmts SBDKZ CHAR 1 0
NULL Individual and collective requirements
1 Individual requirements only
2 Collective requirements only
KZBED Indicator for Requirements Grouping KZBED CHAR 1 0
T Display of dependent requirements as a daily total
0 In rep. mfg, individual record in addn to total requirements
DISPO MRP Controller (Materials Planner) DISPO T024D CHAR 3 0
EKGRP Purchasing Group EKGRP T024 CHAR 3 0
KZDIE Indicator: MRP controller is buyer (deactivated) KZDIE CHAR 1 0
X Yes
NULL No
DZEIT In-house production time DZEIT DEC 3 0
BEARZ Processing time BEARZ DEC 5 2
RUEZT Setup and teardown time RUEZT DEC 5 2
TRANZ Interoperation time TRANZ DEC 5 2
BASMG Base quantity BASMG QUAN 13 3
FHORI Scheduling Margin Key for Floats FHORI T436A CHAR 3 0
PLIFZ Planned Delivery Time in Days PLIFZ DEC 3 0
WEBAZ Goods Receipt Processing Time in Days WEBAZ DEC 3 0
WZEIT Total replenishment lead time (in workdays) WZEIT DEC 3 0
PFREI Indicator: automatic fixing of planned orders PFREI CHAR 1 0
X Yes
NULL No
DISLS Lot size (materials planning) DISLS T439A CHAR 2 0
BSTFE Fixed lot size BSTFE QUAN 13 3
BSTMI Minimum Lot Size BSTMI QUAN 13 3
BSTMA Maximum Lot Size BSTMA QUAN 13 3
BSTRF Rounding value for purchase order quantity BSTRF QUAN 13 3
MABST Maximum stock level MABST QUAN 13 3
AUSSS Assembly scrap in percent AUSSS DEC 5 2
EISBE Safety Stock EISBE QUAN 13 3
MINBE Reorder Point MINBE QUAN 13 3
LOSFX Ordering costs LOSFX CURR 11 2
LAGPR Storage costs indicator LAGPR T439L CHAR 1 0
PROKZ Forecast indicator PROKZ CHAR 1 0
NULL No forecast
+ Obligatory forecast
* Optional forecast
PERKZ Period Indicator PERKZ CHAR 1 0
P Period according to fiscal year variant
M Monthly
W Weekly
T Daily
NULL Initial value
AUFTL Splitting Indicator AUFTL T439P CHAR 1 0
KZAUS Discontinuation indicator KZAUS CHAR 1 0
1 Single/parallel discontinued part/material
3 Dependent parallel discontinued part/material
AUSDT Effective-Out Date AUSDT DATS 8 0
NFMAT Follow-Up Material NFMAT MARA CHAR 18 0
ALTSL Method for Selecting Alternative Bills of Material ALTSL CHAR 1 0
NULL Selection by order quant.
1 Selection by explosion date
2 Selection by production version
3 Selection only by production version
BKLAS Valuation Class BKLAS T025 CHAR 4 0
VPRSV Price control indicator VPRSV CHAR 1 0
S Standard price
V Moving average price/periodic unit price
VERPR Moving Average Price/Periodic Unit Price VERPR CURR 11 2
STPRS Standard price STPRS CURR 11 2
PEINH Price Unit PEINH DEC 5 0
UMLMC Stock in Transfer (Plant to Plant) UMLME QUAN 13 3
USEQU Quota arrangement usage USEQU TMQ2 CHAR 1 0
PERIV Fiscal Year Variant PERIV T009 CHAR 2 0
MTVFP Checking Group for Availability Check MTVFP TMVF CHAR 2 0
WERTU Value Update in Material Master Record WERTU CHAR 1 0
X Yes
NULL No
MENGU Quantity Updating in Material Master Record MENGU CHAR 1 0
X Yes
NULL No
SAUFT Ind.: Repetitive mfg allowed SA_SAUFT CHAR 1 0
X Yes
NULL No
MRPPP PPC planning calendar MRPPP T439G CHAR 3 0
LFRHY Planning cycle LFRHY T439G CHAR 3 0
DISGR MRP Group DISGR T438M CHAR 4 0
PSTAT Maintenance status PSTAT_D CHAR 15 0
VRMOD Consumption mode VRMOD CHAR 1 0
1 Backward consumption only
2 Backward/forward consumption
3 Forward consumption only
4 Forward/backward consumption
VINT1 Consumption period: backward VINT1 NUMC 3 0
VINT2 Consumption period: forward VINT2 NUMC 3 0
FXHOR Planning time fence FXHOR NUMC 3 0
QMATV Inspection Setup Exists for Material/Plant QMATV CHAR 1 0
X Yes
NULL No
PRGRP Planning material VPMAT MARA CHAR 18 0
PRWRK Planning plant VPWRK T001W CHAR 4 0
UMREF Conversion factor: quantities UMREFF FLTP 16 16
PRBME Base unit of measure for product group PRBME T006 UNIT 3 0
TAKZT Takt time TAKZT DEC 3 0
FEVOR Production Supervisor FEVOR T024F CHAR 3 0
RWPRO Range of coverage profile RWPRO T438R CHAR 3 0
KZREV Revision Level Has Been Assigned to the Material KZREV CHAR 1 0
X Yes
NULL No
KZKFG Configurable Material KZKFG CHAR 1 0
X Yes
NULL No
STDPD Configurable material STDPD MARA CHAR 18 0
CUOBJ Internal object number CUOBM NUMC 18 0
CUOBF Internal object number CUOBM NUMC 18 0
LGPRO Issue Storage Location LGPRO T001L CHAR 4 0
SFEPR Repetitive manufacturing profile SFEPR T437S CHAR 4 0
RDPRF Rounding Profile RDPRF CHAR 4 0
STRGR Planning strategy group STRGR T461P CHAR 2 0
LGFSB Default storage location for external procurement LGFSB T001L CHAR 4 0
BSTME Purchase Order Unit of Measure BSTME T006 UNIT 3 0
AUSME Unit of issue AUSME T006 UNIT 3 0
EXPME Unit of measure for commodity code (foreign trade) EXPME T006 UNIT 3 0
FRTME Production unit FRTME T006 UNIT 3 0
SERNP Serial Number Profile SERAIL T377P CHAR 4 0
EPRIO Withdrawal sequence group for stocks EPRIO CHAR 4 0
CUOBV Internal object number of configurable material for planning CUOBV NUMC 18 0
BSEXT External Purchase Orders Allowed BSEXT CHAR 1 0
0 No external purchase orders allowed
1 External purchase orders allowed, but warning issued
2 External purchase orders allowed
BSINT Internal purchase orders allowed BSINT CHAR 1 0
0 No internal purchase orders allowed
1 Internal purchase orders allowed, but warning issued
2 Internal purchase orders allowed
KZGRP Grouping indicator KZGRP CHAR 1 0
1 Product group
2 Free grouping
INSMK Stock Type INSMK CHAR 1 0
NULL Unrestricted use
X Quality inspection
S Blocked stock
RESVP Period of adjustment for planned independent requirements RESVP DEC 3 0
XCHPF Batch management requirement indicator XCHPF CHAR 1 0
X Yes
NULL No
TRAME Stock in Transit TRAME QUAN 13 3
SHFLG Safety time indicator (with or without safety time) SHFLG CHAR 1 0
NULL Ignore safety time
1 Safety time for independent reqmts
2 Safety time for all requirements
SHZET Safety time (in workdays) SHZET NUMC 2 0
MDACH Action control: planned order processing MDACH T46AC CHAR 2 0
BWSCL Source of Supply BWSCL CHAR 1 0
SPART Division SPART CHAR 2 0
ATTYP Material Category ATTYP CHAR 2 0
NULL Single material (industry)
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
SATNR Cross-Plant Configurable Material SATNR CHAR 18 0
KZWSM Units of measure usage KZWSO CHAR 1 0
NULL Alternative unit of measure
A Proportion unit
B Product unit
FABKZ Indicator: Item Relevant to JIT Delivery Schedules FABKZ CHAR 1 0
NULL No JIT
1 Automatically
SERLV Level of Explicitness for Serial Number SERLV CHAR 1 0
NULL Serialization within the stock material number
1 Keep equipment number and serial number synchronous
VSPVB Proposed Supply Area in Material Master Record VSPVB PVBE CHAR 10 0
DPLFS Fair share rule DPLFS CHAR 2 0
A Percentage breakdown
B Percentage fulfilment of target
X User exit
DPLPU Indicator: push distribution DPLPU CHAR 1 0
NULL Pull
P Pull/Push
X Push
DPLHO Deployment horizon in days DPLHO DEC 3 0
MMSTD Date from which the plant-specific material status is valid MMSTD DATS 8 0
MSTAE Cross-Plant Material Status MSTAE T141 CHAR 2 0
MSTDE Date from which the cross-plant material status is valid MSTDE DATS 8 0
MFRPN Manufacturer Part Number MFRPN CHAR 40 0
MFRNR Number of a Manufacturer MFRNR CHAR 10 0
MPROF Manufacturer Part Profile MPROF CHAR 4 0
PRCTR Profit Center PRCTR CHAR 10 0
KZEFF Assign effectivity parameter values/ override change numbers CC_MTEFF CHAR 1 0
X Yes
NULL No
MAABC ABC Indicator MAABC TMABC CHAR 1 0
SHPRO Period Profile for Safety Time SHPRO CHAR 3 0
DIBER Indicator: MRP area exists DIBER CHAR 1 0
X Yes
NULL No
AHDIS MRP relevancy for dependent requirements AHDIS CHAR 1 0
NULL Materials for dependent requirements are planned
1 Materials for dependent requirements are not planned
APOKZ Indicator: Is material relevant for APO APOKZ CHAR 1 0
NULL Material is not relevant to APO
1 ATP check will be carried out in APO for material
2 ATP check and planning will be carried out in APO
3 Is active in APO integration model (set automatically)
SCHGT Indicator: Bulk Material SCHGT CHAR 1 0
X Yes
NULL No
BERID MRP Area BERID CHAR 10 0
KZPSP Indicator for cross-project material KZPSP CHAR 1 0
NULL Check individual segments of project only
1 Check plant segment and all segments of projects
EISLO Minimum Safety Stock EISLO QUAN 13 3
BFLME Generic Material with Logistical Variants BFLME CHAR 1 0
NULL Material is not a logistical variant
1 Generic material with logistical variants
2 Sales variant
3 Procurement variant
BWESB Valuated Goods Receipt Blocked Stock BWESB QUAN 13 3
CON_FIN_VALPROC Valuation Procedure CON_FIN_VALPROC CHAR 3 0

MT61D foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MT61D AUFTL MT61D AUFTL T439P Split-up for forecast requirements AUFTL
MT61D AUFTL SYST MANDT T439P Split-up for forecast requirements MANDT
MT61D AUFTL MT61D WERKS T439P Split-up for forecast requirements WERKS
MT61D AUFTL MT61D PERKZ T439P Split-up for forecast requirements PERKZ
MT61D AUSME SYST MANDT T006 Units of Measurement MANDT
MT61D AUSME MT61D AUSME T006 Units of Measurement MSEHI
MT61D BKLAS SYST MANDT T025 Valuation Classes MANDT
MT61D BKLAS MT61D BKLAS T025 Valuation Classes BKLAS
MT61D BSTME SYST MANDT T006 Units of Measurement MANDT
MT61D BSTME MT61D BSTME T006 Units of Measurement MSEHI
MT61D DISGR SYST MANDT T438M Control Parameter for MRP -Material Level- MANDT
MT61D DISGR MT61D WERKS T438M Control Parameter for MRP -Material Level- WERKS
MT61D DISGR MT61D DISGR T438M Control Parameter for MRP -Material Level- MTART
MT61D DISLS SYST MANDT T439A MRP Lot Sizes MANDT
MT61D DISLS MT61D DISLS T439A MRP Lot Sizes DISLS
MT61D DISMM SYST MANDT T438A MRP Type MANDT
MT61D DISMM MT61D DISMM T438A MRP Type DISMM
MT61D DISPO SYST MANDT T024D MRP controllers MANDT
MT61D DISPO MT61D WERKS T024D MRP controllers WERKS
MT61D DISPO MT61D DISPO T024D MRP controllers DISPO
MT61D EKGRP SYST MANDT T024 Purchasing Groups MANDT
MT61D EKGRP MT61D EKGRP T024 Purchasing Groups EKGRP
MT61D EXPME SYST MANDT T006 Units of Measurement MANDT
MT61D EXPME MT61D EXPME T006 Units of Measurement MSEHI
MT61D FEVOR MT61D FEVOR T024F Production scheduler FEVOR
MT61D FEVOR SYST MANDT T024F Production scheduler MANDT
MT61D FEVOR MT61D WERKS T024F Production scheduler WERKS
MT61D FHORI SYST MANDT T436A Floats for scheduling MANDT
MT61D FHORI MT61D WERKS T436A Floats for scheduling WERKS
MT61D FHORI MT61D FHORI T436A Floats for scheduling FHORI
MT61D FRTME MT61D FRTME T006 Units of Measurement MSEHI
MT61D FRTME SYST MANDT T006 Units of Measurement MANDT
MT61D LAGPR SYST MANDT T439L Warehouse costs for MRP lot size MANDT
MT61D LAGPR MT61D WERKS T439L Warehouse costs for MRP lot size WERKS
MT61D LAGPR MT61D LAGPR T439L Warehouse costs for MRP lot size LAGPR
MT61D LFRHY MT61D WERKS T439G PPplanning periods: header table WERKS
MT61D LFRHY MT61D LFRHY T439G PPplanning periods: header table MRPPP
MT61D LFRHY SYST MANDT T439G PPplanning periods: header table MANDT
MT61D LGFSB MT61D WERKS T001L Storage Locations WERKS
MT61D LGFSB MT61D LGFSB T001L Storage Locations LGORT
MT61D LGFSB SYST MANDT T001L Storage Locations MANDT
MT61D LGPRO SYST MANDT T001L Storage Locations MANDT
MT61D LGPRO MT61D WERKS T001L Storage Locations WERKS
MT61D LGPRO MT61D LGPRO T001L Storage Locations LGORT
MT61D MAABC SYST MANDT TMABC Values Table for the ABC Indicator for Materials MANDT
MT61D MAABC MT61D MAABC TMABC Values Table for the ABC Indicator for Materials MAABC
MT61D MATKL SYST MANDT T023 Material Groups MANDT
MT61D MATKL MT61D MATKL T023 Material Groups MATKL
MT61D MATNR SYST MANDT MARA General Material Data MANDT
MT61D MATNR MT61D MATNR MARA General Material Data MATNR
MT61D MDACH SY MANDT T46AC Action control MANDT
MT61D MDACH MT61D MDACH T46AC Action control MDACH
MT61D MDACH * T46AC Action control ACCFM
MT61D MDACH * T46AC Action control ACCTO
MT61D MEINS SYST MANDT T006 Units of Measurement MANDT
MT61D MEINS MT61D MEINS T006 Units of Measurement MSEHI
MT61D MMSTA MT61D MMSTA T141 Material Status from Materials Management/PPC View MMSTA
MT61D MMSTA SYST MANDT T141 Material Status from Materials Management/PPC View MANDT
MT61D MRPPP SYST MANDT T439G PPplanning periods: header table MANDT
MT61D MRPPP MT61D WERKS T439G PPplanning periods: header table WERKS
MT61D MRPPP MT61D MRPPP T439G PPplanning periods: header table MRPPP
MT61D MSTAE SY MANDT T141 Material Status from Materials Management/PPC View MANDT
MT61D MSTAE MT61D MSTAE T141 Material Status from Materials Management/PPC View MMSTA
MT61D MTART SYST MANDT T134 Material Types MANDT
MT61D MTART MT61D MTART T134 Material Types MTART
MT61D MTVFP SYST MANDT TMVF Availability Check Control MANDT
MT61D MTVFP MT61D MTVFP TMVF Availability Check Control MTVFP
MT61D NFMAT SYST MANDT MARA General Material Data MANDT
MT61D NFMAT MT61D NFMAT MARA General Material Data MATNR
MT61D PERIV MT61D PERIV T009 Fiscal Year Variants PERIV
MT61D PERIV SYST MANDT T009 Fiscal Year Variants MANDT
MT61D PRBME SYST MANDT T006 Units of Measurement MANDT
MT61D PRBME MT61D PRBME T006 Units of Measurement MSEHI
MT61D PRGRP SYST MANDT MARA General Material Data MANDT
MT61D PRGRP MT61D PRGRP MARA General Material Data MATNR
MT61D PRWRK MT61D PRWRK T001W Plants/Branches WERKS
MT61D PRWRK SYST MANDT T001W Plants/Branches MANDT
MT61D RWPRO MT61D WERKS T438R Range of coverage profile WERKS
MT61D RWPRO MT61D RWPRO T438R Range of coverage profile RWPRO
MT61D RWPRO SYST MANDT T438R Range of coverage profile MANDT
MT61D SERNP SYST MANDT T377P Serial Number Management Profiles MANDT
MT61D SERNP MT61D SERNP T377P Serial Number Management Profiles SERAIL
MT61D SFEPR SYST MANDT T437S Repetitive Manufacturing Profile Table MANDT
MT61D SFEPR MT61D SFEPR T437S Repetitive Manufacturing Profile Table SFPRO
MT61D SOBSL SYST MANDT T460A Special procurement key MANDT
MT61D SOBSL MT61D WERKS T460A Special procurement key WERKS
MT61D SOBSL MT61D SOBSL T460A Special procurement key SOBSL
MT61D STDPD MT61D STDPD MARA General Material Data MATNR
MT61D STDPD SYST MANDT MARA General Material Data MANDT
MT61D STRGR MT61D STRGR T461P Planning strategy group STRGR
MT61D STRGR SYST MANDT T461P Planning strategy group MANDT
MT61D USEQU SYST MANDT TMQ2 Quota Arrangement Rules MANDT
MT61D USEQU MT61D USEQU TMQ2 Quota Arrangement Rules USEQU
MT61D VSPVB SYST MANDT PVBE Production Supply Area MANDT
MT61D VSPVB MT61D WERKS PVBE Production Supply Area WERKS
MT61D VSPVB MT61D VSPVB PVBE Production Supply Area PRVBE
MT61D WERKS SYST MANDT T001W Plants/Branches MANDT
MT61D WERKS MT61D WERKS T001W Plants/Branches WERKS