Follow us on LinkedIn for your next SAP project

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 Possible values
MATNR
Material Number
MATNR MARA
CHAR
18 0
WERKS
Plant
WERKS_D T001W
CHAR
4 0
LVORM
Deletion Indicator
LVORM
CHAR
1 0
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
SOBSL
Special procurement type
SOBSL T460A
CHAR
2 0
MISKZ
Mixed MRP indicator
MISKZ
CHAR
1 0
DISST
Low-Level Code
DISST
CHAR
3 0
SBDKZ
Dependent requirements ind. for individual and coll. reqmts
SBDKZ
CHAR
1 0
KZBED
Indicator for Requirements Grouping
KZBED
CHAR
1 0
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
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
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
PERKZ
Period Indicator
PERKZ
CHAR
1 0
AUFTL
Splitting Indicator
AUFTL T439P
CHAR
1 0
KZAUS
Discontinuation indicator
KZAUS
CHAR
1 0
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
BKLAS
Valuation Class
BKLAS T025
CHAR
4 0
VPRSV
Price control indicator
VPRSV
CHAR
1 0
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
MENGU
Quantity Updating in Material Master Record
MENGU
CHAR
1 0
SAUFT
Ind.: Repetitive mfg allowed
SA_SAUFT
CHAR
1 0
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
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
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
KZKFG
Configurable Material
KZKFG
CHAR
1 0
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
BSINT
Internal purchase orders allowed
BSINT
CHAR
1 0
KZGRP
Grouping indicator
KZGRP
CHAR
1 0
INSMK
Stock Type
INSMK
CHAR
1 0
RESVP
Period of adjustment for planned independent requirements
RESVP
DEC
3 0
XCHPF
Batch management requirement indicator
XCHPF
CHAR
1 0
TRAME
Stock in Transit
TRAME
QUAN
13 3
SHFLG
Safety time indicator (with or without safety time)
SHFLG
CHAR
1 0
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
SATNR
Cross-Plant Configurable Material
SATNR
CHAR
18 0
KZWSM
Units of measure usage
KZWSO
CHAR
1 0
FABKZ
Indicator: Item Relevant to JIT Delivery Schedules
FABKZ
CHAR
1 0
SERLV
Level of Explicitness for Serial Number
SERLV
CHAR
1 0
VSPVB
Proposed Supply Area in Material Master Record
VSPVB PVBE
CHAR
10 0
DPLFS
Fair share rule
DPLFS
CHAR
2 0
DPLPU
Indicator: push distribution
DPLPU
CHAR
1 0
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
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
AHDIS
MRP relevancy for dependent requirements
AHDIS
CHAR
1 0
APOKZ
Indicator: Is material relevant for APO
APOKZ
CHAR
1 0
SCHGT
Indicator: Bulk Material
SCHGT
CHAR
1 0
BERID
MRP Area
BERID
CHAR
10 0
KZPSP
Indicator for cross-project material
KZPSP
CHAR
1 0
EISLO
Minimum Safety Stock
EISLO
QUAN
13 3
BFLME
Generic Material with Logistical Variants
BFLME
CHAR
1 0
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 WERKS T439P
Split-up for forecast requirements
WERKS
MT61D AUFTL MT61D PERKZ T439P
Split-up for forecast requirements
PERKZ
MT61D AUFTL MT61D AUFTL T439P
Split-up for forecast requirements
AUFTL
MT61D AUFTL SYST MANDT T439P
Split-up for forecast requirements
MANDT
MT61D AUSME MT61D AUSME T006
Units of Measurement
MSEHI
MT61D AUSME SYST MANDT T006
Units of Measurement
MANDT
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 MT61D DISGR T438M
Control Parameter for MRP -Material Level-
MTART
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 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 MT61D EKGRP T024
Purchasing Groups
EKGRP
MT61D EKGRP SYST MANDT T024
Purchasing Groups
MANDT
MT61D EXPME SYST MANDT T006
Units of Measurement
MANDT
MT61D EXPME MT61D EXPME T006
Units of Measurement
MSEHI
MT61D FEVOR MT61D WERKS T024F
Production scheduler
WERKS
MT61D FEVOR MT61D FEVOR T024F
Production scheduler
FEVOR
MT61D FEVOR SYST MANDT T024F
Production scheduler
MANDT
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 SYST MANDT T006
Units of Measurement
MANDT
MT61D FRTME MT61D FRTME T006
Units of Measurement
MSEHI
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 SYST MANDT T439G
PPplanning periods: header table
MANDT
MT61D LFRHY MT61D WERKS T439G
PPplanning periods: header table
WERKS
MT61D LFRHY MT61D LFRHY T439G
PPplanning periods: header table
MRPPP
MT61D LGFSB SYST MANDT T001L
Storage Locations
MANDT
MT61D LGFSB MT61D WERKS T001L
Storage Locations
WERKS
MT61D LGFSB MT61D LGFSB T001L
Storage Locations
LGORT
MT61D LGPRO MT61D LGPRO T001L
Storage Locations
LGORT
MT61D LGPRO SYST MANDT T001L
Storage Locations
MANDT
MT61D LGPRO MT61D WERKS T001L
Storage Locations
WERKS
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 * T46AC
Action control
ACCTO
MT61D MDACH SY MANDT T46AC
Action control
MANDT
MT61D MDACH MT61D MDACH T46AC
Action control
MDACH
MT61D MDACH * T46AC
Action control
ACCFM
MT61D MEINS SYST MANDT T006
Units of Measurement
MANDT
MT61D MEINS MT61D MEINS T006
Units of Measurement
MSEHI
MT61D MMSTA SYST MANDT T141
Material Status from Materials Management/PPC View
MANDT
MT61D MMSTA MT61D MMSTA T141
Material Status from Materials Management/PPC View
MMSTA
MT61D MRPPP MT61D MRPPP T439G
PPplanning periods: header table
MRPPP
MT61D MRPPP SYST MANDT T439G
PPplanning periods: header table
MANDT
MT61D MRPPP MT61D WERKS T439G
PPplanning periods: header table
WERKS
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 MT61D MTART T134
Material Types
MTART
MT61D MTART SYST MANDT T134
Material Types
MANDT
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 SYST MANDT T009
Fiscal Year Variants
MANDT
MT61D PERIV MT61D PERIV T009
Fiscal Year Variants
PERIV
MT61D PRBME MT61D PRBME T006
Units of Measurement
MSEHI
MT61D PRBME SYST MANDT T006
Units of Measurement
MANDT
MT61D PRGRP SYST MANDT MARA
General Material Data
MANDT
MT61D PRGRP MT61D PRGRP MARA
General Material Data
MATNR
MT61D PRWRK SYST MANDT T001W
Plants/Branches
MANDT
MT61D PRWRK MT61D PRWRK T001W
Plants/Branches
WERKS
MT61D RWPRO SYST MANDT T438R
Range of coverage profile
MANDT
MT61D RWPRO MT61D WERKS T438R
Range of coverage profile
WERKS
MT61D RWPRO MT61D RWPRO T438R
Range of coverage profile
RWPRO
MT61D SERNP MT61D SERNP T377P
Serial Number Management Profiles
SERAIL
MT61D SERNP SYST MANDT T377P
Serial Number Management Profiles
MANDT
MT61D SFEPR MT61D SFEPR T437S
Repetitive Manufacturing Profile Table
SFPRO
MT61D SFEPR SYST MANDT T437S
Repetitive Manufacturing Profile Table
MANDT
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 SYST MANDT MARA
General Material Data
MANDT
MT61D STDPD MT61D STDPD MARA
General Material Data
MATNR
MT61D STRGR SYST MANDT T461P
Planning strategy group
MANDT
MT61D STRGR MT61D STRGR T461P
Planning strategy group
STRGR
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